pgsql-hackers since 2022-01-28 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)

Advanced Search

Browse Archives

Prev | Next

Jan. 28, 2022

Thread	Author	Time
Re: logical decoding and replication of sequences 📎	Tomas Vondra	00:25
Re: do only critical work during single-user vacuum? 📎	Justin Pryzby	01:28
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Kyotaro Horiguchi	01:38
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Kyotaro Horiguchi	01:41
Re: Creation of an empty table is not fsync'd at checkpoint	Thomas Munro	01:48
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Julien Rouhaud	02:00
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Kyotaro Horiguchi	02:10
substring odd behavior	Regina Obe	02:22
Re: pg_log_backend_memory_contexts() and log level	Fujii Masao	02:27
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Kyotaro Horiguchi	02:35
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Bharath Rupireddy	02:47
Re: substring odd behavior	David G. Johnston	02:54
Re: Creation of an empty table is not fsync'd at checkpoint	Thomas Munro	03:02
Re: substring odd behavior	Tom Lane	03:06
Re: substring odd behavior	Mark Dilger	03:11
Re: substring odd behavior	Julien Rouhaud	03:12
Re: Add checkpoint and redo LSN to LogCheckpointEnd log message 📎	Bharath Rupireddy	03:13
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Julien Rouhaud	03:24
RE: row filtering for logical replication 📎	houzj.fnst@fujitsu.com	03:26
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Bharath Rupireddy	03:28
Re: make MaxBackends available in _PG_init	Michael Paquier	04:22
Re: GUC flags 📎	Justin Pryzby	04:36
RE: Support escape sequence for cluster_name in postgres_fdw.application_name	r.takahashi_2@fujitsu.com	05:07
Re: Add connection active, idle time to pg_stat_activity	Kyotaro Horiguchi	05:36
Re: Add connection active, idle time to pg_stat_activity	Kyotaro Horiguchi	05:40
Re: Add connection active, idle time to pg_stat_activity	Kyotaro Horiguchi	05:43
Re: Add checkpoint and redo LSN to LogCheckpointEnd log message	Nathan Bossart	05:46
Re: Design of pg_stat_subscription_workers vs pgstats	Amit Kapila	05:59
RE: Support tab completion for upper character inputs in psql	tanghy.fnst@fujitsu.com	06:37
Re: Add checkpoint and redo LSN to LogCheckpointEnd log message	Bharath Rupireddy	06:39
Re: [BUG]Update Toast data failure in logical replication 📎	Dilip Kumar	06:46
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	06:51
Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs)	Bharath Rupireddy	06:54
Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples?	Laurenz Albe	07:22
Re: Suppressing useless wakeups in walreceiver	Kyotaro Horiguchi	07:26
Re: Is it correct to update db state in control file as "shutting down" during end-of-recovery checkpoint?	Kyotaro Horiguchi	07:57
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint? 📎	Bharath Rupireddy	08:19
Re: Printing backtrace of postgres processes	Bharath Rupireddy	08:24
Re: Column Filtering in Logical Replication	Peter Smith	08:39
Re: RFC: Logging plan of the running query 📎	torikoshia	08:45
pg_log_backend_memory_contexts - remove unnecessary test case 📎	Bharath Rupireddy	08:45
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Julien Rouhaud	08:50
Re: refactoring basebackup.c 📎	Dipesh Pandit	08:54
Re: Add header support to text format and matching feature	Peter Eisentraut	08:57
Re: Is it correct to update db state in control file as "shutting down" during end-of-recovery checkpoint?	Kyotaro Horiguchi	09:32
Re: Suppressing useless wakeups in walreceiver 📎	Thomas Munro	09:41
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade	Denis Laxalde	10:02
Re: row filtering for logical replication	Greg Nancarrow	10:06
Re: TAP test to cover "EndOfLogTLI != replayTLI" case	Amul Sul	10:10
BeginCopyTo - remove switching to old memory context in between COPY TO command processing 📎	Bharath Rupireddy	10:11
Re: refactoring basebackup.c	tushar	10:45
Server-side base backup: why superuser, not pg_write_server_files?	Dagfinn Ilmari Mannsåker	10:58
Re: BeginCopyTo - remove switching to old memory context in between COPY TO command processing	Japin Li	11:01
Re: BeginCopyTo - remove switching to old memory context in between COPY TO command processing	Michael Paquier	11:23
Re: Logical replication timeout problem	Fabrice Chapuis	11:35
Re: UNIQUE null treatment option	Pavel Borisov	12:56
Re: Parameter for planner estimate of recursive queries	Hamid Akhtar	13:40
Re: pg_upgrade should truncate/remove its logs before running	Michael Paquier	13:42
Re: refactoring basebackup.c	Robert Haas	13:42
Re: Server-side base backup: why superuser, not pg_write_server_files?	Robert Haas	13:44
Re: row filtering for logical replication	Alvaro Herrera	13:51
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade	Julien Rouhaud	13:56
Re: Unlogged relations and WAL-logging	Robert Haas	13:57
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade	Denis Laxalde	14:06
Re: Parameter for planner estimate of recursive queries	Robert Haas	14:07
Re: Support for NSS as a libpq TLS backend	Daniel Gustafsson	14:08
Re: Support escape sequence for cluster_name in postgres_fdw.application_name	Robert Haas	14:10
Remove extra includes of "access/xloginsert.h" when "access/xlog.h" is included 📎	Bharath Rupireddy	14:10
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade*	Julien Rouhaud	14:18
Re: Support for NSS as a libpq TLS backend	Robert Haas	14:30
Re: Add 64-bit XIDs into PostgreSQL 15	Aleksander Alekseev	14:30
Re: Make relfile tombstone files conditional on WAL level 📎	Dilip Kumar	14:40
Re: warn if GUC set to an invalid shared library	Robert Haas	14:42
Re: Add 64-bit XIDs into PostgreSQL 15	Pavel Borisov	14:43
Re: A test for replay of regression tests	Andrew Dunstan	14:46
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint? 📎	Bharath Rupireddy	14:51
Re: Support for NSS as a libpq TLS backend	Daniel Gustafsson	15:10
Re: Server-side base backup: why superuser, not pg_write_server_files?	Dagfinn Ilmari Mannsåker	15:28
Re: Remove extra includes of "access/xloginsert.h" when "access/xlog.h" is included	Alvaro Herrera	15:55
Re: Support tab completion for upper character inputs in psql	Tom Lane	16:03
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Julien Rouhaud	16:10
Re: Multiple Query IDs for a rewritten parse tree	Dmitry Dolgov	16:51
Re: Server-side base backup: why superuser, not pg_write_server_files? 📎	Dagfinn Ilmari Mannsåker	17:15
Re: Server-side base backup: why superuser, not pg_write_server_files?	Robert Haas	17:33
Re: Server-side base backup: why superuser, not pg_write_server_files?	Dagfinn Ilmari Mannsåker	17:35
Re: refactoring basebackup.c 📎	Jeevan Ladhe	17:48
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade	Andres Freund	18:20
Re: archive modules	Robert Haas	19:06
Re: refactoring basebackup.c	Robert Haas	19:49
Re: archive modules	Nathan Bossart	20:01
Re: archive modules	Robert Haas	20:20
Re: support for MERGE 📎	Alvaro Herrera	20:27
Re: Support tab completion for upper character inputs in psql 📎	Tom Lane	21:25
Re: Support tab completion for upper character inputs in psql 📎	Tom Lane	22:16
Re: support for MERGE	Andres Freund	22:19
Re: support for MERGE	Zhihong Yu	22:32
Re: Add 64-bit XIDs into PostgreSQL 15	Andres Freund	22:43
Re: support for MERGE	Justin Pryzby	23:19
Re: pg_upgrade should truncate/remove its logs before running	Andrew Dunstan	23:27
Re: support for MERGE 📎	Erik Rijkers	23:33
Re: warn if GUC set to an invalid shared library	Cary Huang	23:36
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Andres Freund	23:37
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Andres Freund	23:39
Re: archive modules	Nathan Bossart	23:39
Re: Add last commit LSN to pg_last_committed_xact()	James Coleman	23:43

Jan. 29, 2022

Thread	Author	Time
Re: warn if GUC set to an invalid shared library	Justin Pryzby	00:09
Re: row filtering for logical replication	Andres Freund	00:31
Re: Add last commit LSN to pg_last_committed_xact()	Andres Freund	00:36
Re: Add last commit LSN to pg_last_committed_xact()	Andres Freund	00:47
Re: pg_upgrade should truncate/remove its logs before running	Michael Paquier	00:53
Re: Is it correct to update db state in control file as "shutting down" during end-of-recovery checkpoint?	Michael Paquier	02:12
Re: make MaxBackends available in _PG_init	Michael Paquier	02:19
Re: Printing backtrace of postgres processes 📎	vignesh C	02:36
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade	Julien Rouhaud	02:50
Re: Bugs in pgoutput.c	Amit Kapila	03:02
Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples?	Peter Geoghegan	03:35
Re: refactoring basebackup.c	Jeevan Ladhe	03:38
Re: make MaxBackends available in _PG_init	Nathan Bossart	04:33
Re: Schema variables - new implementation for Postgres 15	Julien Rouhaud	05:19
Re: make MaxBackends available in _PG_init	Michael Paquier	05:24
Re: GUC flags 📎	Michael Paquier	06:38
Re: Multiple Query IDs for a rewritten parse tree	Julien Rouhaud	07:51
Re: [BUG]Update Toast data failure in logical replication 📎	Amit Kapila	10:26
Re: [PATCH] New default role allowing to change per-role/database settings 📎	Michael Banck	11:10
Re: Remove extra includes of "access/xloginsert.h" when "access/xlog.h" is included 📎	Bharath Rupireddy	13:42
Replace pg_controldata output fields with macros for better code manageability	Bharath Rupireddy	14:30
Re: Is it correct to update db state in control file as "shutting down" during end-of-recovery checkpoint?	Bharath Rupireddy	14:37
Re: psql - add SHOW_ALL_RESULTS option	Fabien COELHO	14:40
Re: Allow users to choose what happens when recovery target is not reached	Bharath Rupireddy	15:05
Re: Multiple Query IDs for a rewritten parse tree	Dmitry Dolgov	17:12
Re: Multiple Query IDs for a rewritten parse tree	Julien Rouhaud	17:48
Re: Multiple Query IDs for a rewritten parse tree	Dmitry Dolgov	18:00
Re: Remove extra includes of "access/xloginsert.h" when "access/xlog.h" is included	Alvaro Herrera	19:37
Re: Add last commit LSN to pg_last_committed_xact() 📎	James Coleman	19:51
Re: row filtering for logical replication	Alvaro Herrera	20:05
Re: pg_basebackup WAL streamer shutdown is bogus - leading to slow tests	Andres Freund	20:44
Re: archive modules 📎	Nathan Bossart	20:50
Re: Windows crash / abort handling	Andres Freund	21:02
Re: pg_basebackup WAL streamer shutdown is bogus - leading to slow tests 📎	Andres Freund	21:47
Re: support for MERGE 📎	Alvaro Herrera	21:49

Jan. 30, 2022

Thread	Author	Time
Re: GUC flags	Justin Pryzby	00:18
Re: archive modules 📎	Nathan Bossart	00:31
[PATCH] nodeindexscan with reorder memory leak 📎	Aliaksandr Kalenik	02:49
Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations 📎	Peter Geoghegan	04:42
Re: archive modules 📎	Nathan Bossart	05:01
Re: CREATEROLE and role ownership hierarchies 📎	Mark Dilger	05:58
RE: Support tab completion for upper character inputs in psql	tanghy.fnst@fujitsu.com	07:07
RE: Support tab completion for upper character inputs in psql	tanghy.fnst@fujitsu.com	07:13
RE: logical replication empty transactions	osumi.takamichi@fujitsu.com	08:04
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	13:15
Re: Remove extra includes of "access/xloginsert.h" when "access/xlog.h" is included 📎	Bharath Rupireddy	13:22
Re: Remove extra includes of "access/xloginsert.h" when "access/xlog.h" is included	Julien Rouhaud	14:49
Re: Remove extra includes of "access/xloginsert.h" when "access/xlog.h" is included	Alvaro Herrera	15:27
Re: pg_basebackup WAL streamer shutdown is bogus - leading to slow tests	Magnus Hagander	15:45
Re: pg_basebackup WAL streamer shutdown is bogus - leading to slow tests	Magnus Hagander	15:51
Re: [PATCH] nodeindexscan with reorder memory leak	Tom Lane	16:02
Re: [PATCH] nodeindexscan with reorder memory leak 📎	Tom Lane	16:24
Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples?	Justin Pryzby	17:00
Re: BufferAlloc: don't take two simultaneous locks	Michail Nikolaev	17:27
Re: Support tab completion for upper character inputs in psql	Tom Lane	18:34
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	19:09
Re: plperl on windows	Andres Freund	20:56
Re: drop tablespace failed when location contains .. on win32 📎	Tom Lane	21:50
Re: plperl on windows	Andres Freund	22:16
Re: CREATEROLE and role ownership hierarchies	Michael Banck	22:38
Re: Postgresql Windows build and modern perl (>=5.28) 📎	Andres Freund	22:39
Re: pg_basebackup WAL streamer shutdown is bogus - leading to slow tests	Andres Freund	22:44
Re: Add header support to text format and matching feature 📎	Rémi Lapeyre	22:56
Re: plperl on windows	Noah Misch	23:14
Re: plperl on windows	Andres Freund	23:34

Jan. 31, 2022

Thread	Author	Time
Re: pg_basebackup WAL streamer shutdown is bogus - leading to slow tests 📎	Andres Freund	00:41
Re: row filtering for logical replication 📎	Peter Smith	00:52
Re: CREATEROLE and role ownership hierarchies	Mark Dilger	01:11
Re: Support tab completion for upper character inputs in psql 📎	Dagfinn Ilmari Mannsåker	01:28
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Kyotaro Horiguchi	01:50
Re: Support tab completion for upper character inputs in psql	Tom Lane	01:54
RE: row filtering for logical replication 📎	houzj.fnst@fujitsu.com	01:57
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Kyotaro Horiguchi	02:10
RE: row filtering for logical replication	houzj.fnst@fujitsu.com	02:12
Latest LLVM breaks our code again	Tom Lane	02:38
Re: row filtering for logical replication	Greg Nancarrow	03:12
Re: [BUG]Update Toast data failure in logical replication	Dilip Kumar	03:32
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Julien Rouhaud	03:40
Re: DELETE CASCADE	Julien Rouhaud	03:46
Re: Printing backtrace of postgres processes	vignesh C	04:04
Re: pgsql: Server-side gzip compression.	David Rowley	04:07
Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples?	David Rowley	04:28
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work 📎	Bharath Rupireddy	05:12
Re: GUC flags	Michael Paquier	05:17
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Bharath Rupireddy	05:28
Re: Make relfile tombstone files conditional on WAL level 📎	Dilip Kumar	05:29
Re: Error "initial slot snapshot too large" in create replication slot	Kyotaro Horiguchi	05:31
Re: Spelling change in LLVM 14 API 📎	Thomas Munro	05:34
Re: Latest LLVM breaks our code again	Thomas Munro	05:46
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?	Julien Rouhaud	05:54
Re: Error "initial slot snapshot too large" in create replication slot 📎	Kyotaro Horiguchi	06:20
Re: Add header support to text format and matching feature	Peter Eisentraut	06:54
Re: Error "initial slot snapshot too large" in create replication slot	Dilip Kumar	07:04
Re: make MaxBackends available in _PG_init	Michael Paquier	07:11
Re: Column Filtering in Logical Replication	Peter Eisentraut	07:13

Browse Archives

Prev | Next