pgsql-hackers since 2020-06-05 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

June 5, 2020

Thread	Author	Time
Re: posgres 12 bug (partitioned table)	David Rowley	00:18
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey	David Rowley	00:26
Re: v13: Performance regression related to FORTIFY_SOURCE	Jeff Davis	00:58
Re: v13: Performance regression related to FORTIFY_SOURCE	Jeff Davis	01:09
Re: significant slowdown of HashAggregate between 9.6 and 10	Jeff Davis	01:22
Re: v13: Performance regression related to FORTIFY_SOURCE	Tom Lane	01:41
Re: significant slowdown of HashAggregate between 9.6 and 10	Andres Freund	01:57
Re: REINDEX CONCURRENTLY and indisreplident	Michael Paquier	02:04
Re: Atomic operations within spinlocks	Andres Freund	02:33
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey	Andy Fan	02:36
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey	David Rowley	02:57
Re: Atomic operations within spinlocks	Andres Freund	03:03
Re: A wrong index choose issue because of inaccurate statistics	Andy Fan	03:32
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey	Andy Fan	04:20
Re: BufFileRead() error signalling 📎	Thomas Munro	06:03
Re: Removal of currtid()/currtid2() and some table AM cleanup	Michael Paquier	06:07
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Amit Kapila	06:07
Re: A wrong index choose issue because of inaccurate statistics	David Rowley	06:18
Re: Removal of currtid()/currtid2() and some table AM cleanup	Michael Paquier	06:22
Re: A wrong index choose issue because of inaccurate statistics	Pavel Stehule	06:30
Re: OpenSSL 3.0.0 compatibility	Michael Paquier	07:31
Re: valgrind error 📎	Noah Misch	07:48
Re: BufFileRead() error signalling	Michael Paquier	08:14
Make more use of RELKIND_HAS_STORAGE() 📎	Peter Eisentraut	09:05
Re: OpenSSL 3.0.0 compatibility	Peter Eisentraut	09:21
Re: Transactions involving multiple postgres foreign servers, take 2 📎	Masahiko Sawada	09:45
BUG #16481: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events	PG Bug reporting form	11:05
Re: proposal - function string_to_table 📎	Pavel Stehule	11:55
minor doc fix - garbage in example of result of unnest	Pavel Stehule	11:58
Re: [Proposal] Page Compression for OLTP 📎	chenhj	12:39
Re: [PATCH] pg_dump: Add example and link for --encoding option 📎	이동욱	12:45
Re: SIGSEGV from START_REPLICATION 0/XXXXXXX in XLogSendPhysical () at walsender.c:2762	Dave Cramer	13:04
Re: Removal of currtid()/currtid2() and some table AM cleanup	Inoue, Hiroshi	13:25
Re: significant slowdown of HashAggregate between 9.6 and 10	Tomas Vondra	13:25
Re: Internal key management system 📎	Fabien COELHO	13:34
Re: minor doc fix - garbage in example of result of unnest	Tom Lane	13:56
create database with template doesn't copy ACL	PG Doc comments form	14:31
Re: More efficient RI checks - take 2 📎	Antonin Houska	15:16
Re: WIP: WAL prefetch (another approach) 📎	Tomas Vondra	15:20
Re: minor doc fix - garbage in example of result of unnest	Tomas Vondra	15:38
Re: minor doc fix - garbage in example of result of unnest	David G. Johnston	15:49
Re: SIGSEGV from START_REPLICATION 0/XXXXXXX in XLogSendPhysical () at walsender.c:2762	Alvaro Herrera	15:51
Re: Make more use of RELKIND_HAS_STORAGE()	Tom Lane	16:05
Improve planner cost estimations for alternative subplans 📎	Alexey Bashtanov	16:08
Re: valgrind error	Tom Lane	16:17
Re: minor doc fix - garbage in example of result of unnest	Tom Lane	16:19
Re: significant slowdown of HashAggregate between 9.6 and 10	Andres Freund	16:33
Re: WIP: WAL prefetch (another approach)	Tomas Vondra	20:04
Re: WIP: WAL prefetch (another approach)	Tomas Vondra	20:40
Re: repeat() function, CHECK_FOR_INTERRUPTS(), and unlikely()	Joe Conway	20:53
Re: WIP: WAL prefetch (another approach)	Thomas Munro	21:15
Re: Trouble with hashagg spill I/O pattern and costing	Alvaro Herrera	21:19
Re: v13: Performance regression related to FORTIFY_SOURCE	Andres Freund	21:49
Re: Trouble with hashagg spill I/O pattern and costing	Tomas Vondra	22:20
Re: WIP: WAL prefetch (another approach)	Tomas Vondra	22:34
Re: Trouble with hashagg spill I/O pattern and costing	Alvaro Herrera	22:51
Re: Trouble with hashagg spill I/O pattern and costing	Tomas Vondra	23:17

June 6, 2020

Thread	Author	Time
Re: Atomic operations within spinlocks	Andres Freund	00:19
Re: WIP: WAL prefetch (another approach)	Stephen Frost	00:36
Re: Atomic operations within spinlocks	Tom Lane	01:01
Re: v13: Performance regression related to FORTIFY_SOURCE	Jeff Davis	01:30
Re: v13: Performance regression related to FORTIFY_SOURCE	Jeff Davis	01:39
Re: v13: Performance regression related to FORTIFY_SOURCE 📎	Jeff Davis	01:46
Re: v13: Performance regression related to FORTIFY_SOURCE	Tom Lane	01:50
Re: v13: Performance regression related to FORTIFY_SOURCE	Jeff Davis	02:06
Re: Atomic operations within spinlocks	Andres Freund	02:31
Re: v13: Performance regression related to FORTIFY_SOURCE	Andres Freund	02:45
Re: Atomic operations within spinlocks	Tom Lane	02:52
Re: valgrind error	Noah Misch	02:57
Re: valgrind error	Tom Lane	03:03
Re: Atomic operations within spinlocks	Andres Freund	03:32
hashagg slowdown due to spill changes	Andres Freund	04:11
Re: libpq copy error handling busted	Andres Freund	04:30
Vacuuming the operating system documentation 📎	Thomas Munro	04:57
Re: Vacuuming the operating system documentation	Peter Eisentraut	07:58
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey	Dmitry Dolgov	09:17
Re: how to create index concurrently on paritioned table	Justin Pryzby	14:23
Re: psql - add SHOW_ALL_RESULTS option 📎	Fabien COELHO	14:36
Re: Vacuuming the operating system documentation	Tom Lane	14:41
Re: Vacuuming the operating system documentation	Magnus Hagander	14:57
Re: Vacuuming the operating system documentation	Tom Lane	15:14
Re: libpq copy error handling busted	Tom Lane	16:16
Re: Vacuuming the operating system documentation	Peter Eisentraut	16:35
Re: Vacuuming the operating system documentation	Magnus Hagander	16:38
output columns of \dAo and \dAp	Peter Eisentraut	17:15
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line	Peter Eisentraut	17:48
Re: output columns of \dAo and \dAp	Tom Lane	21:34
Debian Sid broke Perl	Noah Misch	22:20
Re: Debian Sid broke Perl	Tom Lane	22:38
Re: Debian Sid broke Perl	Noah Misch	22:53
Re: Debian Sid broke Perl	Tom Lane	23:00
Re: Debian Sid broke Perl	Tom Lane	23:11
Re: Debian Sid broke Perl	Noah Misch	23:53

June 7, 2020

Thread	Author	Time
Re: Debian Sid broke Perl	Tom Lane	00:38
Re: Debian Sid broke Perl	Noah Misch	00:46
Re: Debian Sid broke Perl	Tom Lane	01:02
Re: Debian Sid broke Perl	Tom Lane	01:35
Re: Vacuuming the operating system documentation 📎	Thomas Munro	02:52
Re: Vacuuming the operating system documentation 📎	Tom Lane	03:42
Re: valgrind error	Tom Lane	03:59
valgrind versus pg_atomic_init()	Tom Lane	04:23
Re: Add LWLock blocker(s) information 📎	Drouvot, Bertrand	06:12
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey	David Rowley	06:51
TAP tests not enabled in pg_dump	Dong Wook Lee	07:51
Re: TAP tests not enabled in pg_dump	Thomas Munro	08:07
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*)	Fabien COELHO	08:07
Re: Improving connection scalability: GetSnapshotData()	Michail Nikolaev	08:24
Re: Vacuuming the operating system documentation	Thomas Munro	11:03
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	11:36
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	11:37
Re: Vacuuming the operating system documentation	Tom Lane	15:00
Re: Debian Sid broke Perl	Tom Lane	15:06
Re: how to create index concurrently on paritioned table 📎	Justin Pryzby	18:04
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line	Alexander Korotkov	19:05
Re: Vacuuming the operating system documentation 📎	Thomas Munro	23:54

June 8, 2020

Thread	Author	Time
Re: Vacuuming the operating system documentation	Tom Lane	00:03
Re: SIGSEGV from START_REPLICATION 0/XXXXXXX in XLogSendPhysical () at walsender.c:2762	Michael Paquier	01:17
Re: race condition when writing pg_control	Thomas Munro	02:48
Re: race condition when writing pg_control	Bossart, Nathan	03:25
Bump default wal_level to logical 📎	David Fetter	04:38
Re: Vacuuming the operating system documentation	Peter Eisentraut	05:44
Re: BufFileRead() error signalling 📎	Thomas Munro	05:50
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line 📎	Michael Paquier	06:14
Re: snowball release	Peter Eisentraut	06:21
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Amit Kapila	06:23
Re: race condition when writing pg_control	Michael Paquier	06:26
Re: Bump default wal_level to logical	Amit Kapila	06:29
Re: Bump default wal_level to logical	Michael Paquier	06:45
Re: Removal of currtid()/currtid2() and some table AM cleanup	Michael Paquier	06:52
Re: Debian Sid broke Perl	Michael Paquier	07:00
Re: Read access for pg_monitor to pg_replication_origin_status view	Masahiko Sawada	07:21
Re: Read access for pg_monitor to pg_replication_origin_status view 📎	Kyotaro Horiguchi	08:22
Re: BUG #16481: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events 📎	Kyotaro Horiguchi	08:27
Re: shared-memory based stats collector 📎	Kyotaro Horiguchi	08:32
Re: Read access for pg_monitor to pg_replication_origin_status view	Kyotaro Horiguchi	08:44
Re: Bump default wal_level to logical	Magnus Hagander	09:10
RE: BUG #16481: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events	Vianello Fabio	09:13
should CREATE INDEX ON partitioned_table call PreventInTransactionBlock() ?	Justin Pryzby	09:35
Re: Improving psql slash usage help message	ahsan hadi	10:24
Re: race condition when writing pg_control	amul sul	10:44
Re: BUG #16481: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events	Euler Taveira	10:51
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line	Alexey Kondratov	11:16
Re: proposal - plpgsql - FOR over unbound cursor	Asif Rehman	11:39
Re: Is it useful to record whether plans are generic or custom?	Masahiro Ikeda	11:45
Re: proposal - plpgsql - FOR over unbound cursor	Pavel Stehule	11:45
TAP tests and symlinks on Windows 📎	Peter Eisentraut	12:44
Re: Wrong width of UNION statement	Ashutosh Bapat	13:11
Re: Bump default wal_level to logical	Tomas Vondra	13:38
Re: Vacuuming the operating system documentation	Tom Lane	13:51
Re: A wrong index choose issue because of inaccurate statistics	Ashutosh Bapat	14:15
Re: Speeding up parts of the planner using a binary search tree structure for nodes	Ashutosh Bapat	14:17
Re: snowball release	Tom Lane	14:33
Re: snowball release	Daniel Gustafsson	14:47
Re: BufFileRead() error signalling	Alvaro Herrera	14:49
Re: snowball release	Tom Lane	15:19
Re: should CREATE INDEX ON partitioned_table call PreventInTransactionBlock() ?	Alvaro Herrera	15:27
Re: should CREATE INDEX ON partitioned_table call PreventInTransactionBlock() ?	Justin Pryzby	15:40
Re: pg_upgrade fails with non-standard ACL 📎	Anastasia Lubennikova	15:44
[PATCH] Add support for choosing huge page size	Odin Ugedal	15:46
Re: Bump default wal_level to logical	David Fetter	16:18
Re: should CREATE INDEX ON partitioned_table call PreventInTransactionBlock() ?	Alvaro Herrera	16:21
Re: pg_upgrade fails with non-standard ACL	Alvaro Herrera	16:31
Re: Getting ERROR with FOR UPDATE/SHARE for partitioned table.	Alvaro Herrera	16:39
Re: Bump default wal_level to logical	Alvaro Herrera	17:16
Re: proposal: possibility to read dumped table's name from file 📎	Pavel Stehule	17:18
Re: Bump default wal_level to logical	Tom Lane	17:27
Re: Bump default wal_level to logical	Robert Haas	18:58
Re: Bump default wal_level to logical	Kenneth Marshall	19:05
Re: Bump default wal_level to logical	Robert Haas	19:09
Re: Bump default wal_level to logical	Peter Geoghegan	19:13
Re: Bump default wal_level to logical	Alvaro Herrera	19:27
Re: hashagg slowdown due to spill changes	Alvaro Herrera	20:15
Re: Bump default wal_level to logical	Peter Geoghegan	20:20
Re: hashagg slowdown due to spill changes	Jeff Davis	20:41
Re: snowball release	Peter Eisentraut	20:48
Re: hashagg slowdown due to spill changes	Jeff Davis	20:55
Re: hashagg slowdown due to spill changes	Andres Freund	21:08
Re: Bump default wal_level to logical	Andres Freund	21:27
Re: proposal: possibility to read dumped table's name from file	Justin Pryzby	21:29
Re: Bump default wal_level to logical	Andres Freund	21:32
Re: valgrind versus pg_atomic_init()	Andres Freund	22:02
Re: valgrind versus pg_atomic_init()	Tom Lane	22:21
Re: [PATCH] Add support for choosing huge page size	Thomas Munro	22:26
Remove SpinLockFree() / S_LOCK_FREE()?	Andres Freund	22:53
Re: Remove SpinLockFree() / S_LOCK_FREE()?	Tom Lane	23:00

June 9, 2020

Thread	Author	Time
Re: BUG #16040: PL/PGSQL RETURN QUERY statement never uses a parallel plan 📎	Tom Lane	00:11
Re: Avoiding hash join batch explosions with extreme skew and weird stats 📎	Melanie Plageman	00:12
Re: BufFileRead() error signalling 📎	Thomas Munro	00:21
Intermittent test plan change in "privileges" test on BF animal prion	Thomas Munro	02:26
Re: BufFileRead() error signalling	Michael Paquier	02:32
Re: [HACKERS] Multiple synchronous_standby_names rules	James Sewell	02:37
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line	Michael Paquier	02:40
Re: Intermittent test plan change in "privileges" test on BF animal prion	Tom Lane	02:54
Re: valgrind versus pg_atomic_init()	Andres Freund	03:25
Re: Intermittent test plan change in "privileges" test on BF animal prion	David Rowley	03:28
Re: valgrind versus pg_atomic_init()	Tom Lane	03:31
Re: A wrong index choose issue because of inaccurate statistics 📎	Andy Fan	03:33
Re: Intermittent test plan change in "privileges" test on BF animal prion	Tom Lane	03:41
Re: Intermittent test plan change in "privileges" test on BF animal prion	David Rowley	03:48
Re: Intermittent test plan change in "privileges" test on BF animal prion	Tom Lane	03:55

Browse Archives

Prev | Next