pgsql-hackers since 2022-07-16 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
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

July 16, 2022

Thread Author Time
Re: PG15 beta1 sort performance regression due to Generation context change Jonathan S. Katz 00:01
Re: Use -fvisibility=hidden for shared libraries Andres Freund 00:13
Re: Commitfest Update Jacob Champion 00:23
Re: PG15 beta1 sort performance regression due to Generation context change Justin Pryzby 00:25
Re: [Commitfest 2022-07] Begins Now Jacob Champion 00:28
Re: Select Reference Page - Make Join Syntax More Prominent David G. Johnston 00:38
Re: [Commitfest 2022-07] Begins Now Andres Freund 01:07
Re: Commitfest Update Justin Pryzby 02:13
Re: Backup command and functions can cause assertion failure and segmentation fault Michael Paquier 02:36
Re: Commitfest Update Justin Pryzby 02:37
Freeing sortgroupatts in use_physical_tlist 📎 Zhihong Yu 02:49
Re: Commitfest Update Michael Paquier 02:59
Re: Making pg_rewind faster 📎 Justin Kwan 03:16
Re: Freeing sortgroupatts in use_physical_tlist Tom Lane 03:32
Re: Handle infinite recursion in logical replication setup vignesh C 03:34
Re: Freeing sortgroupatts in use_physical_tlist Zhihong Yu 03:52
Re: Handle infinite recursion in logical replication setup Dilip Kumar 04:59
Re: EINTR in ftruncate() Thomas Munro 05:18
Re: Improving scalability of Parallel Bitmap Heap/Index Scan John Naylor 05:43
Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c) Peter Eisentraut 06:58
Re: Moving RwF patches to a new CF Peter Eisentraut 08:31
Re: System catalog documentation chapter Peter Eisentraut 08:53
Re: PSA: Autoconf has risen from the dead 📎 Tom Lane 15:26
Re: remove reset_shared() Tom Lane 16:34
Re: The "char" type versus non-ASCII characters Nikolay Shaplov 16:43
Re: Proposal to introduce a shuffle function to intarray extension Mladen Gogala 16:53
Re: The "char" type versus non-ASCII characters Tom Lane 17:09
Re: Bug: Reading from single byte character column type may cause out of bounds memory reads. Spyridon Dimitrios Agathos 18:38
Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c) Ranier Vilela 19:54
Re: Use -fvisibility=hidden for shared libraries 📎 Andres Freund 20:17
Re: Proposal to introduce a shuffle function to intarray extension Martin Kalcher 20:21
Re: remove reset_shared() Nathan Bossart 20:30
Re: Proposal to introduce a shuffle function to intarray extension Mladen Gogala 21:30
Re: Proposal to introduce a shuffle function to intarray extension Thomas Munro 21:56
Re: postgres_fdw: using TABLESAMPLE to collect remote sample 📎 Tom Lane 21:57
Re: Move Section 9.27.7 (Data Object Management Functions) to System Information Chapter David G. Johnston 23:50

July 17, 2022

Thread Author Time
Re: Proposal to introduce a shuffle function to intarray extension 📎 Martin Kalcher 02:25
Re: Proposal to introduce a shuffle function to intarray extension Tom Lane 03:18
Re: doc: Make selectivity example match wording 📎 David G. Johnston 03:23
Re: Proposal to introduce a shuffle function to intarray extension David G. Johnston 03:32
Re: Proposal to introduce a shuffle function to intarray extension David G. Johnston 03:36
Re: Proposal to introduce a shuffle function to intarray extension Tom Lane 03:37
Re: optimize lookups in snapshot [sub]xip arrays 📎 Nathan Bossart 03:59
Re: Proposal to introduce a shuffle function to intarray extension Thomas Munro 06:00
Re: Allowing REINDEX to have an optional name 📎 Michael Paquier 06:19
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 06:20
Re: Proposal to introduce a shuffle function to intarray extension Martin Kalcher 09:16
Re: Proposal to introduce a shuffle function to intarray extension Martin Kalcher 09:38
Re: Proposal to introduce a shuffle function to intarray extension Martin Kalcher 09:54
Re: Allowing REINDEX to have an optional name Simon Riggs 09:58
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎 Masahiko Sawada 12:58
Re: proposal: possibility to read dumped table's name from file Justin Pryzby 14:01
Re: Commitfest Update Nathan Bossart 15:17
Re: Reducing the chunk header sizes on all memory context types Yura Sokolov 16:10
Re: Proposal to introduce a shuffle function to intarray extension 📎 Martin Kalcher 16:15
Re: [PATCH] Compression dictionaries for JSONB Nikita Malakhov 18:15
Re: Making pg_rewind faster Tom Lane 18:40
Re: Use -fvisibility=hidden for shared libraries Tom Lane 18:54
Re: Costing elided SubqueryScans more nearly correctly 📎 Tom Lane 19:16
Re: Proposal: allow database-specific role memberships 📎 Kenaniah Cerny 19:27
Re: Use -fvisibility=hidden for shared libraries Andres Freund 20:00
Re: Use -fvisibility=hidden for shared libraries Tom Lane 20:06
Re: PATCH: Add Table Access Method option to pgbench Mason Sharp 21:07
Re: postgres_fdw versus regconfig and similar constants Tom Lane 22:25
Re: Proposal to introduce a shuffle function to intarray extension Thomas Munro 22:37
Re: Proposal to introduce a shuffle function to intarray extension Tom Lane 22:46
Re: Proposal to introduce a shuffle function to intarray extension Tom Lane 22:53
Re: Proposal to introduce a shuffle function to intarray extension Martin Kalcher 23:05
Re: doc: Make selectivity example match wording Dian M Fay 23:07
Re: Proposal to introduce a shuffle function to intarray extension 📎 Martin Kalcher 23:07
Re: Proposal to introduce a shuffle function to intarray extension Tom Lane 23:20

July 18, 2022

Thread Author Time
System column support for partitioned tables using heap Morris de Oryx 01:04
pgsql: Default to hidden visibility for extension libraries where possi Andres Freund 01:05
Re: pgsql: Default to hidden visibility for extension libraries where possi Andres Freund 01:39
Re: pgsql: Default to hidden visibility for extension libraries where possi Andres Freund 02:01
Re: pgsql: Default to hidden visibility for extension libraries where possi Tom Lane 02:34
Re: NAMEDATALEN increase because of non-latin languages 📎 John Naylor 02:46
Re: NAMEDATALEN increase because of non-latin languages Andres Freund 02:58
Re: Windows now has fdatasync() 📎 Thomas Munro 03:26
RE: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns [email protected] 03:28
Re: Windows now has fdatasync() Tom Lane 03:43
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns Amit Kapila 04:12
Re: Windows now has fdatasync() Thomas Munro 04:20
Re: Windows now has fdatasync() Tom Lane 04:33
Re: Handle infinite recursion in logical replication setup Amit Kapila 04:52
Re: Costing elided SubqueryScans more nearly correctly Richard Guo 05:48
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher Amit Kapila 06:29
Re: Use -fvisibility=hidden for shared libraries Andres Freund 07:05
Re: Allow file inclusion in pg_hba and pg_ident files Julien Rouhaud 07:11
Re: Proposal to introduce a shuffle function to intarray extension Martin Kalcher 07:12
Re: Problem about postponing gathering partial paths for topmost scan/join rel 📎 Richard Guo 07:13
Re: Proposal to introduce a shuffle function to intarray extension 📎 Martin Kalcher 07:47
Re: [RFC] building postgres with meson - v10 Aleksander Alekseev 08:05
Re: [RFC] building postgres with meson - v10 Aleksander Alekseev 08:12
Re: Proposal to introduce a shuffle function to intarray extension John Naylor 08:18
Re: Fast COPY FROM based on batch insert 📎 Etsuro Fujita 08:22
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher Amit Kapila 08:51
Re: Lazy JIT IR code generation to increase JIT speed with partitions David Geier 09:00
Re: [Commitfest 2022-07] Begins Now Aleksander Alekseev 09:05
Re: PSA: Autoconf has risen from the dead Peter Eisentraut 09:11
Re: Add 64-bit XIDs into PostgreSQL 15 📎 Pavel Borisov 09:23
Re: [RFC] building postgres with meson - v10 Peter Eisentraut 09:33
Re: [Commitfest 2022-07] Begins Now Alvaro Herrera 09:53
Re: PATCH: Add Table Access Method option to pgbench Alexander Korotkov 10:53
Re: Transparent column encryption Peter Eisentraut 10:53
Re: Use "WAL segment" instead of "log segment" consistently in user-facing messages 📎 Bharath Rupireddy 10:54
Re: making relfilenodes 56 bits Dilip Kumar 11:21
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Bharath Rupireddy 11:23
Re: make install-world fails sometimes in Mac M1 Gaddam Sai Ram 11:24
Re: Handle infinite recursion in logical replication setup 📎 vignesh C 11:28
Re: postgres_fdw: using TABLESAMPLE to collect remote sample 📎 Tomas Vondra 11:36
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns Amit Kapila 11:49
Re: [PATCH] Compression dictionaries for JSONB Aleksander Alekseev 12:26
Re: Problem about postponing gathering partial paths for topmost scan/join rel Antonin Houska 12:36
Re: Commitfest Update Alvaro Herrera 13:05
Re: Commitfest Update Justin Pryzby 13:13
Re: MERGE and parsing with prepared statements Justin Pryzby 13:20
limits of max, min optimization Pavel Stehule 13:24
Re: Proposal to introduce a shuffle function to intarray extension Tom Lane 13:48
Re: Use fadvise in wal replay Andrey Borodin 14:04
Re: limits of max, min optimization Alvaro Herrera 14:24
Re: limits of max, min optimization Tom Lane 14:29
Re: limits of max, min optimization Pavel Stehule 14:32
doc: mentioned CREATE+ATTACH PARTITION as an alternative to CREATE TABLE..PARTITION OF Justin Pryzby 14:33
Re: doc: mentioned CREATE+ATTACH PARTITION as an alternative to CREATE TABLE..PARTITION OF Andrew Dunstan 14:39
Re: [RFC] building postgres with meson - v10 Andres Freund 15:44
Re: Transparent column encryption Robert Haas 16:06
Convert planner's AggInfo and AggTransInfo to Nodes 📎 Tom Lane 16:08
Re: Handle infinite recursion in logical replication setup 📎 vignesh C 16:16
Re: Costing elided SubqueryScans more nearly correctly 📎 Alvaro Herrera 16:36
Re: Making pg_rewind faster Justin Kwan 17:14
Re: Costing elided SubqueryScans more nearly correctly Tom Lane 17:30
Re: Convert planner's AggInfo and AggTransInfo to Nodes Dagfinn Ilmari Mannsåker 17:42
Re: [Commitfest 2022-07] Begins Now Jacob Champion 17:44
Re: support for CREATE MODULE Nathan Bossart 18:06
Re: Commitfest Update Justin Pryzby 18:06
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Nathan Bossart 18:18
Re: Use "WAL segment" instead of "log segment" consistently in user-facing messages Nathan Bossart 18:30
Re: postgres_fdw: using TABLESAMPLE to collect remote sample 📎 Tom Lane 18:45
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 18:48
Re: pg15b2: large objects lost on upgrade 📎 Robert Haas 18:57
Re: Commitfest Update Jacob Champion 19:00
Re: Commitfest Update Jacob Champion 19:02
[PATCH] Introduce array_shuffle() and array_sample() 📎 Martin Kalcher 19:03
Re: Commitfest Update Jacob Champion 19:04
Re: Commitfest Update Jacob Champion 19:06
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size 📎 Andrew Dunstan 19:09
Re: fix crash with Python 3.11 Peter Eisentraut 19:09
Re: [Commitfest 2022-07] Begins Now Jacob Champion 19:22
Re: replacing role-level NOINHERIT with a grant-level option 📎 Robert Haas 19:26
Re: [PATCH] Introduce array_shuffle() and array_sample() Tom Lane 19:29
Re: [Commitfest 2022-07] Begins Now Andres Freund 19:32
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands David G. Johnston 19:55
Re: Use fadvise in wal replay Robert Haas 19:55
pgsql: Move snowball_create.sql creation into perl file Andres Freund 19:56
Re: Doc about how to set max_wal_senders when setting minimal wal_level 📎 Bruce Momjian 19:58
Re: Commitfest Update Nathan Bossart 19:59
Re: pg15b2: large objects lost on upgrade Andres Freund 20:06
Re: pg15b2: large objects lost on upgrade Bruce Momjian 20:09
Re: System column support for partitioned tables using heap Robert Haas 20:12
Re: [PATCH] Introduce array_shuffle() and array_sample() Martin Kalcher 20:15
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands Tom Lane 20:20
Re: [RFC] building postgres with meson - v10 Andres Freund 20:23
Re: [PATCH] Introduce array_shuffle() and array_sample() Robert Haas 20:27
Re: pg15b2: large objects lost on upgrade Robert Haas 20:28
Re: [PATCH] Introduce array_shuffle() and array_sample() Tom Lane 20:34
Re: [Commitfest 2022-07] Begins Now Jacob Champion 20:34
Re: doc: Clarify Routines and Extension Membership 📎 Bruce Momjian 20:40
Re: [Commitfest 2022-07] Begins Now Andres Freund 20:44
Re: [PATCH] Introduce array_shuffle() and array_sample() Tom Lane 21:03
Re: [PATCH] Introduce array_shuffle() and array_sample() Martin Kalcher 21:48
Re: pg_parameter_aclcheck() and trusted extensions 📎 Nathan Bossart 21:56
Re: Use -fvisibility=hidden for shared libraries 📎 Andres Freund 22:09
Re: allow specifying action when standby encounters incompatible parameter settings Nathan Bossart 22:17
Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands David G. Johnston 22:17
Re: [PATCH] Introduce array_shuffle() and array_sample() Tom Lane 22:18
Re: [PATCH] Introduce array_shuffle() and array_sample() David G. Johnston 22:32
Re: Commitfest Update Justin Pryzby 22:32
Re: [PATCH] Introduce array_shuffle() and array_sample() Tom Lane 22:43
Re: [PATCH] Introduce array_shuffle() and array_sample() Martin Kalcher 22:52
Re: Commitfest Update Jacob Champion 22:53
Re: Windows default locale vs initdb 📎 Thomas Munro 22:58
Re: Add WAL recovery messages with log_wal_traffic GUC (was: add recovery, backup, archive, streaming etc. activity messages to server logs along with ps display) Nathan Bossart 23:01
Re: pgsql: Default to hidden visibility for extension libraries where possi Justin Pryzby 23:36

July 19, 2022

Thread Author Time
Re: Allow placeholders in ALTER ROLE w/o superuser Nathan Bossart 00:03
Re: System catalog documentation chapter Bruce Momjian 00:33
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns Masahiko Sawada 01:03
Re: Costing elided SubqueryScans more nearly correctly Richard Guo 01:03
Re: [PATCH] Introduce array_shuffle() and array_sample() Thomas Munro 01:09
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns Masahiko Sawada 01:13
Re: System catalog documentation chapter Tom Lane 01:22
Re: First draft of the PG 15 release notes Justin Pryzby 01:23
Re: Doc about how to set max_wal_senders when setting minimal wal_level Japin Li 01:27
Re: NAMEDATALEN increase because of non-latin languages John Naylor 01:30
Re: PATCH: Add Table Access Method option to pgbench Michael Paquier 01:47
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 02:10
Re: [PoC] Improve dead tuple storage for lazy vacuum Andres Freund 02:24
Re: Allowing REINDEX to have an optional name Justin Pryzby 02:26
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 02:28
Re: Doc about how to set max_wal_senders when setting minimal wal_level David G. Johnston 02:39

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