pgsql-hackers since 2022-12-11 03:50

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

Dec. 11, 2022

Thread Author Time
Re: [BUG] Logical replica crash if there was an error in a function. 📎 Anton A. Melnikov 03:50
Re: [RFC] Add jit deform_counter Pavel Stehule 04:44
Re: Allow parallel plan for referential integrity checks? Ian Lawrence Barwick 05:29
Re: [PROPOSAL] new diagnostic items for the dynamic sql Ian Lawrence Barwick 05:42
Re: GetNewObjectId question Tom Lane 06:12
Re: Progress report of CREATE INDEX for nested partitioned tables 📎 Justin Pryzby 06:33
Re: GetNewObjectId question 📎 Maciek Sakrejda 07:03
Re: GetNewObjectId question Michael Paquier 07:20
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) 📎 Amit Langote 09:25
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 11:44
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Justin Pryzby 14:21
Re: Error-safe user functions Andrew Dunstan 14:35
Date-Time dangling unit fix 📎 Joseph Koshakow 15:29
Re: Date-Time dangling unit fix 📎 Joseph Koshakow 15:41
Re: Error-safe user functions Tom Lane 17:24
Re: Error-safe user functions Andrew Dunstan 18:01
Re: Error-safe user functions Tom Lane 18:29
Re: Checksum errors in pg_stat_database Magnus Hagander 20:18
Re: Error-safe user functions Andres Freund 20:41
Re: Error-safe user functions Tom Lane 21:23
Re: static assert cleanup Peter Smith 22:18
Date-time extraneous fields with reserved keywords 📎 Joseph Koshakow 22:30
Re: PGDOCS - Logical replication GUCs - added some xrefs Peter Smith 22:46
Re: PGDOCS - Logical replication GUCs - added some xrefs Tom Lane 22:54
Re: Checksum errors in pg_stat_database Michael Paquier 23:40

Dec. 12, 2022

Thread Author Time
Re: Force streaming every change in logical decoding Peter Smith 00:03
Re: GetNewObjectId question Michael Paquier 00:31
Re: Checksum errors in pg_stat_database Andres Freund 00:51
Re: Checksum errors in pg_stat_database Michael Paquier 01:08
Why does L&Y Blink Tree need lock coupling? Oliver Yang 01:38
Re: Checksum errors in pg_stat_database Tom Lane 01:48
Re: Speedup generation of command completion tags 📎 David Rowley 01:48
Re: Why does L&Y Blink Tree need lock coupling? Peter Geoghegan 02:00
Re: Tree-walker callbacks vs -Wdeprecated-non-prototype Thomas Munro 02:45
Re: Improve WALRead() to suck data directly from WAL buffers when possible Kyotaro Horiguchi 02:57
Re: Improve WALRead() to suck data directly from WAL buffers when possible Kyotaro Horiguchi 03:06
Re: Tree-walker callbacks vs -Wdeprecated-non-prototype Tom Lane 03:07
Re: Improve WALRead() to suck data directly from WAL buffers when possible Kyotaro Horiguchi 03:08
Re: Tree-walker callbacks vs -Wdeprecated-non-prototype 📎 Thomas Munro 03:43
Re: Checksum errors in pg_stat_database Michael Paquier 04:09
Re: [PoC] Reducing planning time when tables have many partitions 📎 David Rowley 04:50
Re: Support logical replication of DDLs 📎 Zheng Li 04:58
Re: Testing DDL Deparser Zheng Li 05:05
Re: Time delayed LR (WAS Re: logical replication restrictions) Kyotaro Horiguchi 05:54
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) 📎 Amit Langote 06:23
Re: Checksum errors in pg_stat_database Drouvot, Bertrand 06:58
Re: slab allocator performance issues John Naylor 07:13
Re: Checksum errors in pg_stat_database Drouvot, Bertrand 07:15
RE: Time delayed LR (WAS Re: logical replication restrictions) Takamichi Osumi (Fujitsu) 07:23
RE: Time delayed LR (WAS Re: logical replication restrictions) Hayato Kuroda (Fujitsu) 07:34
RE: Time delayed LR (WAS Re: logical replication restrictions) Takamichi Osumi (Fujitsu) 07:42
Re: Checksum errors in pg_stat_database Magnus Hagander 09:33
Re: refactor ExecGrant_*() functions Antonin Houska 09:44
Re: A problem about ParamPathInfo for an AppendPath 📎 Richard Guo 09:55
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 10:14
Re: Checksum errors in pg_stat_database Drouvot, Bertrand 10:14
RE: Time delayed LR (WAS Re: logical replication restrictions) 📎 Takamichi Osumi (Fujitsu) 10:40
RE: Time delayed LR (WAS Re: logical replication restrictions) Takamichi Osumi (Fujitsu) 11:09
Re: generic plans and "initial" pruning Amit Langote 11:19
RE: Time delayed LR (WAS Re: logical replication restrictions) Takamichi Osumi (Fujitsu) 11:20
Re: add \dpS to psql Andrew Dunstan 12:01
Re: Force streaming every change in logical decoding Amit Kapila 12:14
Re: Support logical replication of DDLs Ajin Cherian 12:20
Re: Add PL/pgSQL extra check no_data_found Мельников Игорь 12:36
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 12:40
Re: Add PL/pgSQL extra check no_data_found Pavel Stehule 13:00
Re: Infinite Interval 📎 Ashutosh Bapat 13:05
Re: Support logical replication of DDLs 📎 Ajin Cherian 13:13
Re: Add PL/pgSQL extra check no_data_found Мельников Игорь 13:16
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher 📎 Önder Kalacı 13:28
Re: [PATCH] Add native windows on arm64 support Niyas Sait 13:38
Re: Order getopt arguments Peter Eisentraut 14:24
Re: Add PL/pgSQL extra check no_data_found Pavel Stehule 14:37
Re: Raising the SCRAM iteration count Jonathan S. Katz 14:47
Re: sendFileWithContent() does not advance the source pointer Robert Haas 15:40
Re: Date-Time dangling unit fix Joseph Koshakow 15:55
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 16:04
Re: Add sub-transaction overflow status in pg_stat_activity Robert Haas 16:15
Re: Allow parallel plan for referential integrity checks? Frédéric Yhuel 16:35
Re: add \dpS to psql Nathan Bossart 17:18
Re: generic plans and "initial" pruning Alvaro Herrera 17:24
Re: Add sub-transaction overflow status in pg_stat_activity Nathan Bossart 17:33
Re: Support logical replication of DDLs 📎 Zheng Li 17:40
Re: Minimal logical decoding on standbys Robert Haas 17:41
Re: Add sub-transaction overflow status in pg_stat_activity Justin Pryzby 17:42
Re: Add sub-transaction overflow status in pg_stat_activity Robert Haas 17:51
Re: Re[2]: [PATCH] Optional OR REPLACE in CREATE OPERATOR statement Nikita Malakhov 19:14
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Peter Eisentraut 19:16
Re: PGDOCS - Logical replication GUCs - added some xrefs Alvaro Herrera 19:25
Re: Progress report of CREATE INDEX for nested partitioned tables Ilya Gladyshev 19:39
Re: Why does L&Y Blink Tree need lock coupling? Oliver Yang 19:42
Re: PGDOCS - Logical replication GUCs - added some xrefs Alvaro Herrera 19:43
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX 📎 Nathan Bossart 20:04
Re: Why does L&Y Blink Tree need lock coupling? Peter Geoghegan 20:13
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX 📎 Nathan Bossart 21:01
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane 21:22
Re: ALTER TABLE uses a bistate but not for toast tables Nikita Malakhov 21:26
Re: PGDOCS - Logical replication GUCs - added some xrefs Peter Smith 22:06
Re: Perform streaming logical transactions by background workers and parallel apply Peter Smith 22:21
Re: Support logical replication of DDLs 📎 Zheng Li 22:49
Re: Perform streaming logical transactions by background workers and parallel apply Peter Smith 23:05
Re: New strategies for freezing, advancing relfrozenxid early Jeff Davis 23:47
Re: [PATCH] Add native windows on arm64 support Michael Paquier 23:56

Dec. 13, 2022

Thread Author Time
Re: Date-Time dangling unit fix 📎 Joseph Koshakow 00:11
Re: slab allocator performance issues David Rowley 00:49
Re: New strategies for freezing, advancing relfrozenxid early Peter Geoghegan 00:59
Re: Tree-walker callbacks vs -Wdeprecated-non-prototype Thomas Munro 01:18
Re: Time delayed LR (WAS Re: logical replication restrictions) Kyotaro Horiguchi 01:23
Re: Time delayed LR (WAS Re: logical replication restrictions) Kyotaro Horiguchi 02:05
RE: Time delayed LR (WAS Re: logical replication restrictions) Takamichi Osumi (Fujitsu) 02:28
Re: Support logical replication of DDLs li jie 02:37
Re: Force streaming every change in logical decoding Peter Smith 03:33
Re: Add sub-transaction overflow status in pg_stat_activity Dilip Kumar 04:09
Re: Time delayed LR (WAS Re: logical replication restrictions) Kyotaro Horiguchi 04:27
Re: Add index scan progress to pg_stat_progress_vacuum Imseih (AWS), Sami 04:40
Re: Progress report of CREATE INDEX for nested partitioned tables 📎 Justin Pryzby 04:43
RE: Time delayed LR (WAS Re: logical replication restrictions) Takamichi Osumi (Fujitsu) 04:43
Remove SHA256_HMAC_B from scram-common.h 📎 Michael Paquier 04:57
Re: [PoC] Federated Authn/z with OAUTHBEARER Andrey Chudnovsky 05:06
Re: Force streaming every change in logical decoding Peter Smith 05:45
Re: refactor ExecGrant_*() functions Peter Eisentraut 06:54
Re: Add sub-transaction overflow status in pg_stat_activity Julien Rouhaud 07:29
Use get_call_result_type() more widely 📎 Bharath Rupireddy 07:36
Re: Add proper planner support for ORDER BY / DISTINCT aggregates David Rowley 07:53
Re: Use get_call_result_type() more widely Michael Paquier 08:13
Re: New strategies for freezing, advancing relfrozenxid early John Naylor 08:29
Re: Support logical replication of DDLs 📎 vignesh C 09:17
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 10:40
Re: [PATCH] Infinite loop while acquiring new TOAST Oid 📎 Nikita Malakhov 10:41
Re: Introduce a new view for checkpointer related stats Nitin Jadhav 10:44
Re: Minimal logical decoding on standbys Drouvot, Bertrand 10:48
BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) PG Bug reporting form 10:57
Re: Raising the SCRAM iteration count Daniel Gustafsson 11:17
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 11:35
Re: Error-safe user functions 📎 Amul Sul 12:33
Ordering behavior for aggregates Vik Fearing 12:50
Re: Ordering behavior for aggregates Magnus Hagander 12:55
Re: Ordering behavior for aggregates Vik Fearing 13:05
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 13:07
RE: Perform streaming logical transactions by background workers and parallel apply [email protected] 13:07
Re: Ordering behavior for aggregates Isaac Morland 13:25
Re: Ordering behavior for aggregates Vik Fearing 13:44
Re: Minimal logical decoding on standbys Robert Haas 13:50
Re: Ordering behavior for aggregates Ronan Dunklau 14:06
Re: Temporary tables versus wraparound... again 📎 Greg Stark 14:22
Re: refactor ExecGrant_*() functions Antonin Houska 15:03
Re: Ordering behavior for aggregates Tom Lane 15:13
Re: Perform streaming logical transactions by background workers and parallel apply Masahiko Sawada 15:25
Re: Use get_call_result_type() more widely Tom Lane 15:42
Re: Add LSN along with offset to error messages reported for WAL file read/write/validate header failures 📎 Bharath Rupireddy 16:02
Re: Minimal logical decoding on standbys Drouvot, Bertrand 16:37
Re: Minimal logical decoding on standbys Robert Haas 16:42
Re: Ordering behavior for aggregates Ronan Dunklau 16:45
Re: Minimal logical decoding on standbys Drouvot, Bertrand 16:46
Re: Minimal logical decoding on standbys Robert Haas 16:49
Re: Minimal logical decoding on standbys Drouvot, Bertrand 16:50
Re: Ordering behavior for aggregates Tom Lane 17:05
Re: Ordering behavior for aggregates David G. Johnston 17:15
Re: New strategies for freezing, advancing relfrozenxid early Peter Geoghegan 17:16
Re: Ordering behavior for aggregates Tom Lane 17:22
Re: Remove SHA256_HMAC_B from scram-common.h Jacob Champion 17:27
Re: Ordering behavior for aggregates Vik Fearing 18:02
Re: Progress report of CREATE INDEX for nested partitioned tables 📎 Ilya Gladyshev 19:07
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane 19:26
Re: Remove SHA256_HMAC_B from scram-common.h Michael Paquier 22:13
Re: Support logical replication of DDLs 📎 Zheng Li 22:25
Re: New strategies for freezing, advancing relfrozenxid early Peter Geoghegan 23:07
Re: wake up logical workers after ALTER SUBSCRIPTION Tom Lane 23:32
Re: [PATCH] random_normal function 📎 Paul Ramsey 23:51

Dec. 14, 2022

Thread Author Time
Re: wake up logical workers after ALTER SUBSCRIPTION Nathan Bossart 00:01
Re: Proposal for internal Numeric to Uint64 conversion function. Ian Lawrence Barwick 00:09
Shortening the Scope of Critical Section in Creation of New MultiXacts 📎 Bagga, Rishu 00:14
Re: wake up logical workers after ALTER SUBSCRIPTION Tom Lane 00:20
Re: Make ON_ERROR_STOP stop on shell script failure David Zhang 00:40
Re: wake up logical workers after ALTER SUBSCRIPTION Nathan Bossart 00:41
Re: Raising the SCRAM iteration count Michael Paquier 01:00
Re: Time delayed LR (WAS Re: logical replication restrictions) Kyotaro Horiguchi 01:35
Re: Add index scan progress to pg_stat_progress_vacuum Masahiko Sawada 01:43
Avoid extra "skipping" messages from VACUUM/ANALYZE 📎 Jeff Davis 02:29
Document aggregate functions better w.r.t. ORDER BY 📎 David G. Johnston 02:38
Refactor SCRAM code to dynamically handle hash type and key length 📎 Michael Paquier 02:38
Re: allowing for control over SET ROLE Michael Paquier 02:44
Rework confusing permissions for LOCK TABLE 📎 Jeff Davis 02:59
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Jeff Davis 03:05
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Nathan Bossart 03:23
Re: Avoid extra "skipping" messages from VACUUM/ANALYZE Nathan Bossart 03:40
RE: Perform streaming logical transactions by background workers and parallel apply [email protected] 04:19
Re: Direct I/O 📎 Thomas Munro 04:48
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 04:54
Re: Add index scan progress to pg_stat_progress_vacuum 📎 Imseih (AWS), Sami 05:09
Re: Schema variables - new implementation for Postgres 15 (typo) Erik Rijkers 05:20
Re: Use get_call_result_type() more widely Bharath Rupireddy 05:44
Re: Shortening the Scope of Critical Section in Creation of New MultiXacts Kyotaro Horiguchi 05:45
Re: Non-decimal integer literals Peter Eisentraut 05:47
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 06:34
Re: Perform streaming logical transactions by background workers and parallel apply 📎 Amit Kapila 06:48
Re: pg_upgrade: Make testing different transfer modes easier 📎 Peter Eisentraut 07:04
Common function for percent placeholder replacement 📎 Peter Eisentraut 07:31
Inconsistency in reporting checkpointer stats 📎 Nitin Jadhav 07:31
Re: generic plans and "initial" pruning 📎 Amit Langote 08:35

Browse Archives

Prev | Next