pgsql-hackers since 2022-11-05 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

Nov. 5, 2022

Thread Author Time
Re: Direct I/O Andres Freund 00:38
Re: CI and test improvements Andres Freund 01:59
Re: Add tracking of backend memory allocated to pg_stat_activity Andres Freund 02:41
Re: pg_reload_conf() synchronously Andres Freund 02:46
Re: Incorrect include file order in guc-file.l Michael Paquier 03:34
Re: pg_reload_conf() synchronously Tom Lane 03:35
Re: pg_reload_conf() synchronously Andres Freund 04:51
Re: pg_reload_conf() synchronously Michael Paquier 05:26
Re: proposal: possibility to read dumped table's name from file Julien Rouhaud 05:39
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 05:43
Re: remap the .text segment into huge pages at run time John Naylor 05:54
Re: Reviving lost replication slots Amit Kapila 06:02
Re: psql: Add command to use extended query protocol Corey Huinker 06:34
Re: remap the .text segment into huge pages at run time Andres Freund 08:27
Re: psql: Add command to use extended query protocol Pavel Stehule 08:46
Re: Add proper planner support for ORDER BY / DISTINCT aggregates Pavel Luzanov 08:51
Re: Lockless queue of waiters in LWLock Alexander Korotkov 09:05
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 09:22
Re: New docs chapter on Transaction Management and related changes 📎 Simon Riggs 10:08
Re: explain_regress, explain(MACHINE), and default to explain(BUFFERS) (was: BUFFERS enabled by default in EXPLAIN (ANALYZE)) Justin Pryzby 13:44
Re: explain_regress, explain(MACHINE), and default to explain(BUFFERS) (was: BUFFERS enabled by default in EXPLAIN (ANALYZE)) Tom Lane 14:43
Re: Add common function ReplicationOriginName. Tom Lane 14:59
Re: Temporary tables versus wraparound... again Tom Lane 15:34
Re: Schema variables - new implementation for Postgres 15 📎 Tomas Vondra 16:04
Re: [patch] Have psql's \d+ indicate foreign partitions Tom Lane 16:39
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud 17:25
Re: pg_dump: Refactor code that constructs ALTER ... OWNER TO commands Corey Huinker 17:39
Re: [PATCH] ALTER TABLE ... SET STORAGE default Tom Lane 17:45
Re: pg_reload_conf() synchronously Andres Freund 18:22
Re: [PATCH] Add native windows on arm64 support Andres Freund 18:31
Re: ssl tests aren't concurrency safe due to get_free_port() Andres Freund 18:36
Re: pg_reload_conf() synchronously Gurjeet Singh 19:03
Re: pg_reload_conf() synchronously Andres Freund 19:26
Re: Lockless queue of waiters in LWLock Andres Freund 19:32
Re: Check SubPlan clause for nonnullable rels/Vars Tom Lane 19:33
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 19:54
Re: Do we need to pass down nonnullable_vars when reducing outer joins? Tom Lane 20:00
Re: archive modules 📎 Nathan Bossart 20:51
Re: archive modules Nathan Bossart 21:08
Re: Documentation for building with meson Andres Freund 21:39
Re: thinko in basic_archive.c Nathan Bossart 21:46
Re: Making Vars outer-join aware 📎 Tom Lane 21:53
Re: Suppressing useless wakeups in walreceiver Nathan Bossart 22:00
Re: Suppressing useless wakeups in walreceiver Nathan Bossart 22:11
Re: Suppressing useless wakeups in walreceiver 📎 Nathan Bossart 23:01

Nov. 6, 2022

Thread Author Time
Re: new option to allow pg_rewind to run without full_page_writes Andres Freund 02:38
Re: explain analyze rows=%.0f Tom Lane 05:12
bug: pg_dump use strange tag for trigger 📎 Pavel Stehule 05:41
RE: Perform streaming logical transactions by background workers and parallel apply [email protected] 06:40
Re: remap the .text segment into huge pages at run time John Naylor 06:56
Re: Improve logging when using Huge Pages John Naylor 07:04
pg_upgrade, tables_with_oids.txt -> tables_with_oids.sql? Daniel Westermann (DWE) 08:48
Re: [patch] Have psql's \d+ indicate foreign partitions 📎 Ian Lawrence Barwick 12:23
Re: Improve logging when using Huge Pages Justin Pryzby 13:04
Re: Small TAP improvements Álvaro Herrera 13:51
Re: bug: pg_dump use strange tag for trigger Tom Lane 14:52
Re: Add LZ4 compression in pg_dump gkokolatos 14:53
Re: Pluggable toaster Nikita Malakhov 14:59
Re: Draft back-branch release notes are up Tom Lane 16:14
Re: bug: pg_dump use strange tag for trigger Pavel Stehule 16:14
Re: [PATCH] New [relation] option engine 📎 Nikolay Shaplov 16:22
Re: ssl tests aren't concurrency safe due to get_free_port() Andrew Dunstan 16:30
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands 📎 Tom Lane 17:54
Re: remap the .text segment into huge pages at run time Andres Freund 18:16
Re: Allow single table VACUUM in transaction block Peter Geoghegan 18:50
Re: [DOCS] Stats views and functions not in order? Tom Lane 18:50
Re: Allow single table VACUUM in transaction block Tom Lane 19:14
Re: Free list same_input_transnos in preprocess_aggref Tom Lane 20:12
Re: Allow single table VACUUM in transaction block Peter Geoghegan 20:40
Re: O(n) tasks cause lengthy startups and checkpoints 📎 Nathan Bossart 22:38

Nov. 7, 2022

Thread Author Time
Re: Check SubPlan clause for nonnullable rels/Vars Richard Guo 02:53
Re: Do we need to pass down nonnullable_vars when reducing outer joins? Richard Guo 02:54
Re: Perform streaming logical transactions by background workers and parallel apply Masahiko Sawada 02:56
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 03:58
Re: explain analyze rows=%.0f Andrey Lepikhov 04:20
Re: Perform streaming logical transactions by background workers and parallel apply Masahiko Sawada 04:32
Re: Free list same_input_transnos in preprocess_aggref Zhang Mingli 04:51
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 05:02
Re: Allow file inclusion in pg_hba and pg_ident files 📎 Michael Paquier 06:07
Re: archive modules Michael Paquier 06:20
Re: [PoC] Reducing planning time when tables have many partitions Andrey Lepikhov 06:21
Re: [PoC] Reducing planning time when tables have many partitions Tom Lane 06:25
Re: [PoC] Reducing planning time when tables have many partitions Zhang Mingli 06:32
Re: [patch] Have psql's \d+ indicate foreign partitions Michael Paquier 06:37
Re: [patch] Have psql's \d+ indicate foreign partitions Tom Lane 06:43
Re: [PATCH] Add native windows on arm64 support Michael Paquier 06:58
Re: ExecRTCheckPerms() and many prunable partitions 📎 Amit Langote 07:03
Re: New docs chapter on Transaction Management and related changes Bruce Momjian 07:43
Re: Add semi-join pushdown to postgres_fdw 📎 Alexander Pyhalov 07:52
Re: Tracking last scan time 📎 Michael Paquier 07:54
Re: Allow single table VACUUM in transaction block Simon Riggs 07:58
Re: Add common function ReplicationOriginName. Aleksander Alekseev 08:16
Re: Perform streaming logical transactions by background workers and parallel apply Peter Smith 08:16
Re: Allow single table VACUUM in transaction block Simon Riggs 08:20
Re: Error for WITH options on partitioned tables Karina Litskevich 08:55
[PATCH] Const'ify the arguments of ilist.c/ilist.h functions 📎 Aleksander Alekseev 09:03
Re: [patch] Adding an assertion to report too long hash table name Zhang Mingli 09:04
Re: Adding doubly linked list type which stores the number of items in the list Aleksander Alekseev 09:06
Use proc instead of MyProc in ProcArrayGroupClearXid()/TransactionGroupUpdateXidStatus() 📎 rajesh singarapu 09:46
Re: Adding doubly linked list type which stores the number of items in the list Bharath Rupireddy 10:00
Re: Adding doubly linked list type which stores the number of items in the list Aleksander Alekseev 10:07
Re: Perform streaming logical transactions by background workers and parallel apply Masahiko Sawada 10:17
Re: Pluggable toaster Aleksander Alekseev 10:35
Re: New docs chapter on Transaction Management and related changes Simon Riggs 10:58
Re: Error for WITH options on partitioned tables Simon Riggs 11:10
Re: thinko in basic_archive.c Bharath Rupireddy 11:23
Postgres auto vacuum - Disable Karthik Jagadish (kjagadis) 11:27
RE: Perform streaming logical transactions by background workers and parallel apply Hayato Kuroda (Fujitsu) 11:42
Re: Postgres auto vacuum - Disable Dave Page 11:47
Re: Postgres auto vacuum - Disable Karthik Jagadish (kjagadis) 12:12
Re: pg_upgrade test failure 📎 Thomas Munro 12:16
Re: Collation version tracking for macOS Peter Eisentraut 12:21
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 13:19
Re: refactor ownercheck and aclcheck functions Antonin Houska 13:19
Re: Postgres auto vacuum - Disable Laurenz Albe 13:22
Re: collect_corrupt_items_vacuum.patch Nikita Malakhov 13:30
Re: Postgres auto vacuum - Disable Julien Rouhaud 13:36
Re: Skipping schema changes in publication 📎 vignesh C 13:39
Re: Code checks for App Devs, using new options for transaction behavior 📎 Simon Riggs 14:25
Re: Postgres auto vacuum - Disable Karthik Jagadish (kjagadis) 14:46
Re: Add proper planner support for ORDER BY / DISTINCT aggregates Ronan Dunklau 14:53
Re: WIN32 pg_import_system_collations Peter Eisentraut 15:08
Re: Improve logging when using Huge Pages Andres Freund 15:14
Re: Draft back-branch release notes are up Jonathan S. Katz 15:30
Re: Draft back-branch release notes are up Jonathan S. Katz 15:34
2022-11-10 release announcement draft 📎 Jonathan S. Katz 15:51
Re: Improve logging when using Huge Pages Tom Lane 15:56
Re: 2022-11-10 release announcement draft Erikjan Rijkers 15:59
Re: PL/pgSQL cursors should get generated portal names by default Jan Wieck 16:10
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment Andres Freund 16:24
Re: 2022-11-10 release announcement draft Jonathan S. Katz 16:25
Re: PL/pgSQL cursors should get generated portal names by default Pavel Stehule 16:32
Re: PL/pgSQL cursors should get generated portal names by default Kirk Wolak 16:57
Re: Add proper planner support for ORDER BY / DISTINCT aggregates Pavel Luzanov 16:58
allow segment size to be set to < 1GiB 📎 Andres Freund 17:13
Re: Add proper planner support for ORDER BY / DISTINCT aggregates Ronan Dunklau 17:30
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Robert Haas 17:42
Re: allow segment size to be set to < 1GiB Tom Lane 17:52
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎 Maciek Sakrejda 18:26
Re: psql: Add command to use extended query protocol Corey Huinker 20:27
Re: Add proper planner support for ORDER BY / DISTINCT aggregates Pavel Luzanov 20:37
Re: [PATCH] pgbench: add multiconnect option 📎 Fabien COELHO 20:46
Re: psql: Add command to use extended query protocol Tom Lane 21:12
Re: SUBTRANS: Minimizing calls to SubTransSetParent() Simon Riggs 21:14
Re: archive modules Nathan Bossart 21:15
Re: Add tracking of backend memory allocated to pg_stat_activity Melanie Plageman 21:17
Re: thinko in basic_archive.c Nathan Bossart 21:48
Re: PL/pgSQL cursors should get generated portal names by default Jan Wieck 21:54
Re: New docs chapter on Transaction Management and related changes Laurenz Albe 22:04
Re: Improve logging when using Huge Pages Thomas Munro 22:34
Re: Large Pages and Super Pages for PostgreSQL 📎 Thomas Munro 22:59
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL 📎 David Christensen 23:01
Re: new option to allow pg_rewind to run without full_page_writes 📎 Jérémie Grauer 23:07

Nov. 8, 2022

Thread Author Time
Re: new option to allow pg_rewind to run without full_page_writes Thomas Munro 00:04
Re: [DOCS] Stats views and functions not in order? 📎 Peter Smith 00:18
Re: new option to allow pg_rewind to run without full_page_writes Andres Freund 00:34
Re: Allow single table VACUUM in transaction block Peter Geoghegan 00:34
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert 📎 Jacob Champion 01:04
Re: Allow file inclusion in pg_hba and pg_ident files 📎 Michael Paquier 01:04
Re: Add proper planner support for ORDER BY / DISTINCT aggregates 📎 David Rowley 01:31
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment David Rowley 01:57
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment David Rowley 02:01
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment John Naylor 02:17
Re: Suppressing useless wakeups in walreceiver Thomas Munro 02:20
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment Andres Freund 02:25
Re: allow segment size to be set to < 1GiB Andres Freund 02:29
Re: In-placre persistance change of a relation Kyotaro Horiguchi 02:33
Re: allow segment size to be set to < 1GiB Tom Lane 02:36
Re: psql: Add command to use extended query protocol Corey Huinker 02:47
RE: Logical replication timeout problem 📎 [email protected] 03:04
Re: Allow single table VACUUM in transaction block Simon Riggs 03:10
Re: New docs chapter on Transaction Management and related changes Laurenz Albe 03:37
Re: New docs chapter on Transaction Management and related changes 📎 Bruce Momjian 03:41
Re: New docs chapter on Transaction Management and related changes Bruce Momjian 03:43
RE: Perform streaming logical transactions by background workers and parallel apply Hayato Kuroda (Fujitsu) 03:51
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment David Rowley 03:53
Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment David Rowley 03:54
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 03:56
Re: psql: Add command to use extended query protocol Pavel Stehule 04:01
Re: Support logical replication of DDLs 📎 Ajin Cherian 04:03
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? Michael Paquier 04:07
Re: Tracking last scan time Michael Paquier 04:09
RE: Data is copied twice when specifying both child and parent table in publication Takamichi Osumi (Fujitsu) 04:12
Re: psql: Add command to use extended query protocol David G. Johnston 04:21
Re: psql: Add command to use extended query protocol Pavel Stehule 04:29
RE: logical replication restrictions Hayato Kuroda (Fujitsu) 05:27
Re: allow segment size to be set to < 1GiB Bharath Rupireddy 05:36
Re: [patch] Have psql's \d+ indicate foreign partitions Michael Paquier 05:49
Re: generic plans and "initial" pruning 📎 Amit Langote 06:22
Re: Use proc instead of MyProc in ProcArrayGroupClearXid()/TransactionGroupUpdateXidStatus() Bharath Rupireddy 06:26
Re: Use proc instead of MyProc in ProcArrayGroupClearXid()/TransactionGroupUpdateXidStatus() Amit Kapila 06:28
Re: Reviving lost replication slots sirisha chamarthi 06:37
Re: [patch] Have psql's \d+ indicate foreign partitions Ian Lawrence Barwick 06:38
Re: Add proper planner support for ORDER BY / DISTINCT aggregates Pavel Luzanov 06:39
Re: Add proper planner support for ORDER BY / DISTINCT aggregates Richard Guo 06:51
Re: Use proc instead of MyProc in ProcArrayGroupClearXid()/TransactionGroupUpdateXidStatus() rajesh singarapu 06:58
Re: Reviving lost replication slots Bharath Rupireddy 07:17
Re: Suppressing useless wakeups in walreceiver Thomas Munro 07:46
Re: Add index scan progress to pg_stat_progress_vacuum Masahiko Sawada 07:49
Re: Suppressing useless wakeups in walreceiver Bharath Rupireddy 08:20

Browse Archives

Prev | Next