pgsql-hackers since 2022-03-13 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

March 13, 2022

Thread Author Time
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) Michael Paquier 00:45
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) Justin Pryzby 00:56
Re: range_agg with multirange inputs Chapman Flack 02:03
Re: logical decoding and replication of sequences 📎 Peter Eisentraut 06:45
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir 📎 Bharath Rupireddy 08:24
Re: postgres_fdw: commit remote (sub)transactions in parallel during pre-commit Etsuro Fujita 09:28
Re: Defer selection of asynchronous subplans until the executor initialization stage Etsuro Fujita 09:39
Re: BufferAlloc: don't take two simultaneous locks 📎 Yura Sokolov 10:24
Re: Add id's to various elements in protocol.sgml Brar Piening 10:26
Re: Support logical replication of DDLs Dilip Kumar 11:35
Re: BufferAlloc: don't take two simultaneous locks Zhihong Yu 14:05
Tab completion not listing schema list for create/alter publication for all tables in schema 📎 vignesh C 17:03
Re: Issue with pg_stat_subscription_stats Melanie Plageman 17:05
Re: Column Filtering in Logical Replication 📎 Tomas Vondra 21:07
Re: SQL/JSON: JSON_TABLE Andrew Dunstan 21:22
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart 21:58
Re: BufferAlloc: don't take two simultaneous locks 📎 Yura Sokolov 22:27
Re: On login trigger: take three Daniel Gustafsson 22:31
Re: BufferAlloc: don't take two simultaneous locks Zhihong Yu 22:40
Re: On login trigger: take three Andres Freund 23:33
Re: Tab completion not listing schema list for create/alter publication for all tables in schema Tom Lane 23:53
Re: On login trigger: take three Tom Lane 23:57

March 14, 2022

Thread Author Time
Re: On login trigger: take three Andres Freund 00:08
Re: On login trigger: take three Tom Lane 00:35
Re: BufferAlloc: don't take two simultaneous locks Kyotaro Horiguchi 00:39
Re: BufferAlloc: don't take two simultaneous locks Kyotaro Horiguchi 00:44
Re: logical decoding and replication of sequences 📎 Tomas Vondra 00:46
Re: Add index scan progress to pg_stat_progress_vacuum Masahiko Sawada 01:44
Re: pg_walinspect - a new extension to get raw WAL data and WAL stats Kyotaro Horiguchi 01:58
Re: On login trigger: take three Andres Freund 02:17
Re: Allow async standbys wait for sync replication Kyotaro Horiguchi 02:30
Re: Allow async standbys wait for sync replication Kyotaro Horiguchi 02:41
Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations 📎 Peter Geoghegan 04:05
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) Michael Paquier 04:53
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Michael Paquier 05:15
Re: WIP: WAL prefetch (another approach) 📎 Thomas Munro 05:15
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy 05:24
Re: BufferAlloc: don't take two simultaneous locks Kyotaro Horiguchi 05:31
Re: BufferAlloc: don't take two simultaneous locks Yura Sokolov 06:15
Re: [PATCH] Accept IP addresses in server certificate SANs Kyotaro Horiguchi 06:30
Re: WIP: WAL prefetch (another approach) Julien Rouhaud 07:17
Re: ExecRTCheckPerms() and many prunable partitions 📎 Amit Langote 07:36
Re: Issue with pg_stat_subscription_stats 📎 Masahiko Sawada 08:02
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Michael Paquier 08:03
Re: BufferAlloc: don't take two simultaneous locks Kyotaro Horiguchi 08:12
Re: simplifying foreign key/RI checks 📎 Amit Langote 08:33
Re: BufferAlloc: don't take two simultaneous locks Kyotaro Horiguchi 08:34
Re: On login trigger: take three Daniel Gustafsson 08:50
Re: simplifying foreign key/RI checks Zhihong Yu 09:32
Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Nitin Jadhav 09:46
RE: Skipping logical replication transactions on subscriber side 📎 shiy.fnst@fujitsu.com 09:50
Re: Column Filtering in Logical Replication Amit Kapila 09:53
Re: Implementing Incremental View Maintenance 📎 Yugo NAGATA 10:12
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy 10:24
Re: Implementing Incremental View Maintenance Yugo NAGATA 10:26
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev 10:32
Re: Add 64-bit XIDs into PostgreSQL 15 📎 Aleksander Alekseev 10:33
Re: Optionally automatically disable logical replication subscriptions on error Amit Kapila 10:49
RE: Column Filtering in Logical Replication 📎 houzj.fnst@fujitsu.com 11:12
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir 📎 Bharath Rupireddy 11:33
Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Julien Rouhaud 11:45
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints 📎 Dilip Kumar 11:51
RE: Optionally automatically disable logical replication subscriptions on error osumi.takamichi@fujitsu.com 11:53
Re: BufferAlloc: don't take two simultaneous locks Yura Sokolov 11:57
Re: Column Filtering in Logical Replication Tomas Vondra 12:05
Re: Column Filtering in Logical Replication Tomas Vondra 12:11
Re: Tab completion not listing schema list for create/alter publication for all tables in schema vignesh C 12:17
RE: Skipping logical replication transactions on subscriber side osumi.takamichi@fujitsu.com 12:39
Re: [PATCH] Add reloption for views to enable RLS 📎 Christoph Heiss 12:40
Re: Column Filtering in Logical Replication Amit Kapila 12:47
Re: ICU for global collation 📎 Peter Eisentraut 12:50
Re: On login trigger: take three Robert Haas 13:18
Re: refactoring basebackup.c Robert Haas 13:27
Re: Column Filtering in Logical Replication Tomas Vondra 13:32
Re: On login trigger: take three 📎 Daniel Gustafsson 13:47
Re: Add 64-bit XIDs into PostgreSQL 15 📎 Maxim Orlov 14:16
Re: pg_stat_statements and "IN" conditions Robert Haas 14:17
Re: support for MERGE Amit Langote 14:36
Re: role self-revocation Stephen Frost 14:38
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov 14:48
Re: pg_walinspect - a new extension to get raw WAL data and WAL stats Stephen Frost 14:55
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov 14:57
Re: pg_stat_statements and "IN" conditions Robert Haas 15:02
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov 15:10
Re: support for MERGE Japin Li 15:16
Re: pg_stat_statements and "IN" conditions Tom Lane 15:23
Re: Estimating HugePages Requirements? Magnus Hagander 15:26
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Robert Haas 15:33
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov 15:33
Re: pg_stat_statements and "IN" conditions Tom Lane 15:38
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov 15:43
Re: role self-revocation Mark Dilger 15:45
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov 15:51
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints 📎 Robert Haas 16:04
Re: On login trigger: take three Andres Freund 16:10
Re: refactoring basebackup.c 📎 Dipesh Pandit 16:11
Re: [PATCH] Add reloption for views to enable RLS Laurenz Albe 16:16
Re: Add index scan progress to pg_stat_progress_vacuum 📎 Imseih (AWS), Sami 16:20
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Robert Haas 16:34
Re: refactoring basebackup.c (zstd workers) Justin Pryzby 16:35
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Dilip Kumar 16:44
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Robert Haas 16:55
Re: Non-replayable WAL records through overflows and >MaxAllocSize lengths 📎 Matthias van de Meent 16:57
Re: Allow async standbys wait for sync replication Andres Freund 17:00
Re: refactoring basebackup.c (zstd workers) Robert Haas 17:02
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart 17:04
Re: refactoring basebackup.c (zstd workers) Justin Pryzby 17:11
Re: Non-replayable WAL records through overflows and >MaxAllocSize lengths Andres Freund 17:14
Re: refactoring basebackup.c (zstd workers) Robert Haas 17:21
Re: obsolete reference to a SubPlan field Robert Haas 17:31
Re: Estimating HugePages Requirements? 📎 Nathan Bossart 17:34
Re: obsolete reference to a SubPlan field Tom Lane 17:45
Re: obsolete reference to a SubPlan field Robert Haas 18:27
Re: Lowering the ever-growing heap->pd_lower Peter Geoghegan 18:33
Re: Issue with pg_stat_subscription_stats Melanie Plageman 18:34
Re: generic plans and "initial" pruning Robert Haas 18:42
Re: ICU for global collation Robert Haas 18:57
Re: Fix uninitialized variable access (src/backend/utils/mmgr/freepage.c) Robert Haas 19:15
Re: Fix uninitialized variable access (src/backend/utils/mmgr/freepage.c) Peter Geoghegan 19:30
Re: generic plans and "initial" pruning Tom Lane 19:38
Re: generic plans and "initial" pruning Robert Haas 20:06
Re: Query about time zone patterns in to_char Robert Haas 20:52
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade Robert Haas 21:12
Re: document the need to analyze partitioned tables Robert Haas 21:23
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Robert Haas 21:37
Re: Add index scan progress to pg_stat_progress_vacuum 📎 Imseih (AWS), Sami 22:21
Re: Logical replication timeout problem Björn Harrtell 22:23
[PATCH] Fix various spelling errors 📎 Kekalainen, Otto 23:03
Re: Optionally automatically disable logical replication subscriptions on error 📎 Nathan Bossart 23:04
Re: [PATCH] Fix various spelling errors 📎 Justin Pryzby 23:49

March 15, 2022

Thread Author Time
Change the csv log to 'key:value' to facilitate the user to understanding and processing of logs lupeng 01:31
Re: pg_tablespace_location() failure with allow_in_place_tablespaces 📎 Thomas Munro 01:33
RE: Handle infinite recursion in logical replication setup kuroda.hayato@fujitsu.com 01:39
Re: pg_tablespace_location() failure with allow_in_place_tablespaces Thomas Munro 01:44
Re: pg_tablespace_location() failure with allow_in_place_tablespaces Michael Paquier 01:50
Re: pg_walinspect - a new extension to get raw WAL data and WAL stats Bharath Rupireddy 01:51
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) Michael Paquier 01:59
RE: Optionally automatically disable logical replication subscriptions on error osumi.takamichi@fujitsu.com 02:01
Re: Add 64-bit XIDs into PostgreSQL 15 Kyotaro Horiguchi 02:02
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Michael Paquier 02:04
RE: Column Filtering in Logical Replication shiy.fnst@fujitsu.com 02:08
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) Justin Pryzby 02:37
Re: Estimating HugePages Requirements? Michael Paquier 02:41
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) Michael Paquier 02:44
Re: [PATCH] Fix various spelling errors Michael Paquier 02:46
Re: Speed up transaction completion faster after many relations are accessed in a transaction 📎 David Rowley 02:47
Re: Skipping logical replication transactions on subscriber side Masahiko Sawada 02:51
Re: pg_tablespace_location() failure with allow_in_place_tablespaces Thomas Munro 02:55
Re: Issue with pg_stat_subscription_stats Amit Kapila 04:04
RE: Handle infinite recursion in logical replication setup kuroda.hayato@fujitsu.com 04:25
Re: Issue with pg_stat_subscription_stats Masahiko Sawada 04:38
Re: Column Filtering in Logical Replication Amit Kapila 04:43
Re: Column Filtering in Logical Replication Amit Kapila 04:46
Re: BufferAlloc: don't take two simultaneous locks 📎 Yura Sokolov 05:07
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Kyotaro Horiguchi 06:09
Re: Skipping logical replication transactions on subscriber side 📎 Masahiko Sawada 06:13
Re: generic plans and "initial" pruning Amit Langote 06:19
Re: Support logical replication of DDLs rajesh singarapu 06:27
Re: Add checkpoint and redo LSN to LogCheckpointEnd log message Bharath Rupireddy 06:49
Can we consider "24 Hours" for "next day" in INTERVAL datatype ? Prabhat Sahu 07:24
Re: BufferAlloc: don't take two simultaneous locks Kyotaro Horiguchi 07:25
Re: Allow async standbys wait for sync replication Bharath Rupireddy 07:38
Re: Can we consider "24 Hours" for "next day" in INTERVAL datatype ? Laurenz Albe 07:40
Re: ICU for global collation Julien Rouhaud 07:41
Re: Can we consider "24 Hours" for "next day" in INTERVAL datatype ? Julien Rouhaud 07:46
Re: Add checkpoint and redo LSN to LogCheckpointEnd log message 📎 Kyotaro Horiguchi 08:23
Re: POC: GROUP BY optimization 📎 Tomas Vondra 08:26
Re: Column Filtering in Logical Replication Tomas Vondra 08:30
Re: Add checkpoint and redo LSN to LogCheckpointEnd log message Michael Paquier 09:26
Re: pg_tablespace_location() failure with allow_in_place_tablespaces Michael Paquier 09:30
Re: Assert in pageinspect with NULL pages 📎 Michael Paquier 09:32
Re: Query about time zone patterns in to_char Nitin Jadhav 09:32
Re: support for MERGE Amit Langote 09:40
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints 📎 Dilip Kumar 09:53
Re: pg_tablespace_location() failure with allow_in_place_tablespaces Thomas Munro 10:16
Re: Skipping logical replication transactions on subscriber side Amit Kapila 10:18
Re: refactoring basebackup.c Jeevan Ladhe 10:33
Re: BufferAlloc: don't take two simultaneous locks Yura Sokolov 10:47
Re: Assert in pageinspect with NULL pages Justin Pryzby 11:56
Re: Can we consider "24 Hours" for "next day" in INTERVAL datatype ? Joseph Koshakow 12:14
Re: Change the csv log to 'key:value' to facilitate the user to understanding and processing of logs Julien Rouhaud 12:38
Re: Change the csv log to 'key:value' to facilitate the user to understanding and processing of logs hubert depesz lubaczewski 13:30
Re: Add pg_freespacemap extension sql test Dong Wook Lee 13:50
Re: speed up a logical replica setup 📎 Peter Eisentraut 13:51
RE: Skipping logical replication transactions on subscriber side osumi.takamichi@fujitsu.com 14:00
Re: Change the csv log to 'key:value' to facilitate the user to understanding and processing of logs Andrew Dunstan 14:12
Re: Change the csv log to 'key:value' to facilitate the user to understanding and processing of logs Jan Wieck 14:33
Re: BufferAlloc: don't take two simultaneous locks Yura Sokolov 15:10
Re: Add 64-bit XIDs into PostgreSQL 15 📎 Maxim Orlov 15:48
Re: Add 64-bit XIDs into PostgreSQL 15 Michael Banck 16:15
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Ashutosh Sharma 16:30
Re: [PATCH] Fix various spelling errors Kekalainen, Otto 16:40
Re: Corruption during WAL replay 📎 Robert Haas 16:44
Re: [PATCH] Fix various spelling errors Tom Lane 16:46
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Robert Haas 16:47
Re: ICU for global collation Peter Eisentraut 16:58
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Ashutosh Sharma 17:26
Re: ICU for global collation Robert Haas 17:28
pgsql: Add 'basebackup_to_shell' contrib module. Robert Haas 17:33
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints 📎 Robert Haas 17:39

Browse Archives

Prev | Next