pgsql-hackers since 2024-09-26 00:00

The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Sept. 26, 2024

Thread Author Time
Re: Add contrib/pg_logicalsnapinspect Masahiko Sawada 00:04
Re: query_id, pg_stat_activity, extended query protocol 📎 Michael Paquier 01:08
CREATE INDEX regression in 17 RC1 or expected behavior? Tom Dunstan 02:52
Re: CREATE INDEX regression in 17 RC1 or expected behavior? Tom Dunstan 03:12
Re: CREATE INDEX regression in 17 RC1 or expected behavior? Nathan Bossart 03:16
Re: Add contrib/pg_logicalsnapinspect shveta malik 03:27
Re: CREATE INDEX regression in 17 RC1 or expected behavior? Yugo Nagata 03:51
Re: CREATE INDEX regression in 17 RC1 or expected behavior? Tom Dunstan 03:57
Re: installcheck-world concurrency issues Michael Paquier 04:47
Re: First draft of PG 17 release notes 📎 Yugo Nagata 05:19
Re: CREATE INDEX regression in 17 RC1 or expected behavior? Yugo NAGATA 05:21
Re: Logical Replication of sequences shveta malik 05:37
Re: meson and check-tests Ashutosh Bapat 05:45
Re: Identify huge pages accessibility using madvise Gabriele Bartolini 05:57
Re: Using per-transaction memory contexts for storing decoded tuples Masahiko Sawada 05:57
Modify comment in /postgres/src/bin/pg_walsummary/nls.mk 📎 btnakamurakoukil 06:05
Re: long-standing data loss bug in initial sync of logical replication 📎 Shlok Kyal 06:09
Re: Pgoutput not capturing the generated columns 📎 Peter Smith 06:14
Re: Identify huge pages accessibility using madvise Dmitry Dolgov 06:46
Re: Psql meta-command conninfo+ 📎 Hunaid Sohail 07:15
Re: not null constraints, again 📎 jian he 07:41
Re: Add system column support to the USING clause Denis Garsh 07:54
Re: Add has_large_object_privilege function 📎 Michael Paquier 08:16
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Michael Paquier 08:18
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 📎 Jehan-Guillaume de Rorthais 08:48
Re: Clock-skew management in logical replication Amit Kapila 08:56
Re: Add support to TLS 1.3 cipher suites and curves lists 📎 Daniel Gustafsson 09:01
Re: Conflict Detection and Resolution shveta malik 09:27
Re: [PATCH] Support Int64 GUCs wenhui qiu 09:30
Re: First draft of PG 17 release notes Amit Kapila 09:38
Re: meson and check-tests 📎 Nazir Bilal Yavuz 10:43
Re: Add has_large_object_privilege function Fujii Masao 10:51
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part Alexander Korotkov 10:55
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part Alexander Korotkov 10:57
Re: Documentation to upgrade logical replication cluster Amit Kapila 10:58
RE: long-standing data loss bug in initial sync of logical replication Hayato Kuroda (Fujitsu) 11:53
Re: not null constraints, again jian he 12:19
Re: Add on_error and log_verbosity options to file_fdw 📎 torikoshia 12:57
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part Florents Tselai 12:59
Re: Add new COPY option REJECT_LIMIT 📎 torikoshia 13:38
RFC/PoC: GUC option to enable tuple queue autoflush for parallel workers 📎 Francesco Degrassi 14:15
Re: [PATCH] Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges Christoph Berg 14:51
Re: Test improvements and minor code fixes for formatting.c. Tom Lane 15:04
Re: Opinion poll: Sending an automated email to a thread when it gets added to the commitfest Robert Haas 15:05
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Alexander Korotkov 15:41
Re: SQL:2023 JSON simplified accessor support 📎 Alexandra Wang 15:45
Re: [PATCH] Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges 📎 Tom Lane 15:51
Re: [PATCH] Support Int64 GUCs Alexander Korotkov 15:55
Re: [PATCH] Support Int64 GUCs Tom Lane 16:39
Re: not null constraints, again Alvaro Herrera 16:53
Re: SQL:2023 JSON simplified accessor support Andrew Dunstan 17:16
Re: Proposal to Enable/Disable Index using ALTER INDEX 📎 Shayon Mukherjee 17:39
ALTER TABLE ONLY .. DROP CONSTRAINT on partitioned tables 📎 Alvaro Herrera 17:52
Truncate logs by max_log_size 📎 diPhantxm 18:30
Re: Opinion poll: Sending an automated email to a thread when it gets added to the commitfest Jelte Fennema-Nio 18:57
Re: miscellaneous pg_upgrade cleanup Nathan Bossart 18:58
Re: [ecpg bug]: can not use single '*' in multi-line comment after c preprocessor directives Tom Lane 19:04
Re: Retiring is_pushed_down Tom Lane 20:06
micro-optimize nbtcompare.c routines 📎 Nathan Bossart 20:17
Re: Large expressions in indexes can't be stored (non-TOASTable) Nathan Bossart 20:53
Re: MAINTAIN privilege -- what do we need to un-revert it? Nathan Bossart 21:33
Re: AIO writes vs hint bits vs checksums Thomas Munro 21:56
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Michael Paquier 22:04
Re: Add has_large_object_privilege function Michael Paquier 22:06
Collation & ctype method table, and extension hooks 📎 Jeff Davis 22:30
Re: query_id, pg_stat_activity, extended query protocol Sami Imseih 22:46
Re: query_id, pg_stat_activity, extended query protocol Imseih (AWS), Sami 22:55
Re: query_id, pg_stat_activity, extended query protocol Michael Paquier 23:17

Sept. 27, 2024

Thread Author Time
Re: Pgoutput not capturing the generated columns Masahiko Sawada 00:03
Re: Truncate logs by max_log_size Euler Taveira 00:30
Re: Modify comment in /postgres/src/bin/pg_walsummary/nls.mk Fujii Masao 01:24
Re: pg_ctl/miscinit: print "MyStartTime" as a long long instead of long to avoid 2038 problem. 📎 Nathan Bossart 02:38
Re: micro-optimize nbtcompare.c routines 📎 David Rowley 02:50
Re: micro-optimize nbtcompare.c routines Nathan Bossart 03:23
Re: Add has_large_object_privilege function Yugo NAGATA 03:26
Re: MAINTAIN privilege -- what do we need to un-revert it? 📎 Yugo NAGATA 03:42
Re: Eager aggregation, take 3 📎 Richard Guo 03:53
Re: query_id, pg_stat_activity, extended query protocol Sami Imseih 04:01
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Michael Paquier 04:35
Re: ALTER TABLE ONLY .. DROP CONSTRAINT on partitioned tables Amit Langote 04:51
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Michael Paquier 04:57
Re: Conflict Detection and Resolution shveta malik 05:14
Re: pg_verifybackup: TAR format backup verification Amul Sul 06:06
Re: Conflict Detection and Resolution 📎 Peter Smith 07:30
Re: Using per-transaction memory contexts for storing decoded tuples 📎 Shlok Kyal 07:39
Re: On disable_cost Laurenz Albe 08:42
Re: Conflict Detection and Resolution shveta malik 09:03
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part David E. Wheeler 09:45
Re: SQL:2023 JSON simplified accessor support David E. Wheeler 09:49
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part Florents Tselai 10:28
Re: Truncate logs by max_log_size Andrey M. Borodin 10:36
Re: Add has_large_object_privilege function Dagfinn Ilmari Mannsåker 10:44
Re: SQL:2023 JSON simplified accessor support Andrew Dunstan 11:07
Re: long-standing data loss bug in initial sync of logical replication 📎 Shlok Kyal 11:24
Re: Extension security improvement: Add support for extensions with an owned schema Tomas Vondra 12:00
Re: pg_verifybackup: TAR format backup verification Robert Haas 12:03
Re: On disable_cost 📎 David Rowley 12:04
Re: Opinion poll: Sending an automated email to a thread when it gets added to the commitfest Robert Haas 12:08
Better error reporting from extension scripts (Was: Extend ALTER OPERATOR) Christoph Berg 12:17
Re: not null constraints, again 📎 Alvaro Herrera 13:07
general purpose array_sort 📎 Junwang Zhao 13:15
IndexAccessMethod API & Index Only Scans Eric Ridge 13:33
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Alexander Korotkov 14:07
Changing the default random_page_cost value Greg Sabino Mullane 14:07
Re: Changing the default random_page_cost value Roberto Mello 14:26
Re: Pgoutput not capturing the generated columns 📎 Shubham Khanna 14:31
Re: Pgoutput not capturing the generated columns Shubham Khanna 14:39
Re: Pgoutput not capturing the generated columns Shubham Khanna 14:42
Re: Pgoutput not capturing the generated columns Shubham Khanna 14:46
Re: pg_ctl/miscinit: print "MyStartTime" as a long long instead of long to avoid 2038 problem. Max Johnson 14:48
Re: MAINTAIN privilege -- what do we need to un-revert it? Nathan Bossart 15:34
Re: Changing the default random_page_cost value Laurenz Albe 15:35
Re: micro-optimize nbtcompare.c routines Nathan Bossart 15:44
Re: Changing the default random_page_cost value Dagfinn Ilmari Mannsåker 16:03
Re: MAINTAIN privilege -- what do we need to un-revert it? Jeff Davis 16:22
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR) 📎 Tom Lane 16:31
Re: Using per-transaction memory contexts for storing decoded tuples Masahiko Sawada 16:53
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR) Christoph Berg 17:31
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR) 📎 Tom Lane 17:54
Re: [PoC] Federated Authn/z with OAUTHBEARER Antonin Houska 17:58
Re: Vacuum statistics Masahiko Sawada 18:15
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman 18:58
Re: Thoughts about NUM_BUFFER_PARTITIONS Nathan Bossart 19:07
Re: pg_ctl/miscinit: print "MyStartTime" as a long long instead of long to avoid 2038 problem. Nathan Bossart 19:10
Re: Vacuum statistics Melanie Plageman 19:19
Re: Vacuum statistics Andrei Zubkov 19:25
Re: MAINTAIN privilege -- what do we need to un-revert it? Nathan Bossart 20:04
Re: Vacuum statistics Masahiko Sawada 20:13
Re: BitmapHeapScan streaming read user and prelim refactoring 📎 Melanie Plageman 20:13
Re: MAINTAIN privilege -- what do we need to un-revert it? Jeff Davis 20:27
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 20:45
Re: SQL:2023 JSON simplified accessor support David E. Wheeler 21:19
Re: MAINTAIN privilege -- what do we need to un-revert it? Nathan Bossart 21:24
Re: Row pattern recognition 📎 Jacob Champion 22:27
Re: Make COPY format extendable: Extract COPY TO format implementations Masahiko Sawada 23:33

Sept. 28, 2024

Thread Author Time
Re: Add new COPY option REJECT_LIMIT jian he 01:48
Re: Row pattern recognition 📎 Tatsuo Ishii 10:43
BUG #18641: Logical decoding of two-phase commit fails with TOASTed default values PG Bug reporting form 11:00
Re: general purpose array_sort 📎 Junwang Zhao 11:52
Re: [PATCH] Add native windows on arm64 support Andrew Dunstan 13:01
msys inet_pton strangeness Andrew Dunstan 13:50
Re: general purpose array_sort 📎 jian he 14:40
Re: msys inet_pton strangeness Tom Lane 15:49
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Sutou Kouhei 15:56
Re: msys inet_pton strangeness Andrew Dunstan 17:26
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR) 📎 Tom Lane 19:45
Re: msys inet_pton strangeness Tom Lane 19:49
Re: msys inet_pton strangeness Thomas Munro 20:52
ORDER BY operator index scans and filtering Andrew Kane 21:18
Re: Vacuum statistics Alena Rybakina 21:22
Re: pg_verifybackup: TAR format backup verification Tom Lane 22:59

Sept. 29, 2024

Thread Author Time
Re: [PATCH] Add native windows on arm64 support 📎 Thomas Munro 00:02
Re: First draft of PG 17 release notes Bruce Momjian 01:19
Re: First draft of PG 17 release notes Bruce Momjian 01:20
Re: general purpose array_sort Junwang Zhao 02:05
Re: general purpose array_sort David G. Johnston 02:50
Re: Add has_large_object_privilege function Yugo Nagata 03:46
Re: msys inet_pton strangeness Alexander Lakhin 05:00
Re: Logical Replication of sequences vignesh C 07:04
Re: [PATCH] Add native windows on arm64 support Dave Cramer 10:31
Re: pgsql: Implement pg_wal_replay_wait() stored procedure 📎 Alexander Korotkov 10:40
Re: First draft of PG 17 release notes Amit Kapila 13:03
Re: msys inet_pton strangeness Andrew Dunstan 15:47
Re: msys inet_pton strangeness Tom Lane 16:24
Re: pg_verifybackup: TAR format backup verification Tom Lane 17:03
SET or STRICT modifiers on function affect planner row estimates Michał Kłeczek 18:49
Re: msys inet_pton strangeness Alexander Lakhin 20:00
Re: Fixing backslash dot for COPY FROM...CSV Tom Lane 20:11
Re: [PATCH] Support Int64 GUCs Aleksander Alekseev 21:31
Re: msys inet_pton strangeness Thomas Munro 22:28

Sept. 30, 2024

Thread Author Time
Re: Row pattern recognition Tatsuo Ishii 00:07
pg_upgrade check for invalid databases 📎 Thomas Krennwallner 00:45
Re: query_id, pg_stat_activity, extended query protocol 📎 Michael Paquier 01:07
Re: BUG #18641: Logical decoding of two-phase commit fails with TOASTed default values 📎 Takeshi Ideriha 01:16
Re: information_schema.view attgenerated Peter Eisentraut 01:49
Re: Virtual generated columns 📎 Peter Eisentraut 02:09
a litter question about mdunlinkfiletag function px shi 02:43
Re: May be BUG. Periodic burst growth of the checkpoint_req counter on replica. Fujii Masao 03:26
Re: Conflict Detection and Resolution shveta malik 04:26
Re: long-standing data loss bug in initial sync of logical replication 📎 Shlok Kyal 04:58
Re: general purpose array_sort 📎 Junwang Zhao 05:01
Re: First draft of PG 17 release notes Yugo NAGATA 05:20
Re: Conflict Detection and Resolution Peter Smith 05:34
Re: [Bug Fix]standby may crash when switching-over in certain special cases Yugo NAGATA 05:47
pg_walsummary, Character-not-present-in-option btsugieyuusuke 06:02
Re: Pgoutput not capturing the generated columns 📎 Peter Smith 06:17
Re: Normalize queries starting with SET for pg_stat_statements Michael Paquier 06:24
Re: Conflict Detection and Resolution shveta malik 06:29
RE: Conflict detection for update_deleted in logical replication 📎 Zhijie Hou (Fujitsu) 06:32
Doc: typo in config.sgml 📎 Tatsuo Ishii 06:34
Re: May be BUG. Periodic burst growth of the checkpoint_req counter on replica. Anton A. Melnikov 07:00
Re: Conflict Detection and Resolution shveta malik 07:05
Re: [Bug Fix]standby may crash when switching-over in certain special cases px shi 07:14
Re: Pgoutput not capturing the generated columns Peter Smith 07:26
Re: documentation structure 📎 jian he 07:34
Re: Doc: typo in config.sgml 📎 Yugo Nagata 07:47
Possibilities on code change to implement pseudodatatypes Vinícius Abrahão 08:01
Re: XMLSerialize: version and explicit XML declaration 📎 Jim Jones 08:08
Re: documentation structure 📎 jian he 08:15
Re: Doc: typo in config.sgml Tatsuo Ishii 08:23

Browse Archives

Prev | Next