{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":50874442,"defaultBranch":"main","name":"citus","ownerLogin":"citusdata","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2016-02-01T21:58:39.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/2545424?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1713955938.0","currentOid":""},"activityList":{"items":[{"before":"a6ef91a7794ba00ef7958a75a95011f82bb148af","after":null,"ref":"refs/heads/changelog_12_1_3_release","pushedAt":"2024-04-24T08:15:05.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"}},{"before":"75ff237340398d70e08d271ac6cdcc2ac29223e2","after":"035aa6eada5a1d35454d008711b9b75341d942da","ref":"refs/heads/release-12.1","pushedAt":"2024-04-24T08:15:04.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Bump Citus version to 12.1.3 (#7588)","shortMessageHtmlLink":"Bump Citus version to 12.1.3 (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2256458467\" data-permission-text=\"Title is private\" data-url=\"https://github.com/citusdata/citus/issues/7588\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/citusdata/citus/pull/7588/hovercard\" href=\"https://github.com/citusdata/citus/pull/7588\">#7588</a>)"}},{"before":"de455167f1b5ae780326d41cb721ce62373920f6","after":"a6ef91a7794ba00ef7958a75a95011f82bb148af","ref":"refs/heads/changelog_12_1_3_release","pushedAt":"2024-04-22T13:04:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Bump Citus version to 12.1.3","shortMessageHtmlLink":"Bump Citus version to 12.1.3"}},{"before":null,"after":"de455167f1b5ae780326d41cb721ce62373920f6","ref":"refs/heads/changelog_12_1_3_release","pushedAt":"2024-04-22T12:50:43.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Adds changelog for v12.1.3","shortMessageHtmlLink":"Adds changelog for v12.1.3"}},{"before":"000bc09c885d4127880c4057eff9cbcc4a4a49cf","after":null,"ref":"refs/heads/changelog_12_1_3","pushedAt":"2024-04-22T12:38:52.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"}},{"before":"a0151aa31d7584187a50dfbc19b28bccc76cb616","after":"553d5ba15dd41d129d5f1de8ae6fd9987df5b077","ref":"refs/heads/main","pushedAt":"2024-04-22T12:38:51.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Adds changelog for 12.1.3 (#7587)\n\nCo-authored-by: Onur Tirtir <onurcantirtir@gmail.com>\r\nCo-authored-by: Hanefi Onaldi <Hanefi.Onaldi@microsoft.com>","shortMessageHtmlLink":"Adds changelog for 12.1.3 (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2250176609\" data-permission-text=\"Title is private\" data-url=\"https://github.com/citusdata/citus/issues/7587\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/citusdata/citus/pull/7587/hovercard\" href=\"https://github.com/citusdata/citus/pull/7587\">#7587</a>)"}},{"before":"08c54784ecf714bc78dbec802eb6f9bb037ffcf6","after":"000bc09c885d4127880c4057eff9cbcc4a4a49cf","ref":"refs/heads/changelog_12_1_3","pushedAt":"2024-04-22T10:43:19.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Apply suggestions from code review\n\nCo-authored-by: Hanefi Onaldi <Hanefi.Onaldi@microsoft.com>","shortMessageHtmlLink":"Apply suggestions from code review"}},{"before":"225da3cdd09cfbaa142470fe4f11b0a6328121ba","after":"08c54784ecf714bc78dbec802eb6f9bb037ffcf6","ref":"refs/heads/changelog_12_1_3","pushedAt":"2024-04-22T10:34:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Apply suggestions from code review\n\nCo-authored-by: Onur Tirtir <onurcantirtir@gmail.com>","shortMessageHtmlLink":"Apply suggestions from code review"}},{"before":"824a1724013f9b2486fe4da1f402d6df66e4589e","after":"e089f906b1e58dcbaaa82cbd2ecfe6fee8fef970","ref":"refs/heads/alter_database_nonmain2","pushedAt":"2024-04-19T08:16:52.000Z","pushType":"push","commitsCount":11,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Merge branch 'main' into alter_database_nonmain2","shortMessageHtmlLink":"Merge branch 'main' into alter_database_nonmain2"}},{"before":"43d3b906bba5f656edd6e16b8eac92861b301dbc","after":"824a1724013f9b2486fe4da1f402d6df66e4589e","ref":"refs/heads/alter_database_nonmain2","pushedAt":"2024-04-19T08:01:53.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Apply suggestions from code review\n\nCo-authored-by: Onur Tirtir <onurcantirtir@gmail.com>","shortMessageHtmlLink":"Apply suggestions from code review"}},{"before":"0f38a2918483aab9467c4be2e1961424eaf3120c","after":"43d3b906bba5f656edd6e16b8eac92861b301dbc","ref":"refs/heads/alter_database_nonmain2","pushedAt":"2024-04-19T08:00:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Removes unnecessary empty lines","shortMessageHtmlLink":"Removes unnecessary empty lines"}},{"before":"325acafbb2e5d9dbcc9288d97b0a178318f8f0a4","after":"225da3cdd09cfbaa142470fe4f11b0a6328121ba","ref":"refs/heads/changelog_12_1_3","pushedAt":"2024-04-18T15:29:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Fixes 72 char issues","shortMessageHtmlLink":"Fixes 72 char issues"}},{"before":"a40e3f7a82ed83bd205780ae5324f20853ef231a","after":"325acafbb2e5d9dbcc9288d97b0a178318f8f0a4","ref":"refs/heads/changelog_12_1_3","pushedAt":"2024-04-18T10:36:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Added new entries for the changelog","shortMessageHtmlLink":"Added new entries for the changelog"}},{"before":"f42de2c3cbe5f0e4cfc25de9c01bb09e03014f19","after":"a40e3f7a82ed83bd205780ae5324f20853ef231a","ref":"refs/heads/changelog_12_1_3","pushedAt":"2024-04-18T10:24:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Fixes review notes","shortMessageHtmlLink":"Fixes review notes"}},{"before":"eb6cb8366f4bfc234706d22670066183960a2c45","after":"f42de2c3cbe5f0e4cfc25de9c01bb09e03014f19","ref":"refs/heads/changelog_12_1_3","pushedAt":"2024-04-18T10:17:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Adds an additional changelog item","shortMessageHtmlLink":"Adds an additional changelog item"}},{"before":null,"after":"eb6cb8366f4bfc234706d22670066183960a2c45","ref":"refs/heads/changelog_12_1_3","pushedAt":"2024-04-18T09:09:49.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"gurkanindibay","name":"Gürkan İndibay","path":"/gurkanindibay","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1596331?s=80&v=4"},"commit":{"message":"Adds changelog for 12.1.3","shortMessageHtmlLink":"Adds changelog for 12.1.3"}},{"before":"3cf6f86de2696d908c26f3697f81456f4ca1a8f8","after":null,"ref":"refs/heads/release-12.1-jelte","pushedAt":"2024-04-17T08:26:51.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"}},{"before":"e2d18c5472379a4dd1b2f27ed0559fa815d21a59","after":"75ff237340398d70e08d271ac6cdcc2ac29223e2","ref":"refs/heads/release-12.1","pushedAt":"2024-04-17T08:26:50.000Z","pushType":"pr_merge","commitsCount":27,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"},"commit":{"message":"Removes unnecessary package installations in packaging pipelines (#7341)\n\nWith the recent changes in packaging images, linux package installations\nto execute validate_output is unnecessary now.\nIn this PR, I removed them to make the pipeline more effective.\n\n- [x] Remove the test warning before merge\n\n(cherry picked from commit 32b0fc23f5b5f439f62defbd80cb09b5294e97ac)","shortMessageHtmlLink":"Removes unnecessary package installations in packaging pipelines (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1990014346\" data-permission-text=\"Title is private\" data-url=\"https://github.com/citusdata/citus/issues/7341\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/citusdata/citus/pull/7341/hovercard\" href=\"https://github.com/citusdata/citus/pull/7341\">#7341</a>)"}},{"before":"2e5de54e4312305285ab0d3b1678cc0c4ea8e412","after":"3cf6f86de2696d908c26f3697f81456f4ca1a8f8","ref":"refs/heads/release-12.1-jelte","pushedAt":"2024-04-16T21:11:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"},"commit":{"message":"Removes unnecessary package installations in packaging pipelines (#7341)\n\nWith the recent changes in packaging images, linux package installations\nto execute validate_output is unnecessary now.\nIn this PR, I removed them to make the pipeline more effective.\n\n- [x] Remove the test warning before merge\n\n(cherry picked from commit 32b0fc23f5b5f439f62defbd80cb09b5294e97ac)","shortMessageHtmlLink":"Removes unnecessary package installations in packaging pipelines (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1990014346\" data-permission-text=\"Title is private\" data-url=\"https://github.com/citusdata/citus/issues/7341\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/citusdata/citus/pull/7341/hovercard\" href=\"https://github.com/citusdata/citus/pull/7341\">#7341</a>)"}},{"before":"cc3d0545f67e88d686e8123bd6fa46ce9da663ca","after":"2e5de54e4312305285ab0d3b1678cc0c4ea8e412","ref":"refs/heads/release-12.1-jelte","pushedAt":"2024-04-16T16:47:18.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"},"commit":{"message":"Removes centos 7 for PG 16 in packaging pipelines (#7205)\n\ncentos 7 and oracle 7 is not being supported for newer releases by\nPostgres. Therefore, getting package download errors in packaging\npipelines.\nThis PR removes el/7 and ol/7 Postgres 16 pipelines\n\n(cherry picked from commit b0e982d0b5e9b3f3cb1ca526ae8388b2576e6734)","shortMessageHtmlLink":"Removes centos 7 for PG 16 in packaging pipelines (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1898409668\" data-permission-text=\"Title is private\" data-url=\"https://github.com/citusdata/citus/issues/7205\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/citusdata/citus/pull/7205/hovercard\" href=\"https://github.com/citusdata/citus/pull/7205\">#7205</a>)"}},{"before":"d971b1f75de9d2c7ba4d6d6f96f0df8dadb5295d","after":"cc3d0545f67e88d686e8123bd6fa46ce9da663ca","ref":"refs/heads/release-12.1-jelte","pushedAt":"2024-04-16T15:46:46.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"},"commit":{"message":"Greatly speed up \"\\d tablename\" on servers with many tables (#7577)\n\nDESCRIPTION: Fix performance issue when using \"\\d tablename\" on a server\nwith many tables\n\nWe introduce a filter to every query on pg_class to automatically remove\nshards. This is useful to make sure \\d and PgAdmin are not cluttered\nwith shards. However, the way we were introducing this filter was using\n`securityQuals` which can have negative impact on query performance.\n\nOn clusters with 100k+ tables this could cause a simple \"\\d tablename\"\ncommand to take multiple seconds, because a skipped optimization by\nPostgres causes a full table scan. This changes the code to introduce\nthis filter in the regular `quals` list instead of in `securityQuals`.\nWhich causes Postgres to use the intended optimization again.\n\nFor reference, this was initially reported as a Postgres issue by me:\n\nhttps://www.postgresql.org/message-id/flat/4189982.1712785863%40sss.pgh.pa.us#b87421293b362d581ea8677e3bfea920\n(cherry picked from commit a0151aa31d7584187a50dfbc19b28bccc76cb616)","shortMessageHtmlLink":"Greatly speed up \"\\d tablename\" on servers with many tables (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2237395031\" data-permission-text=\"Title is private\" data-url=\"https://github.com/citusdata/citus/issues/7577\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/citusdata/citus/pull/7577/hovercard\" href=\"https://github.com/citusdata/citus/pull/7577\">#7577</a>)"}},{"before":"77d33f87fae8d51354ea3117270350f5006b8c69","after":"d971b1f75de9d2c7ba4d6d6f96f0df8dadb5295d","ref":"refs/heads/release-12.1-jelte","pushedAt":"2024-04-16T15:40:28.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"},"commit":{"message":"Greatly speed up \"\\d tablename\" on servers with many tables (#7577)\n\nDESCRIPTION: Fix performance issue when using \"\\d tablename\" on a server\nwith many tables\n\nWe introduce a filter to every query on pg_class to automatically remove\nshards. This is useful to make sure \\d and PgAdmin are not cluttered\nwith shards. However, the way we were introducing this filter was using\n`securityQuals` which can have negative impact on query performance.\n\nOn clusters with 100k+ tables this could cause a simple \"\\d tablename\"\ncommand to take multiple seconds, because a skipped optimization by\nPostgres causes a full table scan. This changes the code to introduce\nthis filter in the regular `quals` list instead of in `securityQuals`.\nWhich causes Postgres to use the intended optimization again.\n\nFor reference, this was initially reported as a Postgres issue by me:\n\nhttps://www.postgresql.org/message-id/flat/4189982.1712785863%40sss.pgh.pa.us#b87421293b362d581ea8677e3bfea920\n(cherry picked from commit a0151aa31d7584187a50dfbc19b28bccc76cb616)","shortMessageHtmlLink":"Greatly speed up \"\\d tablename\" on servers with many tables (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2237395031\" data-permission-text=\"Title is private\" data-url=\"https://github.com/citusdata/citus/issues/7577\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/citusdata/citus/pull/7577/hovercard\" href=\"https://github.com/citusdata/citus/pull/7577\">#7577</a>)"}},{"before":"fc909f25c15c228e393330bfc3b9baa9463e9893","after":"77d33f87fae8d51354ea3117270350f5006b8c69","ref":"refs/heads/release-12.1-jelte","pushedAt":"2024-04-16T15:32:09.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"},"commit":{"message":"Greatly speed up \"\\d tablename\" on servers with many tables (#7577)\n\nDESCRIPTION: Fix performance issue when using \"\\d tablename\" on a server\nwith many tables\n\nWe introduce a filter to every query on pg_class to automatically remove\nshards. This is useful to make sure \\d and PgAdmin are not cluttered\nwith shards. However, the way we were introducing this filter was using\n`securityQuals` which can have negative impact on query performance.\n\nOn clusters with 100k+ tables this could cause a simple \"\\d tablename\"\ncommand to take multiple seconds, because a skipped optimization by\nPostgres causes a full table scan. This changes the code to introduce\nthis filter in the regular `quals` list instead of in `securityQuals`.\nWhich causes Postgres to use the intended optimization again.\n\nFor reference, this was initially reported as a Postgres issue by me:\n\nhttps://www.postgresql.org/message-id/flat/4189982.1712785863%40sss.pgh.pa.us#b87421293b362d581ea8677e3bfea920\n(cherry picked from commit a0151aa31d7584187a50dfbc19b28bccc76cb616)","shortMessageHtmlLink":"Greatly speed up \"\\d tablename\" on servers with many tables (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2237395031\" data-permission-text=\"Title is private\" data-url=\"https://github.com/citusdata/citus/issues/7577\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/citusdata/citus/pull/7577/hovercard\" href=\"https://github.com/citusdata/citus/pull/7577\">#7577</a>)"}},{"before":"a7979f08c74c071bffe86c7604a8f780e2bb0fd0","after":"fc909f25c15c228e393330bfc3b9baa9463e9893","ref":"refs/heads/release-12.1-jelte","pushedAt":"2024-04-16T15:30:29.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"},"commit":{"message":"Log username in the failed connection message (#7432)\n\nThis patch includes the username in the reported error message.\nThis makes debugging easier when certain commands open connections\nas other users than the user that is executing the command.\n\n```\nmonitora_snapshot=# SELECT citus_move_shard_placement(102030, 'monitora.db-dev-worker-a', 6005, 'monitora.db-dev-worker-a', 6017);\nERROR:  connection to the remote node monitora_user@monitora.db-dev-worker-a:6017 failed with the following error: fe_sendauth: no password supplied\nTime: 40,198 ms\n```\n\n(cherry picked from commit 8b48d6ab0298d80ded17a6721e187b627f647c91)","shortMessageHtmlLink":"Log username in the failed connection message (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2090579711\" data-permission-text=\"Title is private\" data-url=\"https://github.com/citusdata/citus/issues/7432\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/citusdata/citus/pull/7432/hovercard\" href=\"https://github.com/citusdata/citus/pull/7432\">#7432</a>)"}},{"before":"e588bbb22435532ad7a334dfdf5a1b665caec66e","after":null,"ref":"refs/heads/speed-up-backslash-d","pushedAt":"2024-04-16T15:26:13.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"}},{"before":"ada3ba25072cc5be055b3bbdedfa2fe936443b0d","after":"a0151aa31d7584187a50dfbc19b28bccc76cb616","ref":"refs/heads/main","pushedAt":"2024-04-16T15:26:12.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"},"commit":{"message":"Greatly speed up \"\\d tablename\" on servers with many tables (#7577)\n\nDESCRIPTION: Fix performance issue when using \"\\d tablename\" on a server\r\nwith many tables\r\n\r\nWe introduce a filter to every query on pg_class to automatically remove\r\nshards. This is useful to make sure \\d and PgAdmin are not cluttered\r\nwith shards. However, the way we were introducing this filter was using\r\n`securityQuals` which can have negative impact on query performance.\r\n\r\nOn clusters with 100k+ tables this could cause a simple \"\\d tablename\"\r\ncommand to take multiple seconds, because a skipped optimization by\r\nPostgres causes a full table scan. This changes the code to introduce\r\nthis filter in the regular `quals` list instead of in `securityQuals`.\r\nWhich causes Postgres to use the intended optimization again.\r\n\r\nFor reference, this was initially reported as a Postgres issue by me:\r\n\r\nhttps://www.postgresql.org/message-id/flat/4189982.1712785863%40sss.pgh.pa.us#b87421293b362d581ea8677e3bfea920","shortMessageHtmlLink":"Greatly speed up \"\\d tablename\" on servers with many tables (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2237395031\" data-permission-text=\"Title is private\" data-url=\"https://github.com/citusdata/citus/issues/7577\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/citusdata/citus/pull/7577/hovercard\" href=\"https://github.com/citusdata/citus/pull/7577\">#7577</a>)"}},{"before":"ad06631c957b62a95aa707d53a98732bdbc94afb","after":"e588bbb22435532ad7a334dfdf5a1b665caec66e","ref":"refs/heads/speed-up-backslash-d","pushedAt":"2024-04-16T15:07:56.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"},"commit":{"message":"Fix comments and add handle INSERTs on pg_class correctly","shortMessageHtmlLink":"Fix comments and add handle INSERTs on pg_class correctly"}},{"before":"8184d136faac7afb43341f194c793a9d1d90ef9e","after":"ad06631c957b62a95aa707d53a98732bdbc94afb","ref":"refs/heads/speed-up-backslash-d","pushedAt":"2024-04-16T15:05:58.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"},"commit":{"message":"Fix comments and add handle INSERTs on pg_class correctly","shortMessageHtmlLink":"Fix comments and add handle INSERTs on pg_class correctly"}},{"before":"41e2af8ff5d86c9b327b96cd57f08d26777b7d13","after":"ada3ba25072cc5be055b3bbdedfa2fe936443b0d","ref":"refs/heads/main","pushedAt":"2024-04-16T13:29:14.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"},"commit":{"message":"Add missing volatile qualifier. (#7570)\n\nVariables being modified in the PG_TRY block and read in the PG_CATCH\r\nblock should be qualified with volatile.\r\n\r\nThe variable waitEventSet is modified in the PG_TRY block (line 1085)\r\nand read in the PG_CATCH block (line 1095).\r\n\r\nThe variable relation is modified in the PG_TRY block (line 500) and\r\nread in the PG_CATCH block (line 515).\r\n\r\nBesides, the variable objectAddress doesn't need the volatile qualifier.\r\n\r\nRef: C99 7.13.2.1[^1],\r\n\r\n> All accessible objects have values, and all other components of the\r\nabstract machine have state, as of the time the longjmp function was\r\ncalled, except that the values of objects of automatic storage duration\r\nthat are local to the function containing the invocation of the\r\ncorresponding setjmp macro that do not have volatile-qualified type and\r\nhave been changed between the setjmp invocation and longjmp call are\r\nindeterminate.\r\n\r\n[^1]: https://www.open-std.org/jtc1/sc22/wg14/www/docs/n1256.pdf\r\n\r\nDESCRIPTION: Correctly mark some variables as volatile\r\n\r\n---------\r\n\r\nCo-authored-by: Hong Yi <zouzou0208@gmail.com>","shortMessageHtmlLink":"Add missing volatile qualifier. (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2220572301\" data-permission-text=\"Title is private\" data-url=\"https://github.com/citusdata/citus/issues/7570\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/citusdata/citus/pull/7570/hovercard\" href=\"https://github.com/citusdata/citus/pull/7570\">#7570</a>)"}},{"before":"1ace39d72d7486391f81a82c124c55dcb9696973","after":"8184d136faac7afb43341f194c793a9d1d90ef9e","ref":"refs/heads/speed-up-backslash-d","pushedAt":"2024-04-16T12:02:06.000Z","pushType":"push","commitsCount":8,"pusher":{"login":"JelteF","name":"Jelte Fennema-Nio","path":"/JelteF","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1162278?s=80&v=4"},"commit":{"message":"Merge branch 'main' into speed-up-backslash-d","shortMessageHtmlLink":"Merge branch 'main' into speed-up-backslash-d"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEOOBBHAA","startCursor":null,"endCursor":null}},"title":"Activity · citusdata/citus"}