pgsql-hackers since 2023-08-21 10:56

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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Aug. 21, 2023

Thread Author Time
Re: Wrong rows estimations with joins of CTEs slows queries by more than factor 500 Tomas Vondra 10:56
Re: Extract numeric filed in JSONB more effectively Andy Fan 10:58
Re: postgres_fdw: wrong results with self join + enable_nestloop off Etsuro Fujita 11:16
Re: postgres_fdw: wrong results with self join + enable_nestloop off Etsuro Fujita 11:27
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎 torikoshia 12:04
Re: Oversight in reparameterize_path_by_child leading to executor crash Ashutosh Bapat 12:23
Reproducibility (Re: Remove distprep) Christoph Berg 12:23
Re: Support run-time partition pruning for hash join Andy Fan 12:34
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 13:02
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 13:04
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 13:04
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 13:05
Re: persist logical slots to disk during shutdown checkpoint Ashutosh Bapat 13:06
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Robert Haas 13:27
Re: BUG #18059: Unexpected error 25001 in stored procedure Robert Haas 13:32
Re: postgres_fdw: wrong results with self join + enable_nestloop off Önder Kalacı 13:34
Re: meson: pgxs Makefile.global differences Andrew Dunstan 15:33
Re: meson: pgxs Makefile.global differences Peter Eisentraut 15:43
Re: meson: pgxs Makefile.global differences Tristan Partin 15:48
Re: Make all Perl warnings fatal Andrew Dunstan 15:51
Re: [17] Special search_path names "!pg_temp" and "!pg_catalog" Jeff Davis 16:08
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Jacob Champion 17:49
Re: cataloguing NOT NULL constraints 📎 Alvaro Herrera 18:01
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } Robert Haas 19:14
Re: [PATCH] Add function to_oct 📎 Nathan Bossart 19:15
C function to return double precision[][] Markur Sens 19:31
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } Jeff Davis 19:44
Re: Optimize Arm64 crc32 implementation in PostgreSQL Nathan Bossart 20:04
Re: C function to return double precision[][] Joe Conway 20:04
Re: should frontend tools use syncfs() ? Robert Haas 20:08
Re: [PATCH] Add function to_oct Dean Rasheed 20:10
Re: SLRUs in the main buffer pool - Page Header definitions Robert Haas 20:23
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎 Tom Lane 20:48
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } Jeff Davis 21:32
Re: PG 16 draft release notes ready 📎 Bruce Momjian 21:58
Re: PG 16 draft release notes ready Bruce Momjian 22:07
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Michael Paquier 23:04
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue 📎 Michael Paquier 23:22
Re: should frontend tools use syncfs() ? Michael Paquier 23:25
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Isaac Morland 23:43
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Jacob Champion 23:44
Re: should frontend tools use syncfs() ? Michael Paquier 23:56
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Michael Paquier 23:58

Aug. 22, 2023

Thread Author Time
Re: [PoC] pg_upgrade: allow to upgrade publisher node Peter Smith 00:31
Re: should frontend tools use syncfs() ? Nathan Bossart 01:44
Re: [PoC] pg_upgrade: allow to upgrade publisher node Peter Smith 01:49
Re: should frontend tools use syncfs() ? Michael Paquier 01:50
Re: should frontend tools use syncfs() ? 📎 Nathan Bossart 02:06
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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31