pgsql-hackers since 2023-08-22 02:35

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

Aug. 22, 2023

Thread	Author	Time
Re: Wrong rows estimations with joins of CTEs slows queries by more than factor 500	Jian Guo	02:35
Re: Oversight in reparameterize_path_by_child leading to executor crash	Richard Guo	03:12
Re: Extract numeric filed in JSONB more effectively 📎	Andy Fan	03:14
Re: [PATCH] Add function to_oct	John Naylor	03:17
Re: should frontend tools use syncfs() ?	Michael Paquier	03:53
Re: Make all Perl warnings fatal	Michael Paquier	04:05
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	04:18
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	04:45
Re: pg_rewind WAL segments deletion pitfall	Michael Paquier	05:32
Re: PG 16 draft release notes ready	David Rowley	05:36
Re: DecodeInterval fixes	Michael Paquier	05:39
Re: Testing autovacuum wraparound (including failsafe)	Michael Paquier	05:49
Re: Extract numeric filed in JSONB more effectively	Andy Fan	05:54
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	06:01
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	06:01
Re: Support run-time partition pruning for hash join	David Rowley	06:38
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	06:48
Re: PG 16 draft release notes ready	Pavel Luzanov	07:02
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	ajitpostgres awekar	07:14
Re: Report planning memory in EXPLAIN ANALYZE	jian he	07:46
Convert encrypted SSL test keys to PKCS#8 format 📎	Peter Eisentraut	08:07
Re: Adding a LogicalRepWorker type field	Amit Kapila	08:24
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	08:52
Re: persist logical slots to disk during shutdown checkpoint	Ashutosh Bapat	09:26
list of acknowledgments for PG16	Peter Eisentraut	09:33
Re: Support run-time partition pruning for hash join	Richard Guo	09:43
Re: add timing information to pg_upgrade	Peter Eisentraut	09:49
Re: Support run-time partition pruning for hash join	Richard Guo	09:51
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	10:12
Re: list of acknowledgments for PG16	Alvaro Herrera	10:41
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Vik Fearing	11:01
Re: list of acknowledgments for PG16	Vik Fearing	12:01
Re: Direct I/O 📎	Peter Eisentraut	12:15
Re: Extract numeric filed in JSONB more effectively	Chapman Flack	12:16
Fix the error message when failing to restore the snapshot 📎	Zhijie Hou (Fujitsu)	12:39
Re: list of acknowledgments for PG16	Alvaro Herrera	13:05
Re: Fix the error message when failing to restore the snapshot	Amit Kapila	13:07
Re: Make all Perl warnings fatal	Andrew Dunstan	13:11
Re: Make all Perl warnings fatal	Alvaro Herrera	13:20
Re: list of acknowledgments for PG16	Tom Lane	13:29
Re: list of acknowledgments for PG16	Vik Fearing	13:40
Make error messages about WAL segment size more consistent 📎	Peter Eisentraut	13:44
Re: list of acknowledgments for PG16	Tom Lane	13:44
Re: list of acknowledgments for PG16	Vik Fearing	13:48
Re: Make --help output fit within 80 columns per line	torikoshia	13:57
Re: list of acknowledgments for PG16	Joe Conway	14:03
Re: add timing information to pg_upgrade	Nathan Bossart	14:06
Re: [PATCH] Add function to_oct	Peter Eisentraut	14:20
Re: list of acknowledgments for PG16	Peter Eisentraut	14:24
Re: Make error messages about WAL segment size more consistent	Aleksander Alekseev	14:26
Re: [PATCH] Add function to_oct	Nathan Bossart	14:26
Re: Oversight in reparameterize_path_by_child leading to executor crash	Tom Lane	14:39
Re: persist logical slots to disk during shutdown checkpoint	Ashutosh Bapat	14:53
Re: [PATCH] Add function to_oct	Peter Eisentraut	14:57
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎	Tom Lane	15:43
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎	Ashutosh Bapat	16:07
Re: DecodeInterval fixes	Jacob Champion	16:58
Re: should frontend tools use syncfs() ? 📎	Nathan Bossart	17:11
Re: pgsql: Allow tailoring of ICU locales with custom rules	Jeff Davis	17:25
Re: Make all Perl warnings fatal	Andrew Dunstan	18:46
Re: Convert encrypted SSL test keys to PKCS#8 format	Jacob Champion	19:02
Re: PG 16 draft release notes ready 📎	Bruce Momjian	19:14
Re: list of acknowledgments for PG16	Bruce Momjian	19:26
subscription/015_stream sometimes breaks	Thomas Munro	20:21
Re: PG 16 draft release notes ready	Jeff Davis	20:42
Re: Direct I/O	Peter Geoghegan	20:48
Re: subscription/015_stream sometimes breaks	Thomas Munro	20:54
Re: Prevent psql \watch from running queries that return no rows 📎	Greg Sabino Mullane	21:23
Re: BUG #18059: Unexpected error 25001 in stored procedure	Tom Lane	21:29
Re: [17] collation provider "builtin" 📎	Jeff Davis	21:32
Re: Faster "SET search_path"	Jeff Davis	21:45
Re: initdb caching during tests	Daniel Gustafsson	21:47
Re: Prevent psql \watch from running queries that return no rows	Daniel Gustafsson	21:49
Re: Adding a LogicalRepWorker type field	Peter Smith	23:10

Aug. 23, 2023

Thread	Author	Time
Re: Make --help output fit within 80 columns per line	Masahiro Ikeda	00:45
False "pg_serial": apparent wraparound” in logs 📎	Imseih (AWS), Sami	00:55
Re: initdb caching during tests	Andres Freund	01:17
Re: Support run-time partition pruning for hash join	Andy Fan	01:19
pg_upgrade - a function parameter shadows global 'new_cluster' 📎	Peter Smith	01:28
Re: Support run-time partition pruning for hash join	Andy Fan	01:41
Re: PG 16 draft release notes ready	Bruce Momjian	02:23
Re: Using defines for protocol characters	Nathan Bossart	02:24
RE: subscription/015_stream sometimes breaks	Zhijie Hou (Fujitsu)	02:27
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	02:43
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	02:44
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	02:45
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	02:58
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	02:59
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	03:00
Re: subscription/015_stream sometimes breaks	vignesh C	03:16
Re: Doc limitation update proposal: include out-of-line OID usage per TOAST-ed columns	John Naylor	04:02
Re: Extending SMgrRelation lifetimes 📎	Thomas Munro	04:54
Re: Direct I/O	Thomas Munro	04:57
RE: persist logical slots to disk during shutdown checkpoint 📎	Hayato Kuroda (Fujitsu)	05:10
Re: persist logical slots to disk during shutdown checkpoint 📎	vignesh C	05:30
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎	Richard Guo	05:37
Re: Synchronizing slots from primary to standby	shveta malik	05:38
RE: subscription/015_stream sometimes breaks 📎	Zhijie Hou (Fujitsu)	05:56
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc? 📎	Andres Freund	06:58
Re: list of acknowledgments for PG16 📎	Denis Laxalde	07:13
Re: pg_upgrade - a function parameter shadows global 'new_cluster'	Daniel Gustafsson	08:00
Re: subscription/015_stream sometimes breaks 📎	Alvaro Herrera	08:00
Re: initdb caching during tests	Daniel Gustafsson	08:10
Re: MERGE ... RETURNING 📎	Dean Rasheed	08:20
Re: [dsm] comment typo	Daniel Gustafsson	08:28
Re: subscription/015_stream sometimes breaks	Alvaro Herrera	08:44
RE: persist logical slots to disk during shutdown checkpoint 📎	Hayato Kuroda (Fujitsu)	08:51
Re: persist logical slots to disk during shutdown checkpoint	vignesh C	08:57
Re: pg_rewind WAL segments deletion pitfall	torikoshia	09:04
Re: EBCDIC sorting as a use case for ICU rules	Peter Eisentraut	09:30
Re: Synchronizing slots from primary to standby 📎	shveta malik	10:07
Re: PostgreSQL 16 release announcement draft	jian he	10:20
Re: Remove distprep 📎	Peter Eisentraut	10:46
Re: Synchronizing slots from primary to standby	Dilip Kumar	10:51
Re: MERGE ... RETURNING 📎	Dean Rasheed	10:58
Re: list of acknowledgments for PG16	Etsuro Fujita	11:35
Re: pg_rewind WAL segments deletion pitfall 📎	Alexander Kukushkin	11:44
Re: PostgreSQL 16 release announcement draft	David Rowley	12:02
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Daniel Gustafsson	12:48
meson uses stale pg_config_paths.h left over from make 📎	David Rowley	12:52
Re: Fix error handling in be_tls_open_server() 📎	Daniel Gustafsson	13:23
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	14:02
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	14:04
Re: Unlogged relations and WAL-logging	Heikki Linnakangas	14:40
using SysCacheGetAttrNotNull in place of heap_getattr	Alvaro Herrera	14:43
Re: [PATCH] Add function to_oct	Nathan Bossart	14:54
Re: pgbench: allow to exit immediately when any client is aborted 📎	Yugo NAGATA	15:16
Re: Oversight in reparameterize_path_by_child leading to executor crash	Ashutosh Bapat	16:15
Re: add timing information to pg_upgrade 📎	Nathan Bossart	16:35
Re: PG 16 draft release notes ready	Jeff Davis	16:36
Re: using SysCacheGetAttrNotNull in place of heap_getattr	Tom Lane	17:04
Re: cataloguing NOT NULL constraints 📎	Alvaro Herrera	17:08
Re: Oversight in reparameterize_path_by_child leading to executor crash	Tom Lane	17:44
Re: PostgreSQL 16 release announcement draft 📎	Jonathan S. Katz	17:55
Re: Make all Perl warnings fatal	Peter Eisentraut	19:05
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Andres Freund	19:22
Make documentation builds reproducible 📎	Peter Eisentraut	19:24
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Daniel Gustafsson	20:11
Re: Let's make PostgreSQL multi-threaded	Mark Woodward	20:42
Re: False "pg_serial": apparent wraparound” in logs	Imseih (AWS), Sami	20:49
Re: BUG #18059: Unexpected error 25001 in stored procedure 📎	Tom Lane	20:53
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Nazir Bilal Yavuz	20:55
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Tom Lane	21:02
Re: PostgreSQL 16 release announcement draft	David Rowley	21:07
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Daniel Gustafsson	21:12
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Andres Freund	21:43
Re: Fix error handling in be_tls_open_server()	Jacob Champion	21:47
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Andres Freund	21:48
Re: Fix error handling in be_tls_open_server()	Daniel Gustafsson	21:54
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Tom Lane	21:55
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Andres Freund	22:06
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Tom Lane	22:32
Re: meson uses stale pg_config_paths.h left over from make	David Rowley	22:35
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Andres Freund	22:56
Re: pg_upgrade - a function parameter shadows global 'new_cluster'	Peter Smith	23:07

Aug. 24, 2023

Thread	Author	Time
Re: pgbench: allow to exit immediately when any client is aborted	Tatsuo Ishii	00:15
Re: pg_rewind WAL segments deletion pitfall	Kyotaro Horiguchi	00:45
pg_stat_get_backend_subxact() and backend IDs? 📎	Ian Lawrence Barwick	01:22
Re: In-placre persistance change of a relation	Kyotaro Horiguchi	02:22
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	02:24
Re: pgbench: allow to exit immediately when any client is aborted 📎	Yugo NAGATA	02:24
Re: pg_stat_get_backend_subxact() and backend IDs?	Nathan Bossart	02:32
Re: Oversight in reparameterize_path_by_child leading to executor crash	Richard Guo	02:47
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	02:51
Re: pg_stat_get_backend_subxact() and backend IDs?	Nathan Bossart	02:51
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	03:24
Re: subscription/015_stream sometimes breaks	Amit Kapila	03:45
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Vaibhav Dalvi	04:06
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc?	Peter Eisentraut	06:10
Re: persist logical slots to disk during shutdown checkpoint 📎	vignesh C	06:13
logical_replication_mode	Peter Eisentraut	06:14
Re: meson uses stale pg_config_paths.h left over from make	Peter Eisentraut	06:18
Re: meson uses stale pg_config_paths.h left over from make	Andres Freund	06:25
Remove IndexInfo.ii_OpclassOptions field 📎	Peter Eisentraut	06:57
Re: subscription/015_stream sometimes breaks	Alvaro Herrera	07:50
Re: Fix error handling in be_tls_open_server()	Sergey Shinderuk	08:11
Re: Should the archiver process always make sure that the timeline history files exist in the archive?	Kyotaro Horiguchi	08:15
Re: Fix error handling in be_tls_open_server()	Daniel Gustafsson	08:38
Re: Fix error handling in be_tls_open_server()	Sergey Shinderuk	09:13
Re: Support run-time partition pruning for hash join	Richard Guo	09:27
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	09:50
Re: Adding argument names to aggregate functions	Daniel Gustafsson	10:05
Re: subscription/015_stream sometimes breaks	Amit Kapila	10:18
Re: Report planning memory in EXPLAIN ANALYZE 📎	Ashutosh Bapat	10:31
Improving the heapgetpage function improves performance in common scenarios 📎	Quan Zongliang	10:55
Use FD_CLOEXEC on ListenSockets (was Re: Refactoring backend fork+exec code) 📎	Heikki Linnakangas	11:41
Re: Adding argument names to aggregate functions	Dagfinn Ilmari Mannsåker	12:38
Re: Use FD_CLOEXEC on ListenSockets (was Re: Refactoring backend fork+exec code)	Thomas Munro	12:48
Re: Infinite Interval 📎	Ashutosh Bapat	13:50
Re: generate syscache info automatically	Peter Eisentraut	14:03
Re: Use FD_CLOEXEC on ListenSockets (was Re: Refactoring backend fork+exec code)	Heikki Linnakangas	14:05
Vectorization of some functions and improving pg_list interface 📎	Maxim Orlov	14:07
Re: Vectorization of some functions and improving pg_list interface	Chapman Flack	14:19
Re: EBCDIC sorting as a use case for ICU rules 📎	Jehan-Guillaume de Rorthais	14:26
Re: PostgreSQL 16 release announcement draft 📎	Jonathan S. Katz	14:32
Checks in RegisterBackgroundWorker.() 📎	Heikki Linnakangas	15:15
Re: PostgreSQL 16 release announcement draft	jian he	15:16
Re: PostgreSQL 16 release announcement draft	Erik Rijkers	15:17
Re: PostgreSQL 16 release announcement draft	Alvaro Herrera	15:19
Re: Disabling Heap-Only Tuples	Matthias van de Meent	15:22

Browse Archives

Prev | Next