{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":6633165,"defaultBranch":"master","name":"pg_repack","ownerLogin":"reorg","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2012-11-10T22:39:27.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/2398964?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1716283873.0","currentOid":""},"activityList":{"items":[{"before":"f3e6353383f949904dea65b9228ec6ac48904f1f","after":"f89c26123c7b7b6cee5100ab0005ee06143a6620","ref":"refs/heads/master","pushedAt":"2024-05-21T13:32:30.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"MasahikoSawada","name":"masahiko","path":"/MasahikoSawada","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4269963?s=80&v=4"},"commit":{"message":"Merge pull request #401 from MasahikoSawada/fix_tx_error_in_lock_access_share\n\nUse savepoints when retrying to take AccessShareLock.","shortMessageHtmlLink":"Merge pull request #401 from MasahikoSawada/fix_tx_error_in_lock_acce…"}},{"before":"cfa429a46ea6a29561f970494f4de671a2dcdf2e","after":"f3e6353383f949904dea65b9228ec6ac48904f1f","ref":"refs/heads/master","pushedAt":"2024-05-21T13:31:34.000Z","pushType":"pr_merge","commitsCount":4,"pusher":{"login":"MasahikoSawada","name":"masahiko","path":"/MasahikoSawada","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4269963?s=80&v=4"},"commit":{"message":"Merge pull request #400 from MasahikoSawada/fix_concurrent_vacuums\n\nFix possible two vacuums concurrently processing the same relfilenode.","shortMessageHtmlLink":"Merge pull request #400 from MasahikoSawada/fix_concurrent_vacuums"}},{"before":"3792badbf191cb55a551d8144c352ef33d2bca7f","after":null,"ref":"refs/heads/fix_relfrozenxid","pushedAt":"2024-05-21T09:31:13.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"}},{"before":"b583237d740cd07592feb6188f7b936336413427","after":"cfa429a46ea6a29561f970494f4de671a2dcdf2e","ref":"refs/heads/master","pushedAt":"2024-05-21T09:31:09.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Fix swap of relfrozenxid, relfrozenxid and relallvisible (#377)\n\nThis PR is follow up of #157.\r\n- Fixed the typo: https://github.com/reorg/pg_repack/pull/157#issuecomment-1519195513\r\n- Removed `PG_VERSION_NUM >= 90300` check since we don't support such old versions anyway\r\n- Added check `relform1->relkind != RELKIND_INDEX` since `relfrozenxid` and `relminmxid` is non-zero only for tables\r\n\r\n---------\r\n\r\nCo-authored-by: Alexey Bashtanov ","shortMessageHtmlLink":"Fix swap of relfrozenxid, relfrozenxid and relallvisible (#377)"}},{"before":"1b5daa9b5fdf94d2eae729316a94a1b4e36e2f37","after":"3792badbf191cb55a551d8144c352ef33d2bca7f","ref":"refs/heads/fix_relfrozenxid","pushedAt":"2024-05-20T21:42:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Rename swaptempxid to fronzenxid, add minmxid","shortMessageHtmlLink":"Rename swaptempxid to fronzenxid, add minmxid"}},{"before":"7f84c5a1320ef67990197fa286452b80f23fc7cb","after":null,"ref":"refs/heads/issue_389_concurrent_index","pushedAt":"2024-05-17T15:59:01.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"}},{"before":"aae9f2f787e79b3923fa7309403a30ac56928b91","after":"b583237d740cd07592feb6188f7b936336413427","ref":"refs/heads/master","pushedAt":"2024-05-17T15:58:57.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Issue #389: Do not include a declaratively partitioned table with option `--only-indexes` (#398)\n\nWhen the option --only-indexes is used it doesn't make sense to repack indexes of a decoratively partitioned table since they don't store data. Therefore we can just ignore parent tables within the function repack_all_indexes().\r\n\r\nIssue: #389","shortMessageHtmlLink":"Issue #389: Do not include a declaratively partitioned table with opt…"}},{"before":"43ff7e3a1c57fe926c68dd78af7358cbaf39c5b4","after":"7f84c5a1320ef67990197fa286452b80f23fc7cb","ref":"refs/heads/issue_389_concurrent_index","pushedAt":"2024-05-16T22:42:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Fix test case for Postgres 9.5","shortMessageHtmlLink":"Fix test case for Postgres 9.5"}},{"before":"4221a11df687c92b6354390b06d8e3771480e03e","after":"43ff7e3a1c57fe926c68dd78af7358cbaf39c5b4","ref":"refs/heads/issue_389_concurrent_index","pushedAt":"2024-05-16T22:39:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Add test case for Postgres 9.5","shortMessageHtmlLink":"Add test case for Postgres 9.5"}},{"before":"0a05d4e86bc9305c78f1d74583190cc0f1312efa","after":"4221a11df687c92b6354390b06d8e3771480e03e","ref":"refs/heads/issue_389_concurrent_index","pushedAt":"2024-05-16T22:28:48.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Adapt tests for Postgres 10","shortMessageHtmlLink":"Adapt tests for Postgres 10"}},{"before":null,"after":"0a05d4e86bc9305c78f1d74583190cc0f1312efa","ref":"refs/heads/issue_389_concurrent_index","pushedAt":"2024-05-16T17:39:26.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Issue #389: Do not include a declaratively partitioned table with option --only-indexes","shortMessageHtmlLink":"Issue #389: Do not include a declaratively partitioned table with opt…"}},{"before":"cd7efb42064dfff4e24d4c58537b1d9ebd1daa25","after":"aae9f2f787e79b3923fa7309403a30ac56928b91","ref":"refs/heads/master","pushedAt":"2024-04-15T18:42:53.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Add apply-count parameter (#392)\n\n- Add a new apply-count command line parameter to allow tuning of the REDO apply_count variable.\r\n- Check on startup that switch_threshold is not greater or equal to apply_count, which would cause REDO to stop after the first apply_log call (fwiw this bug also exists in 1.5.0, since switch_threshold parameter was added but was not checked against the default APPLY_COUNT of 1000).\r\n- Tuning apply_count might be useful for improving REDO performance on tables with small tuples that receive lots of updates.\r\n- Fixes https://github.com/reorg/pg_repack/issues/393","shortMessageHtmlLink":"Add apply-count parameter (#392)"}},{"before":"90da0a2d52e4ee45201a11e27557e029c1da5677","after":"cd7efb42064dfff4e24d4c58537b1d9ebd1daa25","ref":"refs/heads/master","pushedAt":"2024-04-14T20:30:50.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"Melkij","name":"Melkij","path":"/Melkij","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1183692?s=80&v=4"},"commit":{"message":"Merge pull request #390 from Melkij/support_for_postgresql_17\n\nSupport for postgresql 17","shortMessageHtmlLink":"Merge pull request #390 from Melkij/support_for_postgresql_17"}},{"before":"733adbcf44ab2985387f0b8c06344c62e309fa18","after":null,"ref":"refs/heads/issue_383_whitespace_in_password","pushedAt":"2024-04-14T17:06:53.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"}},{"before":"7da53026e23c9810ec0e81af68cfffde928481f1","after":"90da0a2d52e4ee45201a11e27557e029c1da5677","ref":"refs/heads/master","pushedAt":"2024-04-14T17:06:48.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Replace `PQconnectdb()` by `PQconnectdbParams()` (#384)\n\nCurrently pg_repack calls `PQconnectdb()` to connect to a database. The drawback is that it is necessary to pass a connection, and all unexpected characters should be escaped.\r\npg_repack has separate options for connection parameters (host, port, dbname, etc) and it isn't necessary to use `PQconnectdb()`. More robust and solid approach is to use `PQconnectdbParams()`, which accepts connection parameters as two arrays of values and it doesn't require escaping value strings.","shortMessageHtmlLink":"Replace PQconnectdb() by PQconnectdbParams() (#384)"}},{"before":"135df8b6a6a3b145439315b18539e583cf9fec5c","after":"733adbcf44ab2985387f0b8c06344c62e309fa18","ref":"refs/heads/issue_383_whitespace_in_password","pushedAt":"2024-04-11T14:04:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Delete unnecessary StringInfo","shortMessageHtmlLink":"Delete unnecessary StringInfo"}},{"before":"027811cdbe058d5cb83054e1a4de3eae63b69eb0","after":"135df8b6a6a3b145439315b18539e583cf9fec5c","ref":"refs/heads/issue_383_whitespace_in_password","pushedAt":"2024-04-11T13:09:02.000Z","pushType":"push","commitsCount":4,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Use `PQconnectdbParams()` instead of `PQconnectdb()`","shortMessageHtmlLink":"Use PQconnectdbParams() instead of PQconnectdb()"}},{"before":"9a96bfad01784aa3535b2c754b712be2b82ffc87","after":null,"ref":"refs/heads/issue_386_tablespace_quote_indent","pushedAt":"2024-03-12T11:52:47.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"}},{"before":"6a3c2820ee9986d3c85e237e72ccb9336dcd4187","after":"7da53026e23c9810ec0e81af68cfffde928481f1","ref":"refs/heads/master","pushedAt":"2024-03-12T11:52:44.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Issue 386: Do not call quote_ident() within repack_one_database() (#387)\n\nIt isn't necessary to call `quote_ident()` within `repack_one_database()`. `tablespace_dest` is passed to `repack.create_table()`, which already calls `quote_ident()`.\r\n\r\n`quote_ident()` within `repack_one_database()` can return quoted `tablespace_dest`, calling `quote_ident()` second time will make unexpected tablespace name with surrounding quotes.\r\n\r\nTests were added.","shortMessageHtmlLink":"Issue 386: Do not call quote_ident() within repack_one_database() (#387)"}},{"before":"d6912c92e0da247c5548fcc8dcb703fddcaf4848","after":"9a96bfad01784aa3535b2c754b712be2b82ffc87","ref":"refs/heads/issue_386_tablespace_quote_indent","pushedAt":"2024-03-11T15:41:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Adding more unusual tablespaces names per @andreasscherbaum","shortMessageHtmlLink":"Adding more unusual tablespaces names per @andreasscherbaum"}},{"before":"f0a6e5ba4bcc67fdcfe83d8599fdf2572130f366","after":"d6912c92e0da247c5548fcc8dcb703fddcaf4848","ref":"refs/heads/issue_386_tablespace_quote_indent","pushedAt":"2024-03-11T13:52:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Fix tablespace name in the workflow","shortMessageHtmlLink":"Fix tablespace name in the workflow"}},{"before":null,"after":"f0a6e5ba4bcc67fdcfe83d8599fdf2572130f366","ref":"refs/heads/issue_386_tablespace_quote_indent","pushedAt":"2024-03-11T13:47:08.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Issue 386: Do not call quote_ident() within repack_one_database()","shortMessageHtmlLink":"Issue 386: Do not call quote_ident() within repack_one_database()"}},{"before":"c081a6bc22fb292ad93f5c4d13939fb9ba17a607","after":null,"ref":"refs/heads/issue_282_covering_index","pushedAt":"2024-02-28T21:33:11.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"}},{"before":"3ecda64dbf3084b9071a44d893ffa3f1487c2193","after":"6a3c2820ee9986d3c85e237e72ccb9336dcd4187","ref":"refs/heads/master","pushedAt":"2024-02-28T21:33:05.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Issue 282: Fix check of NOT NULL by repack.primary_keys (#376)\n\nPostgreSQL 11 introduced covering indexes. pg_repack couldn't\r\nuse indexes which include additional columns because all\r\ncolumns are listed in `pg_index.indkey`. To overcome this\r\nit is necessary to consider `pg_index.indnkeyatts` value.","shortMessageHtmlLink":"Issue 282: Fix check of NOT NULL by repack.primary_keys (#376)"}},{"before":null,"after":"027811cdbe058d5cb83054e1a4de3eae63b69eb0","ref":"refs/heads/issue_383_whitespace_in_password","pushedAt":"2024-02-28T14:29:42.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Quote passwords in a connection string","shortMessageHtmlLink":"Quote passwords in a connection string"}},{"before":null,"after":"1b5daa9b5fdf94d2eae729316a94a1b4e36e2f37","ref":"refs/heads/fix_relfrozenxid","pushedAt":"2024-01-05T14:50:57.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Fix typos and don't use PG_VERSION_NUM condition","shortMessageHtmlLink":"Fix typos and don't use PG_VERSION_NUM condition"}},{"before":"624745b4bf7df34ae614632c6d8d47da4a26eb1c","after":"3ecda64dbf3084b9071a44d893ffa3f1487c2193","ref":"refs/heads/master","pushedAt":"2023-12-15T20:47:04.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"Melkij","name":"Melkij","path":"/Melkij","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1183692?s=80&v=4"},"commit":{"message":"Merge pull request #375 from Melkij/bug_oid_should_be_unsigned\n\nFix wrong OID format type in repack_trigger","shortMessageHtmlLink":"Merge pull request #375 from Melkij/bug_oid_should_be_unsigned"}},{"before":"e3d132b3d6da164234f0a6b6b2801b8b4807e95e","after":"c081a6bc22fb292ad93f5c4d13939fb9ba17a607","ref":"refs/heads/issue_282_covering_index","pushedAt":"2023-12-14T14:58:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Fix tests for PostgreSQL 9.6","shortMessageHtmlLink":"Fix tests for PostgreSQL 9.6"}},{"before":null,"after":"e3d132b3d6da164234f0a6b6b2801b8b4807e95e","ref":"refs/heads/issue_282_covering_index","pushedAt":"2023-12-14T14:51:25.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"},"commit":{"message":"Issue 282: Fix check of NOT NULL by repack.primary_keys\n\nPostgreSQL 11 introduced covering indexes. pg_repack couldn't\nuse indexes which include additional columns because all\ncolumns are listed in `pg_index.indkey`. To overcome this\nit is necessary to consider `pg_index.indnkeyatts` value.","shortMessageHtmlLink":"Issue 282: Fix check of NOT NULL by repack.primary_keys"}},{"before":"bbf95da5f9e879ad39d410d50e6c016f7819cf82","after":null,"ref":"refs/heads/issue_338_update_pg_versions","pushedAt":"2023-11-29T09:34:08.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"za-arthur","name":"Artur Zakirov","path":"/za-arthur","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12584379?s=80&v=4"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAET-VD0AA","startCursor":null,"endCursor":null}},"title":"Activity · reorg/pg_repack"}