{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":471375640,"defaultBranch":"master","name":"postgres","ownerLogin":"zhjwpku","currentUserCanPush":false,"isFork":true,"isEmpty":false,"createdAt":"2022-03-18T13:19:20.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/12639404?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1722939666.0","currentOid":""},"activityList":{"items":[{"before":null,"after":"b9f43055f24ecd80ce470024915a30ed5b0aa8ab","ref":"refs/heads/support_specify_tablespace_for_each_merged_split_partition","pushedAt":"2024-08-06T10:21:06.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"fix stale comments\n\nPartitionCmd is used by ALTER TABLE/INDEX ATTACH/DETACH/MERGE/SPLIT,\nthe comments do not reflect that.\n\nSigned-off-by: Your Name <email@example.com>","shortMessageHtmlLink":"fix stale comments"}},{"before":"a3a836fb5e51183eae624d43225279306c2285b8","after":"cdd6ab9d1f5396ec1097d51c21a224aa41118c9c","ref":"refs/heads/master","pushedAt":"2024-07-28T13:29:10.000Z","pushType":"push","commitsCount":1407,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"amcheck: Optimize speed of checking for unique constraint violation\n\nCurrently, when amcheck validates a unique constraint, it visits the heap for\neach index tuple.  This commit implements skipping keys, which have only one\nnon-dedeuplicated index tuple (quite common case for unique indexes). That\ngives substantial economy on index checking time.\n\nReported-by: Noah Misch\nDiscussion: https://postgr.es/m/20240325020323.fd.nmisch%40google.com\nAuthor: Alexander Korotkov, Pavel Borisov","shortMessageHtmlLink":"amcheck: Optimize speed of checking for unique constraint violation"}},{"before":"2cca95e175463a7af95164498b889b1ea118583d","after":"a3a836fb5e51183eae624d43225279306c2285b8","ref":"refs/heads/master","pushedAt":"2024-01-28T10:09:23.000Z","pushType":"push","commitsCount":11,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Attempt to fix newly added Memoize regression test\n\nBoth drongo and fairywren seem not to like a new regression test added\nby 2cca95e17.  These machines show a different number of actual rows in\nthe EXPLAIN ANALYZE output.  Since the number of actual rows is divided by\nthe number of loops, I suspect this might be due to some platform\ndependant rounding behavior as the total row count is 5 and the number of\nloops is 2.  drongo and fairywren seem to be calculating that 5.0 / 2.0 is\n3, whereas most other machines think the answer is 2.\n\nHere we tweak the test query's WHERE clause so it's 4.0 / 2.0 instead.\nThere shouldn't be too much wiggle room for platform dependant-behavior to\nbe a factor with those numbers.\n\nReported-by: Tom Lane\nDiscussion: https://postgr.es/m/1035225.1706301718%40sss.pgh.pa.us","shortMessageHtmlLink":"Attempt to fix newly added Memoize regression test"}},{"before":null,"after":"7dc6c1c798178f31728d048d4d528181626b3695","ref":"refs/heads/extensible_copy","pushedAt":"2024-01-27T05:36:01.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"introduce contrib/pg_copy_json\n\nSigned-off-by: Zhao Junwang <zhjwpku@gmail.com>","shortMessageHtmlLink":"introduce contrib/pg_copy_json"}},{"before":"7636725b922c8cd68f21d040f3542d3bce9c68a4","after":"2cca95e175463a7af95164498b889b1ea118583d","ref":"refs/heads/master","pushedAt":"2024-01-26T03:32:30.000Z","pushType":"push","commitsCount":323,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Improve NestLoopParam generation for lateral subqueries\n\nIt was possible in cases where we had a LATERAL joined subquery that\nwhen the same Var is mentioned in both the lateral references and in the\nouter Vars of the scan clauses that the given Var wouldn't be assigned\nto the same NestLoopParam.\n\nThis could cause issues in Memoize as the cache key would reference the\nVar for the scan clauses but when the parameter for the lateral references\nchanged some code in Memoize would see that some other parameter had\nchanged that's not part of the cache key and end up purging the entire\ncache as a result, thinking the cache had become stale.  This could\nresult in a Nested Loop -> Memoize plan being quite inefficient as, in\nthe worst case, the cache purging could result in never getting a cache\nhit.  In no cases could this problem lead to incorrect query results.\n\nHere we switch the order of operations so that we create NestLoopParam\nfor the lateral references first before doing replace_nestloop_params().\nreplace_nestloop_params() will find and reuse the existing NestLoopParam\nin cases where the Var exists in both locations.\n\nAuthor: Richard Guo\nReviewed-by: Tom Lane, David Rowley\nDiscussion: https://postgr.es/m/CAMbWs48XHJEK1Q1CzAQ7L9sTANTs9W1cepXu8%3DKc0quUL%2Btg4Q%40mail.gmail.com","shortMessageHtmlLink":"Improve NestLoopParam generation for lateral subqueries"}},{"before":"543c809ac2086d421fc48792a6f197ac35f06fa4","after":"9e5d261b17e395a87b7bdcd4555d6b4bf49c844e","ref":"refs/heads/transaction_timeout","pushedAt":"2023-12-29T10:41:42.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"fix reschedule timeout for each commmand\n\nSigned-off-by: Zhao Junwang <zhjwpku@gmail.com>","shortMessageHtmlLink":"fix reschedule timeout for each commmand"}},{"before":null,"after":"543c809ac2086d421fc48792a6f197ac35f06fa4","ref":"refs/heads/transaction_timeout","pushedAt":"2023-12-22T15:13:33.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"set transaction_timeout before next command\n\nSigned-off-by: Zhao Junwang <zhjwpku@gmail.com>","shortMessageHtmlLink":"set transaction_timeout before next command"}},{"before":"92a47a3635175416c5d9f10d3d4d0ddea4606a6f","after":"6078ec2961f6099d05995b22d3397572834b3465","ref":"refs/heads/pgxs_determine_cpp_compiler","pushedAt":"2023-12-22T09:16:22.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"PGXS determine C++ compiler for Makefile.global\n\nSigned-off-by: Zhao Junwang <zhjwpku@gmail.com>","shortMessageHtmlLink":"PGXS determine C++ compiler for Makefile.global"}},{"before":"8793c60051541c8df8dbe133cb9cf8138efe3b3f","after":null,"ref":"refs/heads/shit","pushedAt":"2023-12-22T08:59:42.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"}},{"before":null,"after":"8793c60051541c8df8dbe133cb9cf8138efe3b3f","ref":"refs/heads/shit","pushedAt":"2023-12-22T08:50:59.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Initialize data directories with --lc-messages=C for tests.\n\nCommit db6d9891e8 changed them to be initialized with --no-locale, but\nthat reduced the test coverage for non-C locales.\n\nDiscussion: https://postgr.es/m/0d47e5ecc037b3908149aad5f2a987793cf938bd.camel%40j-davis.com","shortMessageHtmlLink":"Initialize data directories with --lc-messages=C for tests."}},{"before":null,"after":"92a47a3635175416c5d9f10d3d4d0ddea4606a6f","ref":"refs/heads/pgxs_determine_cpp_compiler","pushedAt":"2023-12-22T08:41:05.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"PGXS determine C++ compiler for Makefile.global\n\nSigned-off-by: Zhao Junwang <zhjwpku@gmail.com>","shortMessageHtmlLink":"PGXS determine C++ compiler for Makefile.global"}},{"before":"410a2de1d50ff8e5a9870e949117cc71b662db2f","after":"bc124ed78025ae95b425429a2677d349113b4fd7","ref":"refs/heads/export_buildtype_debug_optimization_info_to_pg_config","pushedAt":"2023-12-22T07:57:20.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"PGXS determine C++ compiler for Makefile.global\n\nSigned-off-by: Zhao Junwang <zhjwpku@gmail.com>","shortMessageHtmlLink":"PGXS determine C++ compiler for Makefile.global"}},{"before":null,"after":"410a2de1d50ff8e5a9870e949117cc71b662db2f","ref":"refs/heads/export_buildtype_debug_optimization_info_to_pg_config","pushedAt":"2023-12-12T10:02:47.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"[meson] export buildtype debug/optimization info to pg_config\n\nSigned-off-by: Zhao Junwang <zhjwpku@gmail.com>","shortMessageHtmlLink":"[meson] export buildtype debug/optimization info to pg_config"}},{"before":"cc82dc808bb9fbdcd4cdbeb1510adc2165d64ccf","after":"30a383c048d948c370e26149820c4bc5ea004d94","ref":"refs/heads/extrac_copy_handler_with_pg_copy_handler","pushedAt":"2023-12-07T14:44:41.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Extract COPY handlers","shortMessageHtmlLink":"Extract COPY handlers"}},{"before":"6b7cca08aba75cff50aa1d788e64154354d9ee33","after":"cc82dc808bb9fbdcd4cdbeb1510adc2165d64ccf","ref":"refs/heads/extrac_copy_handler_with_pg_copy_handler","pushedAt":"2023-12-07T14:08:14.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Extract COPY handlers","shortMessageHtmlLink":"Extract COPY handlers"}},{"before":"67464aa8f8ceab5f84d576a20741e1287b6c7ecc","after":"6b7cca08aba75cff50aa1d788e64154354d9ee33","ref":"refs/heads/extrac_copy_handler_with_pg_copy_handler","pushedAt":"2023-12-07T11:25:53.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Extract COPY handlers","shortMessageHtmlLink":"Extract COPY handlers"}},{"before":null,"after":"67464aa8f8ceab5f84d576a20741e1287b6c7ecc","ref":"refs/heads/extrac_copy_handler_with_pg_copy_handler","pushedAt":"2023-12-07T11:08:07.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Extract COPY handlers","shortMessageHtmlLink":"Extract COPY handlers"}},{"before":"bcec7333601cc0e3d09ebbc50b5eff31bf204193","after":"df9e25b8517ab5dc6dd9f73ed7ad91fc20b1f938","ref":"refs/heads/extrac_copy_handler","pushedAt":"2023-12-06T13:52:35.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Extract COPY handlers","shortMessageHtmlLink":"Extract COPY handlers"}},{"before":"14eb45fce1d9ad3b9b649da83f5daaf2ffb2eeac","after":"bcec7333601cc0e3d09ebbc50b5eff31bf204193","ref":"refs/heads/extrac_copy_handler","pushedAt":"2023-12-06T13:19:12.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Extract COPY handlers","shortMessageHtmlLink":"Extract COPY handlers"}},{"before":"6c1d75afb502f0043ba9934a0ef228594f0d0ee7","after":"14eb45fce1d9ad3b9b649da83f5daaf2ffb2eeac","ref":"refs/heads/extrac_copy_handler","pushedAt":"2023-12-06T11:28:20.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Extract COPY handlers","shortMessageHtmlLink":"Extract COPY handlers"}},{"before":"3e36e48d8efecea9f2c991c0341e567af2eb363a","after":"7636725b922c8cd68f21d040f3542d3bce9c68a4","ref":"refs/heads/master","pushedAt":"2023-12-06T11:17:12.000Z","pushType":"push","commitsCount":42,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Fix compilation on Windows with WAL_DEBUG\n\nThis has been broken since b060dbe0001a that has reworked the callback\nmechanism of XLogReader, most likely unnoticed because any form of\ndevelopment involving WAL happens on platforms where this compiles fine.\n\nAuthor: Bharath Rupireddy\nDiscussion: https://postgr.es/m/CALj2ACVF14WKQMFwcJ=3okVDhiXpuK5f7YdT+BdYXbbypMHqWA@mail.gmail.com\nBackpatch-through: 13","shortMessageHtmlLink":"Fix compilation on Windows with WAL_DEBUG"}},{"before":null,"after":"6c1d75afb502f0043ba9934a0ef228594f0d0ee7","ref":"refs/heads/extrac_copy_handler","pushedAt":"2023-12-06T11:13:35.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Extract COPY handler","shortMessageHtmlLink":"Extract COPY handler"}},{"before":"f05b1fa1ff5b2133d636a427d00fe85eedad49b3","after":"3e36e48d8efecea9f2c991c0341e567af2eb363a","ref":"refs/heads/master","pushedAt":"2023-11-30T04:35:55.000Z","pushType":"push","commitsCount":672,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Fix a test in 003_logical_slots.\n\nWe allow to upgrade the slot iff there is no pending WAL to be processed.\nThe test first disables the subscription to avoid unnecessary LOGs on the\nsubscriber and then stops the publisher node. It is quite possible that\njust before the shutdown of the publisher, autovacuum generates some WAL\nrecord that needs to be processed, so just disable the autovacuum for this\ntest.\n\nPer buildfarm.\n\nAuthor: Hayato Kuroda\nReviewed-by: Amit Kapila\nDiscussion: http://postgr.es/m/OS3PR01MB9882FED1F0060468FB01B9DAF583A@OS3PR01MB9882.jpnprd01.prod.outlook.com","shortMessageHtmlLink":"Fix a test in 003_logical_slots."}},{"before":"d3a38318ac614f20a9e2e163bba083d15be54f06","after":"f05b1fa1ff5b2133d636a427d00fe85eedad49b3","ref":"refs/heads/master","pushedAt":"2023-08-08T04:12:48.000Z","pushType":"push","commitsCount":21,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"doc: Fix incorrect entries generated from wait_event_names.txt\n\nfa88928 has introduced wait_event_names.txt, and some of its entries had\nsome documentation fields with more information than necessary.\n\nThis commit brings back the description of all the wait events to be\nconsistent with the older stable branches.  Five descriptions were\nincorrect.\n\nAuthor: Bertrand Drouvot\nDiscussion: https://postgr.es/m/e378989e-1899-643a-dec1-10f691a0a105@gmail.com","shortMessageHtmlLink":"doc: Fix incorrect entries generated from wait_event_names.txt"}},{"before":"2c2eb0d6b27f498851bace47fc19e4c7fc90af4f","after":"d3a38318ac614f20a9e2e163bba083d15be54f06","ref":"refs/heads/master","pushedAt":"2023-08-01T08:12:34.000Z","pushType":"push","commitsCount":58,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Rename OverrideSearchPath to SearchPathMatcher.\n\nThe previous commit removed the \"override\" APIs.  Surviving APIs facilitate\nplancache.c to snapshot search_path and test whether the current value equals\na remembered snapshot.\n\nAleksander Alekseev.  Reported by Alexander Lakhin and Noah Misch.\n\nDiscussion: https://postgr.es/m/8ffb4650-52c4-6a81-38fc-8f99be981130@gmail.com","shortMessageHtmlLink":"Rename OverrideSearchPath to SearchPathMatcher."}},{"before":"ffbfde4c87725c5342aa0727ed61c5c3c7c0cb39","after":"2c2eb0d6b27f498851bace47fc19e4c7fc90af4f","ref":"refs/heads/master","pushedAt":"2023-07-18T06:14:46.000Z","pushType":"push","commitsCount":2286,"pusher":{"login":"zhjwpku","name":"Junwang Zhao","path":"/zhjwpku","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12639404?s=80&v=4"},"commit":{"message":"Shrink memory contexts struct sizes\n\nHere we reduce the block size fields in AllocSetContext, GenerationContext\nand SlabContext from Size down to uint32.  Ever since c6e0fe1f2, blocks\nfor non-dedicated palloc chunks can no longer be larger than 1GB, so\nthere's no need to store the various block size fields as 64-bit values.\n32 bits are enough to store 2^30.\n\nHere we also further reduce the memory context struct sizes by getting rid\nof the 'keeper' field which stores a pointer to the context's keeper\nblock.  All the context types which have this field always allocate the\nkeeper block in the same allocation as the memory context itself, so the\nkeeper block always comes right at the end of the context struct.  Add\nsome macros to calculate that address rather than storing it in the\ncontext.\n\nOverall, in AllocSetContext and GenerationContext, this saves 20 bytes on\n64-bit builds which for ALLOCSET_SMALL_SIZES can sometimes mean the\ndifference between having to allocate a 2nd block and storing all the\nrequired allocations on the keeper block alone.  Such contexts are used\nin relcache to store cache entries for indexes, of which there can be\na large number in a single backend.\n\nAuthor: Melih Mutlu\nReviewed-by: David Rowley\nDiscussion: https://postgr.es/m/CAGPVpCSOW3uJ1QJmsMR9_oE3X7fG_z4q0AoU4R_w+2RzvroPFg@mail.gmail.com","shortMessageHtmlLink":"Shrink memory contexts struct sizes"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"startCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wOC0wNlQxMDoyMTowNi4wMDAwMDBazwAAAASS9Bel","endCursor":"Y3Vyc29yOnYyOpK7MjAyMy0wNy0xOFQwNjoxNDo0Ni4wMDAwMDBazwAAAANXmw_i"}},"title":"Activity · zhjwpku/postgres"}