pgsql-hackers since 2022-12-14 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

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
RE: Force streaming every change in logical decoding 📎 [email protected] 08:44
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Pavel Luzanov 09:07
Re: Perform streaming logical transactions by background workers and parallel apply Masahiko Sawada 09:19
Allow tailoring of ICU locales with custom rules 📎 Peter Eisentraut 09:26
Re: pg_upgrade: Make testing different transfer modes easier Daniel Gustafsson 09:40
Re: Allow batched insert during cross-partition updates 📎 Etsuro Fujita 09:44
Re: Support logical replication of DDLs 📎 vignesh C 10:34
Re: slab allocator performance issues John Naylor 10:37
RE: Time delayed LR (WAS Re: logical replication restrictions) Hayato Kuroda (Fujitsu) 10:46
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 10:59
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 11:00
Re: Inconsistency in reporting checkpointer stats Bharath Rupireddy 11:24
Re: Raising the SCRAM iteration count 📎 Daniel Gustafsson 11:25
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Bharath Rupireddy 11:28
Re: Force streaming every change in logical decoding Amit Kapila 11:59
Re: Amcheck verification of GiST and GIN Jose Arthur Benetasso Villanova 12:18
Re: Error-safe user functions 📎 Amul Sul 12:35
Re: Minimal logical decoding on standbys 📎 Drouvot, Bertrand 13:05
Re: Allow batched insert during cross-partition updates Amit Langote 13:28
Re: Refactor SCRAM code to dynamically handle hash type and key length Peter Eisentraut 13:39
Re: static assert cleanup Peter Eisentraut 15:15
Re: Minimal logical decoding on standbys Robert Haas 15:55
Re: Error-safe user functions Tom Lane 16:00
Re: Common function for percent placeholder replacement Robert Haas 16:09
Re: Common function for percent placeholder replacement Justin Pryzby 17:05
Re: wake up logical workers after ALTER SUBSCRIPTION Nathan Bossart 17:10
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Nathan Bossart 17:13
Re: Rework confusing permissions for LOCK TABLE Nathan Bossart 17:23
Re: Amcheck verification of GiST and GIN Robert Haas 17:25
Re: fix and document CLUSTER privileges 📎 Nathan Bossart 17:34
Re: Minimal logical decoding on standbys Andres Freund 17:35
Re: Common function for percent placeholder replacement Tom Lane 17:40
Re: wake up logical workers after ALTER SUBSCRIPTION Tom Lane 17:42
Re: wake up logical workers after ALTER SUBSCRIPTION Nathan Bossart 17:45
Re: Minimal logical decoding on standbys Robert Haas 17:48
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Alvaro Herrera 18:05
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Nathan Bossart 18:16
Re: Temporary tables versus wraparound... again Greg Stark 18:17
Re: wake up logical workers after ALTER SUBSCRIPTION Tom Lane 18:23
Re: wake up logical workers after ALTER SUBSCRIPTION Nathan Bossart 18:37
Re: collect_corrupt_items_vacuum.patch Nikita Malakhov 18:56
Re: Raising the SCRAM iteration count Jonathan S. Katz 18:59
Re: wake up logical workers after ALTER SUBSCRIPTION Tom Lane 19:02
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Jeff Davis 19:05
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Jeff Davis 19:46
Re: Refactor SCRAM code to dynamically handle hash type and key length Michael Paquier 19:59
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Isaac Morland 20:32
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Jeff Davis 20:56
Re: Temporary tables versus wraparound... again Robert Haas 21:22
Re: Temporary tables versus wraparound... again Greg Stark 21:43
Re: Error-safe user functions Andrew Dunstan 21:45
Re: Inconsistency in reporting checkpointer stats Michael Paquier 21:46
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Pavel Luzanov 22:02
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Justin Pryzby 22:11
Re: Error-safe user functions Tom Lane 22:37
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Isaac Morland 22:40
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 22:44
Re: [PATCH] Enable using llvm jitlink as an alternative llvm jit linker of old Rtdyld. Thomas Munro 22:59
Re: wake up logical workers after ALTER SUBSCRIPTION Nathan Bossart 23:17
Re: Error-safe user functions Tom Lane 23:24
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Nathan Bossart 23:29
Re: Raising the SCRAM iteration count Michael Paquier 23:52

Dec. 15, 2022

Thread Author Time
Re: Raising the SCRAM iteration count Jonathan S. Katz 00:00
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Michael Paquier 00:12
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Jeff Davis 00:18
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX 📎 Nathan Bossart 00:27
Re: pg_upgrade: Make testing different transfer modes easier Kyotaro Horiguchi 00:56
Re: Time delayed LR (WAS Re: logical replication restrictions) Kyotaro Horiguchi 01:46
Re: Time delayed LR (WAS Re: logical replication restrictions) Kyotaro Horiguchi 01:52
check_strxfrm_bug() 📎 Thomas Munro 02:22
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 03:28
Re: Error-safe user functions 📎 Tom Lane 03:33
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 03:48
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 03:53
Re: Time delayed LR (WAS Re: logical replication restrictions) Kyotaro Horiguchi 04:14
Re: Time delayed LR (WAS Re: logical replication restrictions) Kyotaro Horiguchi 04:41
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 04:59
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 05:06
Re: [PATCH] random_normal function Michael Paquier 05:17
Re: Error-safe user functions Amul Sul 05:19
Re: Perform streaming logical transactions by background workers and parallel apply Masahiko Sawada 05:21
The drop-index-concurrently-1 isolation test no longer tests what it was meant to 📎 David Rowley 05:26
Re: Support logical replication of DDLs 📎 Zheng Li 05:36
Re: Error-safe user functions Tom Lane 05:45
Re: Time delayed LR (WAS Re: logical replication restrictions) Kyotaro Horiguchi 05:52
Re: Use get_call_result_type() more widely Michael Paquier 06:11
Re: Schema variables - new implementation for Postgres 15 (typo) 📎 Pavel Stehule 06:12
Re: Error-safe user functions Amul Sul 06:19
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Michael Paquier 06:36
plpgsq_plugin's stmt_end() is not called when an error is caught 📎 Masahiko Sawada 07:24
Re: plpgsq_plugin's stmt_end() is not called when an error is caught Pavel Stehule 07:41
Re: plpgsq_plugin's stmt_end() is not called when an error is caught Kyotaro Horiguchi 07:53
Re: plpgsq_plugin's stmt_end() is not called when an error is caught Pavel Stehule 08:03
RE: Time delayed LR (WAS Re: logical replication restrictions) Hayato Kuroda (Fujitsu) 08:12
Re: pg_upgrade: Make testing different transfer modes easier Daniel Gustafsson 08:34
Re: plpgsq_plugin's stmt_end() is not called when an error is caught Kyotaro Horiguchi 08:34
Re: Ability to reference other extensions by schema in extension scripts Sandro Santilli 08:52
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Pavel Luzanov 09:31
Re: static assert cleanup Peter Eisentraut 09:32
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Pavel Luzanov 09:42
Re: Inconsistency in reporting checkpointer stats Nitin Jadhav 10:12
Re: Inconsistency in reporting checkpointer stats 📎 Nitin Jadhav 10:13
Re: Minimal logical decoding on standbys Drouvot, Bertrand 10:20
Re: Minimal logical decoding on standbys Drouvot, Bertrand 10:31
Re: plpgsq_plugin's stmt_end() is not called when an error is caught Pavel Stehule 11:07
Re: Raising the SCRAM iteration count Daniel Gustafsson 11:09
Re: Raising the SCRAM iteration count 📎 Daniel Gustafsson 11:09
Re: Add proper planner support for ORDER BY / DISTINCT aggregates 📎 David Rowley 11:10
cirrus scripts could use make -k Peter Eisentraut 11:31
Re: plpgsq_plugin's stmt_end() is not called when an error is caught Masahiko Sawada 11:50
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎 Melih Mutlu 12:03
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 12:59
RE: Ability to reference other extensions by schema in extension scripts Regina Obe 13:04
Re: Temporary tables versus wraparound... again Robert Haas 13:29
Re: plpgsq_plugin's stmt_end() is not called when an error is caught Pavel Stehule 13:34
Re: Error-safe user functions Robert Haas 14:12
Re: New strategies for freezing, advancing relfrozenxid early Matthias van de Meent 14:50
Re: plpgsq_plugin's stmt_end() is not called when an error is caught Tom Lane 15:49
Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs) 📎 Justin Pryzby 16:13
Re: plpgsq_plugin's stmt_end() is not called when an error is caught David G. Johnston 16:18
Re: Support logical replication of DDLs 📎 vignesh C 16:24
Re: postgres_fdw: using TABLESAMPLE to collect remote sample James Finnerty 16:34
Re: postgres_fdw: using TABLESAMPLE to collect remote sample Tom Lane 16:46
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Jeff Davis 18:10
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Jeff Davis 18:42
Re: New strategies for freezing, advancing relfrozenxid early Peter Geoghegan 18:53
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Tom Lane 18:56
Re: New strategies for freezing, advancing relfrozenxid early Justin Pryzby 19:11
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Nathan Bossart 19:12
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Justin Pryzby 19:48
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Peter Geoghegan 20:06
Re: Pluggable toaster Nikita Malakhov 20:37
Re: [PATCH] random_normal function 📎 Paul Ramsey 20:53
Re: Speedup generation of command completion tags David Rowley 21:33
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Tom Lane 21:57
Re: Error-safe user functions 📎 Tom Lane 22:18
RE: Partial aggregates pushdown 📎 [email protected] 22:23
Re: The drop-index-concurrently-1 isolation test no longer tests what it was meant to David Rowley 22:42
Re: wake up logical workers after ALTER SUBSCRIPTION 📎 Nathan Bossart 22:47
Re: SLRUs in the main buffer pool - Page Header definitions 📎 Bagga, Rishu 23:16
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL 📎 David Christensen 23:17
Exclusion constraints on partitioned tables 📎 Paul Jungwirth 23:33
Re: Infinite Interval Joseph Koshakow 23:43
Add enable_presorted_aggregate GUC 📎 David Rowley 23:47

Dec. 16, 2022

Thread Author Time
Re: Exclusion constraints on partitioned tables Tom Lane 00:12
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX 📎 Nathan Bossart 01:19
Re: Add proper planner support for ORDER BY / DISTINCT aggregates David Rowley 02:26
Re: generic plans and "initial" pruning 📎 Amit Langote 02:33
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Amit Kapila 02:46
Typo macro name on FreeBSD? Japin Li 03:43
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 03:51
Re: New strategies for freezing, advancing relfrozenxid early Peter Geoghegan 04:13
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 04:19
Re: Typo macro name on FreeBSD? Thomas Munro 04:25
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Jeff Davis 04:35
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Peter Geoghegan 04:39
Re: fix and document CLUSTER privileges 📎 Nathan Bossart 04:57
Re: Exclusion constraints on partitioned tables 📎 Paul Jungwirth 05:11
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Nathan Bossart 05:13
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Nathan Bossart 05:20
Re: Typo macro name on FreeBSD? Japin Li 05:21
RE: Time delayed LR (WAS Re: logical replication restrictions) Hayato Kuroda (Fujitsu) 06:41
Re: Removing unneeded self joins 📎 Andrey Lepikhov 06:45
Re: Perform streaming logical transactions by background workers and parallel apply Masahiko Sawada 07:08
Re: plpgsq_plugin's stmt_end() is not called when an error is caught Masahiko Sawada 07:23
Re: New strategies for freezing, advancing relfrozenxid early John Naylor 07:48
Re: New strategies for freezing, advancing relfrozenxid early Nikita Malakhov 07:59
Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs) Pavel Stehule 08:05
Re: Inconsistency in reporting checkpointer stats Kyotaro Horiguchi 08:43

Browse Archives

Prev | Next