pgsql-hackers since 2021-08-13 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)

Browse Archives

Prev | Next

Aug. 13, 2021

Thread Author Time
Re: Worth using personality(ADDR_NO_RANDOMIZE) for EXEC_BACKEND on linux? Thomas Munro 00:06
Re: [PATCH] test/ssl: rework the sslfiles Makefile target Jacob Champion 00:08
Re: [PATCH] test/ssl: rework the sslfiles Makefile target Jacob Champion 00:08
Re: Default to TIMESTAMP WITH TIME ZONE? Isaac Morland 00:16
Re: Worth using personality(ADDR_NO_RANDOMIZE) for EXEC_BACKEND on linux? Tom Lane 00:29
Re: Added schema level support for publication. Amit Kapila 02:59
Re: Next Steps with Hash Indexes Amit Kapila 04:01
Re: Skipping logical replication transactions on subscriber side Amit Kapila 04:06
Re: Bug in huge simplehash David Rowley 04:50
Re: Default to TIMESTAMP WITH TIME ZONE? Greg Stark 05:14
Re: Next Steps with Hash Indexes Dilip Kumar 06:09
Re: [bug] Logical Decoding of relation rewrite with toast does not reset toast_hash Drouvot, Bertrand 06:17
Re: Skipping logical replication transactions on subscriber side Greg Nancarrow 06:18
Re: [bug] Logical Decoding of relation rewrite with toast does not reset toast_hash Drouvot, Bertrand 06:19
Re: Logical replication keepalive flood Peter Smith 06:45
Re: Parallel scan with SubTransGetTopmostTransaction assert coredump Greg Nancarrow 06:52
Re: Postgres picks suboptimal index after building of an extended statistics 📎 Andrey V. Lepikhov 07:01
Re: Default to TIMESTAMP WITH TIME ZONE? Gavin Flower 07:33
Re: Shared memory size computation oversight? Peter Eisentraut 08:52
Re: pgsql: pgstat: Bring up pgstat in BaseInit() to fix uninitialized use o Amit Kapila 09:08
Re: pgsql: pgstat: Bring up pgstat in BaseInit() to fix uninitialized use o Amit Kapila 09:09
Re: [bug] Logical Decoding of relation rewrite with toast does not reset toast_hash Amit Kapila 09:17
Re: Bug in huge simplehash Andres Freund 09:21
Re: Autovacuum on partitioned table (autoanalyze) Andres Freund 09:35
Re: Bug in huge simplehash Yura Sokolov 09:44
[BUG] Failed Assertion in ReorderBufferChangeMemoryUpdate() 📎 Drouvot, Bertrand 09:45
Re: [PATCH] Hooks at XactCommand level Andres Freund 09:58
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) Andres Freund 10:08
Re: Bug in huge simplehash Andres Freund 10:15
RE: Multiple Postgres process are running in background Ram Charan Kallem 10:20
Re: logical replication empty transactions 📎 Ajin Cherian 11:00
Re: Bug in huge simplehash Ranier Vilela 11:12
Re: Bug in huge simplehash Yura Sokolov 11:40
[PATCH] Native spinlock support on RISC-V 📎 Marek Szuba 11:54
Re: Bug in huge simplehash Andres Freund 12:14
Re: Shared memory size computation oversight? Julien Rouhaud 12:32
Re: [PATCH] Hooks at XactCommand level Gilles Darold 12:43
Re: SI messages sent when excuting ROLLBACK PREPARED command Michael Paquier 12:50
Re: EXEC_BACKEND vs bgworkers without BGWORKER_SHMEM_ACCESS Andres Freund 12:53
Re: CI/windows docker vs "am a service" autodetection on windows Andres Freund 13:02
Proposal: More structured logging 📎 Ronan Dunklau 13:23
Re: Default to TIMESTAMP WITH TIME ZONE? David G. Johnston 14:09
Re: pg_settings.pending_restart not set when line removed Alexander Kukushkin 14:30
Re: pg_settings.pending_restart not set when line removed Tom Lane 14:45
Re: [PATCH] Native spinlock support on RISC-V Tom Lane 15:09
Re: [PATCH] Native spinlock support on RISC-V Andres Freund 15:30
Re: Multiple Postgres process are running in background Adrian Klaver 15:34
Re: Default to TIMESTAMP WITH TIME ZONE? Bruce Momjian 15:47
Re: pgsql: pgstat: Bring up pgstat in BaseInit() to fix uninitialized use o Andres Freund 15:59
Re: [PATCH] Native spinlock support on RISC-V Tom Lane 16:03
Re: Multiple Postgres process are running in background Ranier Vilela 16:16
[PATCH] Error out if SKIP LOCKED and WITH TIES are both specified 📎 David Christensen 16:16
Re: Default to TIMESTAMP WITH TIME ZONE? Andrew Dunstan 16:23
Re: Default to TIMESTAMP WITH TIME ZONE? Simon Riggs 16:28
Re: Default to TIMESTAMP WITH TIME ZONE? David G. Johnston 16:53
Re: Default to TIMESTAMP WITH TIME ZONE? Tom Lane 17:07
Re: [PATCH] Native spinlock support on RISC-V Tom Lane 17:25
Re: [PATCH] Native spinlock support on RISC-V Andres Freund 17:29
Re: [PATCH] Native spinlock support on RISC-V Tom Lane 17:37
Re: [PATCH] Native spinlock support on RISC-V Andres Freund 17:55
Re: [PATCH] Native spinlock support on RISC-V Tom Lane 18:09
Re: Default to TIMESTAMP WITH TIME ZONE? David G. Johnston 18:47
Re: Autovacuum on partitioned table (autoanalyze) 📎 Álvaro Herrera 18:50
Re: [UNVERIFIED SENDER] Re: [bug] Logical Decoding of relation rewrite with toast does not reset toast_hash David Zhang 23:33

Aug. 14, 2021

Thread Author Time
Re: Changes to recovery_min_apply_delay are ignored while waiting for delay 📎 Soumyadeep Chakraborty 00:59
Re: Default to TIMESTAMP WITH TIME ZONE? Peter Eisentraut 08:03
Re: Added schema level support for publication. Peter Eisentraut 09:32
Re: Default to TIMESTAMP WITH TIME ZONE? Simon Riggs 10:46
Re: Added schema level support for publication. Amit Kapila 10:52
Re: Added schema level support for publication. 📎 vignesh C 11:45
Re: Added schema level support for publication. vignesh C 11:50
Re: Added schema level support for publication. vignesh C 11:53
Re: Added schema level support for publication. vignesh C 12:04
Re: Added schema level support for publication. vignesh C 12:21
Re: Added schema level support for publication. vignesh C 12:24
Re: Added schema level support for publication. Tom Lane 15:23
Re: when the startup process doesn't (logging startup delays) Justin Pryzby 21:47

Aug. 15, 2021

Thread Author Time
Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)? 📎 Justin Pryzby 00:39
Re: ECPG bug fix: DECALRE STATEMENT and DEALLOCATE, DESCRIBE Tom Lane 03:08
RE: make MaxBackends available in _PG_init [email protected] 08:04
Get table total page quantity and cached page quantity otar shavadze 11:41
Re: CI/windows docker vs "am a service" autodetection on windows 📎 Ranier Vilela 14:25
Re: Keep notnullattrs in RelOptInfo (Was part of UniqueKey patch series) 📎 Andy Fan 14:33
Re: prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619 Justin Pryzby 14:44
PG14: Avoid checking output-buffer-length for every encoded byte during pg_hex_encode 📎 Hans Buschmann 14:58
Re: Keep notnullattrs in RelOptInfo (Was part of UniqueKey patch series) Zhihong Yu 16:41
BUG #17144: Upgrade from v13 to v14 with the cube extension failed PG Bug reporting form 17:23
Re: Skipping logical replication transactions on subscriber side Masahiko Sawada 20:24
Re: Get table total page quantity and cached page quantity David Rowley 20:31
Re: Added schema level support for publication. Masahiko Sawada 20:34
Re: Get table total page quantity and cached page quantity otar shavadze 20:52
Re: Added schema level support for publication. Masahiko Sawada 21:04
Minor regexp hacking: code coverage, moveins() and friends 📎 Tom Lane 21:47

Aug. 16, 2021

Thread Author Time
Re: Default to TIMESTAMP WITH TIME ZONE? David Fetter 00:51
Re: PoC/WIP: Extended statistics on expressions Justin Pryzby 01:31
Re: PoC/WIP: Extended statistics on expressions Justin Pryzby 01:32
Re: Keep notnullattrs in RelOptInfo (Was part of UniqueKey patch series) Andy Fan 02:24
Re: badly calculated width of emoji in psql Michael Paquier 02:44
Re: Skipping logical replication transactions on subscriber side Greg Nancarrow 03:03
Re: Changes to recovery_min_apply_delay are ignored while waiting for delay Michael Paquier 03:16
Failure of subscription tests with topminnow Michael Paquier 03:52
Re: make MaxBackends available in _PG_init 📎 Bossart, Nathan 04:02
Re: Changes to recovery_min_apply_delay are ignored while waiting for delay Soumyadeep Chakraborty 04:21
Re: .ready and .done files considered harmful Bossart, Nathan 04:51
Re: .ready and .done files considered harmful Bossart, Nathan 05:05
Re: Skipping logical replication transactions on subscriber side Amit Kapila 05:21
Re: Added schema level support for publication. Peter Smith 06:00
Re: ECPG bug fix: DECALRE STATEMENT and DEALLOCATE, DESCRIBE 📎 Michael Paquier 06:27
Re: Add option --drop-cascade for pg_dump/restore 📎 Wu Haotian 06:35
Re: logical replication empty transactions Peter Smith 06:43
RE: Skipping logical replication transactions on subscriber side [email protected] 06:59
Re: ECPG bug fix: DECALRE STATEMENT and DEALLOCATE, DESCRIBE Michael Paquier 07:27
RE: Skipping logical replication transactions on subscriber side [email protected] 07:53
Re: Skipping logical replication transactions on subscriber side Greg Nancarrow 08:30
Re: Failure of subscription tests with topminnow Amit Kapila 08:32
Is it worth pushing conditions to sublink/subplan? Wenjing 09:15
Non-decimal integer literals 📎 Peter Eisentraut 09:51
Re: ECPG bug fix: DECALRE STATEMENT and DEALLOCATE, DESCRIBE Michael Meskes 10:06
Re: Window Function "Run Conditions" 📎 David Rowley 10:28
Why timestamptz_pl_interval and timestamptz_mi_interval are not immutable? Alexander Pyhalov 10:29
RE: Why timestamptz_pl_interval and timestamptz_mi_interval are not immutable? Floris Van Nee 11:25
Re: Slightly improve initdb --sync-only option's help message Daniel Gustafsson 11:42
Re: PoC/WIP: Extended statistics on expressions Tomas Vondra 13:19
Some RELKIND macro refactoring 📎 Peter Eisentraut 13:20
Re: Added schema level support for publication. Tom Lane 13:31
Re: CI/windows docker vs "am a service" autodetection on windows Magnus Hagander 13:34
Re: Autovacuum on partitioned table (autoanalyze) Álvaro Herrera 14:03
Re: Some RELKIND macro refactoring Alvaro Herrera 14:22
Re: pgsql: pgstat: Bring up pgstat in BaseInit() to fix uninitialized use o 📎 Dilip Kumar 14:47
Re: POC: Cleaning up orphaned files using undo logs Dmitry Dolgov 15:00
Re: PG14: Avoid checking output-buffer-length for every encoded byte during pg_hex_encode 📎 Ranier Vilela 15:04
Re[5]: On login trigger: take three Ivan Panchenko 15:11
Re: badly calculated width of emoji in psql John Naylor 15:24
Re: Non-decimal integer literals John Naylor 15:32
Re: PoC/WIP: Extended statistics on expressions 📎 Tomas Vondra 15:41
Re: Autovacuum on partitioned table (autoanalyze) 📎 Álvaro Herrera 15:46
Re: call popcount32/64 directly on non-x86 platforms John Naylor 15:56
Re: Window Function "Run Conditions" Zhihong Yu 15:57
Re: BUG #17144: Upgrade from v13 to v14 with the cube extension failed Tom Lane 16:05
Re: Slightly improve initdb --sync-only option's help message Gurjeet Singh 16:06
Re: Autovacuum on partitioned table (autoanalyze) Tom Lane 16:17
AW: PG14: Avoid checking output-buffer-length for every encoded byte during pg_hex_encode Hans Buschmann 16:19
Re: Autovacuum on partitioned table (autoanalyze) Álvaro Herrera 17:00
Re: badly calculated width of emoji in psql Jacob Champion 17:04
Re: PG14: Avoid checking output-buffer-length for every encoded byte during pg_hex_encode 📎 Ranier Vilela 17:06
Re: Autovacuum on partitioned table (autoanalyze) Álvaro Herrera 17:13
The Free Space Map: Problems and Opportunities Peter Geoghegan 17:35
Re: Catalog version access 📎 Bossart, Nathan 18:12
Re: Emit namespace in post-copy output Daniel Gustafsson 18:13
Re: [PATCH] Native spinlock support on RISC-V Daniel Gustafsson 18:17
Re: [PATCH] Native spinlock support on RISC-V Tom Lane 19:09
ALTER TYPE vs extension membership (was Re: BUG #17144: Upgrade from v13 to v14 with the cube extension failed) 📎 Tom Lane 19:36
Re: when the startup process doesn't (logging startup delays) Robert Haas 19:38
Re: badly calculated width of emoji in psql John Naylor 20:06
Re: Reducing memory consumption for pending inval messages Bossart, Nathan 20:14
Re: Reducing memory consumption for pending inval messages Tom Lane 20:18
Re: Autovacuum on partitioned table (autoanalyze) Álvaro Herrera 21:42
Re: Autovacuum on partitioned table (autoanalyze) Justin Pryzby 22:28
Re: The Free Space Map: Problems and Opportunities Bruce Momjian 22:49
Allow composite foreign keys to reference a superset of unique constraint columns? Paul Martinez 23:36

Aug. 17, 2021

Thread Author Time
Re: Allow composite foreign keys to reference a superset of unique constraint columns? David G. Johnston 00:00
Re: Re[5]: On login trigger: take three Greg Nancarrow 00:07
Re: archive status ".ready" files may be created too early [email protected] 00:09
Re: The Free Space Map: Problems and Opportunities Peter Geoghegan 00:15
Re: The Free Space Map: Problems and Opportunities Peter Geoghegan 00:42
Re: Added schema level support for publication. Peter Smith 01:09
Re: PG14: Avoid checking output-buffer-length for every encoded byte during pg_hex_encode 📎 Michael Paquier 02:00
Re: Is it worth pushing conditions to sublink/subplan? Wenjing 02:30
Re: Some RELKIND macro refactoring Michael Paquier 02:59
Re: Skipping logical replication transactions on subscriber side Greg Nancarrow 03:00
Re: PG14: Avoid checking output-buffer-length for every encoded byte during pg_hex_encode Michael Paquier 03:43
A problem in ExecModifyTable 李杰 (慎追) 03:56
Re: return correct error code from pgtls_init Michael Paquier 04:13
Re: archive status ".ready" files may be created too early 📎 Bossart, Nathan 04:25
Re: Skipping logical replication transactions on subscriber side Masahiko Sawada 05:00
Re: Allow parallel DISTINCT David Rowley 05:07
Re: Skipping logical replication transactions on subscriber side Masahiko Sawada 05:16
Re: pgsql: pgstat: Bring up pgstat in BaseInit() to fix uninitialized use o Amit Kapila 05:24
Re: Skipping logical replication transactions on subscriber side Amit Kapila 05:35
Re: A problem in ExecModifyTable David Rowley 05:41
Re: Diagnostic comment in LogicalIncreaseXminForSlot 📎 Ashutosh Bapat 06:28
Re: ECPG bug fix: DECALRE STATEMENT and DEALLOCATE, DESCRIBE Michael Paquier 06:34
Re: pgsql: pgstat: Bring up pgstat in BaseInit() to fix uninitialized use o Amit Kapila 06:36
回复:A problem in ExecModifyTable 李杰 (慎追) 07:06
Re: pgsql: pgstat: Bring up pgstat in BaseInit() to fix uninitialized use o Dilip Kumar 07:37
Re: Two patches to speed up pg_rewind. Michael Paquier 07:47
Re: pgsql: pgstat: Bring up pgstat in BaseInit() to fix uninitialized use o 📎 Dilip Kumar 08:00
Re: Fix uninitialized variable access (src/backend/utils/mmgr/freepage.c) Michael Paquier 08:04
Re: Allow parallel DISTINCT Zhihong Yu 08:13
RE: Skipping logical replication transactions on subscriber side [email protected] 08:21
Re: pgstat_send_connstats() introduces unnecessary timestamp and UDP overhead Laurenz Albe 08:44
Re: pgsql: pgstat: Bring up pgstat in BaseInit() to fix uninitialized use o Amit Kapila 08:56
Re: [PATCH] Allow multiple recursive self-references Peter Eisentraut 09:07
Re: pgstat_send_connstats() introduces unnecessary timestamp and UDP overhead Andres Freund 09:14
Re: Added schema level support for publication. Amit Kapila 10:08
Re: Autovacuum on partitioned table (autoanalyze) 📎 Andres Freund 10:49
Re: Autovacuum on partitioned table (autoanalyze) Andres Freund 10:50
Re: Allow parallel DISTINCT 📎 David Rowley 10:58
Re: PG14: Avoid checking output-buffer-length for every encoded byte during pg_hex_encode Ranier Vilela 11:00
Re: pgsql: pgstat: Bring up pgstat in BaseInit() to fix uninitialized use o Andres Freund 11:04

Browse Archives

Prev | Next