pgsql-hackers since 2023-03-17 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

March 17, 2023

Thread	Author	Time
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes?	Andres Freund	00:00
Re: Allow logical replication to copy tables in binary format	Amit Kapila	00:02
Re: Remove last traces of SCM credential auth from libpq? 📎	Michael Paquier	00:04
Re: Dropped and generated columns might cause wrong data on subs when REPLICA IDENTITY FULL	Amit Kapila	00:08
Re: Remove last traces of SCM credential auth from libpq?	Tom Lane	00:10
Re: Dropped and generated columns might cause wrong data on subs when REPLICA IDENTITY FULL	Tom Lane	00:11
Re: Dropped and generated columns might cause wrong data on subs when REPLICA IDENTITY FULL	Amit Kapila	00:14
Re: suppressing useless wakeups in logical/worker.c 📎	Nathan Bossart	00:22
Re: Remove last traces of SCM credential auth from libpq?	Michael Paquier	00:30
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode 📎	Melanie Plageman	00:35
Re: slapd logs to syslog during tests	Andres Freund	00:48
Re: Allow logical replication to copy tables in binary format	Peter Smith	01:12
Re: SQL/JSON revisited 📎	Andrew Dunstan	01:14
Re: Amcheck verification of GiST and GIN	Peter Geoghegan	01:22
Re: "current directory" in a server error message	Kyotaro Horiguchi	01:32
Re: Allow logical replication to copy tables in binary format	Peter Smith	01:57
Re: Add LZ4 compression in pg_dump	Tomas Vondra	02:02
Re: Add pg_walinspect function with block info columns	Peter Geoghegan	02:03
Re: pg_dump versus hash partitioning	Julien Rouhaud	02:07
RE: Allow logical replication to copy tables in binary format	[email protected]	02:26
Re: zstd compression for pg_dump	Tomas Vondra	02:43
Re: Allow logical replication to copy tables in binary format	Amit Kapila	03:05
Re: Assert failure of the cross-check for nullingrels 📎	Richard Guo	03:05
Re: gcc 13 warnings	John Naylor	03:14
Re: A problem about ParamPathInfo for an AppendPath	Richard Guo	03:19
Re: Simplify some codes in pgoutput	Peter Smith	03:49
Re: slapd logs to syslog during tests	Tom Lane	03:52
Re: psql \watch 2nd argument: iteration count 📎	Andrey Borodin	04:15
Re: logical decoding and replication of sequences, take 2	vignesh C	05:34
Re: slapd logs to syslog during tests	Andres Freund	05:43
Re: logical decoding and replication of sequences, take 2	John Naylor	05:53
Re: logical decoding and replication of sequences, take 2	John Naylor	05:54
Re: Add macros for ReorderBufferTXN toptxn	Amit Kapila	06:07
Re: In-placre persistance change of a relation 📎	Kyotaro Horiguchi	06:16
RE: Data is copied twice when specifying both child and parent table in publication 📎	[email protected]	06:28
Re: slapd logs to syslog during tests	Andres Freund	06:58
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	07:02
Re: Add pg_walinspect function with block info columns 📎	Bharath Rupireddy	07:20
Re: Dropped and generated columns might cause wrong data on subs when REPLICA IDENTITY FULL 📎	Önder Kalacı	07:38
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	07:49
Re: gcc 13 warnings	Peter Eisentraut	08:06
Re: Memory leak from ExecutorState context?	Jehan-Guillaume de Rorthais	08:18
RE: Dropped and generated columns might cause wrong data on subs when REPLICA IDENTITY FULL	[email protected]	08:45
Re: [EXTERNAL] Support load balancing in libpq 📎	Jelte Fennema	08:50
Re: logical decoding and replication of sequences, take 2	vignesh C	08:51
Re: suppressing useless wakeups in logical/worker.c	Amit Kapila	09:16
Re: postgres_fdw: Useless if-test in GetConnection()	Etsuro Fujita	09:28
Re: improving user.c error messages	Peter Eisentraut	09:40
Re: [PATCH] Add CANONICAL option to xmlserialize 📎	Jim Jones	09:46
Re: Making background psql nicer to use in tap tests 📎	Daniel Gustafsson	09:48
Re: Data is copied twice when specifying both child and parent table in publication	Amit Kapila	12:07
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	torikoshia	12:23
Re: Allow logical replication to copy tables in binary format 📎	Melih Mutlu	12:24
Re: [PATCH] Add CANONICAL option to xmlserialize 📎	Jim Jones	12:30
Re: HOT chain validation in verify_heapam() 📎	Aleksander Alekseev	12:31
RE: Time delayed LR (WAS Re: logical replication restrictions) 📎	Hayato Kuroda (Fujitsu)	13:11
Re: Commitfest 2023-03 starting tomorrow!	Greg Stark	13:43
Re: Making background psql nicer to use in tap tests	Andrew Dunstan	13:48
Re: Avoid use deprecated Windows Memory API	Aleksander Alekseev	13:57
Re: Making background psql nicer to use in tap tests	Daniel Gustafsson	14:08
Re: gcc 13 warnings	Tom Lane	14:26
Re: Commitfest 2023-03 starting tomorrow!	Aleksander Alekseev	14:29
Re: Commitfest 2023-03 starting tomorrow!	Tom Lane	14:38
RE: Support logical replication of DDLs	Takamichi Osumi (Fujitsu)	14:49
Re: Commitfest 2023-03 starting tomorrow!	Justin Pryzby	14:56
Re: Commitfest 2023-03 starting tomorrow!	Greg Stark	15:08
Re: Avoid use deprecated Windows Memory API 📎	Ranier Vilela	15:19
Re: Dropped and generated columns might cause wrong data on subs when REPLICA IDENTITY FULL 📎	Önder Kalacı	15:28
Re: Support logical replication of DDLs 📎	Zheng Li	15:40
Re: Add LZ4 compression in pg_dump 📎	gkokolatos	15:43
Re: Exclusion constraints on partitioned tables 📎	Paul Jungwirth	16:03
Re: Making background psql nicer to use in tap tests	Andrew Dunstan	16:25
Re: Memory leak from ExecutorState context?	Tomas Vondra	16:41
Re: Add LZ4 compression in pg_dump	Tomas Vondra	16:56
Re: pg_dump versus hash partitioning	Tom Lane	17:44
Re: logical decoding and replication of sequences, take 2	Tomas Vondra	17:55
Re: ICU locale validation / canonicalization 📎	Jeff Davis	17:55
Re: Making background psql nicer to use in tap tests	Dagfinn Ilmari Mannsåker	18:07
Re: ICU 54 and earlier are too dangerous	Jeff Davis	18:10
Re: improving user.c error messages	Nathan Bossart	18:10
Re: Add pg_walinspect function with block info columns	Peter Geoghegan	19:36
meson issue? ninja clean doesn't drop queryjumblefuncs.funcs.c	Pavel Stehule	20:11
Re: Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE	Dmitry Dolgov	20:14
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	20:50
Re: Add SHELL_EXIT_CODE to psql 📎	Corey Huinker	21:05
Re: logical decoding and replication of sequences, take 2	Tomas Vondra	21:43
Re: Add macros for ReorderBufferTXN toptxn	Peter Smith	21:47
Re: File descriptors in exec'd subprocesses	Thomas Munro	21:53
Re: Making background psql nicer to use in tap tests	Andrew Dunstan	22:12
Re: Add n_tup_newpage_upd to pg_stat table views	Peter Geoghegan	22:22
Re: Making background psql nicer to use in tap tests	Andres Freund	22:58
Should we remove vacuum_defer_cleanup_age?	Andres Freund	23:09
Re: Add pg_walinspect function with block info columns	Michael Paquier	23:11
Re: Remove last traces of SCM credential auth from libpq?	Michael Paquier	23:13
Re: Should we remove vacuum_defer_cleanup_age?	Magnus Hagander	23:17
Re: Data is copied twice when specifying both child and parent table in publication	Jacob Champion	23:36
Re: Add pg_walinspect function with block info columns	Peter Geoghegan	23:36
Re: gcc 13 warnings	Andres Freund	23:54

March 18, 2023

Thread	Author	Time
Re: Add pg_walinspect function with block info columns	Michael Paquier	00:51
Re: meson issue? ninja clean doesn't drop queryjumblefuncs.funcs.c	Michael Paquier	00:58
Re: pg_dump versus hash partitioning	Julien Rouhaud	01:06
Re: Add pg_walinspect function with block info columns	Peter Geoghegan	01:09
Re: Add pg_walinspect function with block info columns	Michael Paquier	01:18
Re: Amcheck verification of GiST and GIN	Andrey Borodin	03:40
BF mamba failure	Amit Kapila	04:11
Re: BF mamba failure	Tom Lane	04:26
Re: Add pg_walinspect function with block info columns 📎	Bharath Rupireddy	04:38
Re: Data is copied twice when specifying both child and parent table in publication	Amit Kapila	04:44
Fix misplaced shared_preload_libraries_in_progress check in few extensions 📎	Bharath Rupireddy	04:56
Re: meson issue? ninja clean doesn't drop queryjumblefuncs.funcs.c	Pavel Stehule	05:22
Re: logical decoding and replication of sequences, take 2	Amit Kapila	05:35
[PATCH] Use RelationClose rather than table_close in heap_create_with_catalog 📎	Xiaoran Wang	07:04
Re: Allow logical replication to copy tables in binary format 📎	vignesh C	09:03
Re: Should we remove vacuum_defer_cleanup_age?	Alvaro Herrera	09:33
Re: Allow logical replication to copy tables in binary format	Peter Smith	09:41
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Amit Kapila	09:49
Re: Allow logical replication to copy tables in binary format	Amit Kapila	10:11
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound	John Naylor	10:33
Re: Initial Schema Sync for Logical Replication	Alvaro Herrera	12:06
Re: BF mamba failure 📎	Alexander Lakhin	15:00
Re: logical decoding and replication of sequences, take 2	Tomas Vondra	15:19
Re: proposal: psql: psql variable BACKEND_PID	Andrew Dunstan	15:24
Re: proposal: psql: psql variable BACKEND_PID	Pavel Stehule	16:57
Re: generate_series for timestamptz and time zone problem	Tom Lane	18:18
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode	Justin Pryzby	18:30
Re: Infinite Interval 📎	Joseph Koshakow	18:48
Re: Infinite Interval	Tom Lane	19:08
Re: Infinite Interval 📎	Joseph Koshakow	19:33
Re: proposal: possibility to read dumped table's name from file 📎	Pavel Stehule	19:48
Re: Infinite Interval	Tom Lane	19:55
Re: Commitfest 2023-03 starting tomorrow!	Alvaro Herrera	20:26
Re: Commitfest 2023-03 starting tomorrow!	Peter Geoghegan	21:43
Re: buildfarm + meson	Andrew Dunstan	21:53
Re: Making background psql nicer to use in tap tests	Andrew Dunstan	22:07
Bytea PL/Perl transform 📎	Иван Панченко	22:25
Re: Should vacuum process config file reload more often 📎	Melanie Plageman	22:47
Re: buildfarm + meson	Andres Freund	23:00
Re: Commitfest 2023-03 starting tomorrow!	Justin Pryzby	23:19
Re: Commitfest 2023-03 starting tomorrow!	Peter Geoghegan	23:28
Re: Commitfest 2023-03 starting tomorrow!	Justin Pryzby	23:44

March 19, 2023

Thread	Author	Time
Re: buildfarm + meson	Andrew Dunstan	01:32
Re: MERGE ... WHEN NOT MATCHED BY SOURCE 📎	Dean Rasheed	09:10
Re: Supporting MERGE on updatable views 📎	Dean Rasheed	09:11
Re: heapgettup refactoring	David Rowley	09:38
Replace known_assigned_xids_lck by memory barrier 📎	Michail Nikolaev	09:43
Re: Fix fseek() detection of unseekable files on WIN32	Michael Paquier	11:20
server log inflates due to pg_logical_slot_peek_changes/pg_logical_slot_get_changes calls	Jeevan Ladhe	11:29
Re: Fix fseek() detection of unseekable files on WIN32 📎	Michael Paquier	11:45
Re: Extending outfuncs support to utility statements	Alexander Lakhin	12:00
Re: pg_stat_statements and "IN" conditions 📎	Dmitry Dolgov	12:27
Re: proposal: possibility to read dumped table's name from file 📎	Justin Pryzby	14:01
Re: Commitfest 2023-03 starting tomorrow!	Peter Eisentraut	16:05
Re: buildfarm + meson	Andrew Dunstan	16:48
Re: Should vacuum process config file reload more often 📎	Melanie Plageman	16:48
Re: Extending outfuncs support to utility statements	Tom Lane	18:22
Re: Fix fseek() detection of unseekable files on WIN32	Juan José Santamaría Flecha	19:10
Re: Memory leak from ExecutorState context?	Justin Pryzby	19:31
Re: proposal: possibility to read dumped table's name from file	Pavel Stehule	20:27
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	stephane tachoires	20:45
Re: Infinite Interval	Joseph Koshakow	20:46
Re: Commitfest 2023-03 starting tomorrow!	Tom Lane	20:56
Re: Infinite Interval	Tom Lane	21:13
Re: Infinite Interval 📎	Joseph Koshakow	21:46
Re: Fix fseek() detection of unseekable files on WIN32	Michael Paquier	22:06
Re: Allow logical replication to copy tables in binary format	Peter Smith	22:07
Re: Commitfest 2023-03 starting tomorrow!	Thomas Munro	22:13
Remove AUTH_REQ_KRB4 and AUTH_REQ_KRB5 in libpq code 📎	Michael Paquier	22:20
Re: Avoid use deprecated Windows Memory API	Michael Paquier	22:41
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode 📎	Melanie Plageman	22:50
Re: Remove AUTH_REQ_KRB4 and AUTH_REQ_KRB5 in libpq code	Tom Lane	22:53
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode	Melanie Plageman	22:59
Re: Amcheck verification of GiST and GIN 📎	Andrey Borodin	23:00
Re: Reconcile stats in find_tabstat_entry() and get rid of PgStat_BackendFunctionEntry	Michael Paquier	23:43
Re: Remove AUTH_REQ_KRB4 and AUTH_REQ_KRB5 in libpq code	Michael Paquier	23:48

March 20, 2023

Thread	Author	Time
Re: Commitfest 2023-03 starting tomorrow!	Thomas Munro	00:05
Re: Commitfest 2023-03 starting tomorrow!	Tom Lane	00:10
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables	Michael Paquier	00:30
Re: Commitfest 2023-03 starting tomorrow!	Thomas Munro	00:53
RE: Data is copied twice when specifying both child and parent table in publication 📎	[email protected]	00:53
Lock conflict	席冲 (宜穆)	01:58
Re: Lock conflict	David Rowley	02:12
Re: Allow logical replication to copy tables in binary format	Amit Kapila	02:13
Re: meson documentation build open issues 📎	Andres Freund	02:33
Re: Add pg_walinspect function with block info columns	Kyotaro Horiguchi	03:20
Re: logical decoding and replication of sequences, take 2	Amit Kapila	03:42
RE: Allow logical replication to copy tables in binary format	Hayato Kuroda (Fujitsu)	04:13
Re: Initial Schema Sync for Logical Replication	Amit Kapila	04:21
Re: Improve logging when using Huge Pages	Michael Paquier	04:54
Re: Improve logging when using Huge Pages	Michael Paquier	05:03
Re: Improve logging when using Huge Pages	Tom Lane	05:09
Re: Improve logging when using Huge Pages	Michael Paquier	05:17
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	05:24
Re: BF mamba failure	Peter Smith	06:10
Re: Privileges on PUBLICATION	Peter Eisentraut	06:17
Re: An oversight in ExecInitAgg for grouping sets	Richard Guo	06:18
Re: RADIUS tests and improvements	Michael Paquier	06:18
Re: Add macros for ReorderBufferTXN toptxn	Peter Smith	06:26
Missing rules for queryjumblefuncs.{funcs,switch}.c for maintainer-clean 📎	Michael Paquier	06:43
Re: proposal: possibility to read dumped table's name from file 📎	Pavel Stehule	07:01
Re: Missing rules for queryjumblefuncs.{funcs,switch}.c for maintainer-clean	Richard Guo	07:18

Browse Archives

Prev | Next