pgsql-hackers since 2018-10-03 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

Oct. 3, 2018

Thread	Author	Time
Re: SSL tests failing with "ee key too small" error on Debian SID	Michael Paquier	00:32
Re: speeding up planning with partitions	Amit Langote	00:47
Relax transactional restrictions on ALTER ENUM ... ADD TYPE (redux) 📎	Thomas Munro	01:24
Re: file cloning in pg_upgrade and CREATE DATABASE	Alvaro Herrera	01:35
Re: file cloning in pg_upgrade and CREATE DATABASE	Michael Paquier	01:44
Re: file cloning in pg_upgrade and CREATE DATABASE	Alvaro Herrera	02:07
Re: SerializeParamList vs machines with strict alignment	Amit Kapila	02:59
Re: partition tree inspection functions 📎	Michael Paquier	03:37
Re: Relax transactional restrictions on ALTER ENUM ... ADD TYPE (redux)	Thomas Munro	03:42
Re: Relax transactional restrictions on ALTER ENUM ... ADD TYPE (redux) 📎	Thomas Munro	04:02
Re: SerializeParamList vs machines with strict alignment	Amit Kapila	04:32
Re: Tid scan improvements	David Rowley	04:36
Re: Pluggable Storage - Andres's take	Andres Freund	05:16
Re: Add SKIP LOCKED to VACUUM and ANALYZE	Michael Paquier	05:52
Re: [WIP PATCH] Index scan offset optimisation using visibility map	Andrey Borodin	05:54
Re: Performance improvements for src/port/snprintf.c	Andres Freund	06:09
RE: Global shared meta cache 📎	Ideriha, Takeshi	06:17
Re: [WIP PATCH] Index scan offset optimisation using visibility map	Michael Paquier	06:40
Re: file cloning in pg_upgrade and CREATE DATABASE	Michael Paquier	07:20
Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru 📎	Masahiko Sawada	07:37
Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2	Chris Travers	07:40
Re: Segfault when creating partition with a primary key and sql_drop trigger exists 📎	Michael Paquier	07:53
Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru	Michael Paquier	07:55
Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2	Chris Travers	07:56
Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2	Chris Travers	08:03
Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2	Chris Travers	09:02
shared buffer manager problems and redesign	Jamison, Kirk	09:46
Re[2]: Alter index rename concurrently to	Andrey Klychkov	11:51
Re: partition tree inspection functions	Jesper Pedersen	12:12
Re: Performance improvements for src/port/snprintf.c	Tom Lane	12:20
Re: [RFC] Removing "magic" oids	Andreas Karlsson	12:34
Re: BUG #15307: Low numerical precision of (Co-) Variance 📎	Dean Rasheed	13:04
Re: BUG #15307: Low numerical precision of (Co-) Variance	Tom Lane	14:21
Re: BUG #15307: Low numerical precision of (Co-) Variance	Madeleine Thompson	14:58
Re: Performance improvements for src/port/snprintf.c	Andres Freund	15:52
Re: Early WIP/PoC for inlining CTEs	David Fetter	15:57
Re: Performance improvements for src/port/snprintf.c 📎	Tom Lane	15:59
Re: Performance improvements for src/port/snprintf.c	Tom Lane	16:07
Re: Performance improvements for src/port/snprintf.c	Andres Freund	16:14
Re: Add SKIP LOCKED to VACUUM and ANALYZE 📎	Bossart, Nathan	16:20
Re: Performance improvements for src/port/snprintf.c	Tom Lane	16:22
Re: libpq host/hostaddr/conninfo inconsistencies	Arthur Zakirov	16:24
Re: Performance improvements for src/port/snprintf.c	Andres Freund	16:32
Re: Performance improvements for src/port/snprintf.c	Andres Freund	16:37
Re: Performance improvements for src/port/snprintf.c	Tom Lane	16:43
Re: Performance improvements for src/port/snprintf.c	Tom Lane	16:54
Re: Performance improvements for src/port/snprintf.c	Andres Freund	17:00
Re: Performance improvements for src/port/snprintf.c	Tom Lane	17:18
Re: Performance improvements for src/port/snprintf.c	Tom Lane	17:31
Re: Performance improvements for src/port/snprintf.c	Andres Freund	17:36
Re: Performance improvements for src/port/snprintf.c	Andres Freund	17:39
Re: Performance improvements for src/port/snprintf.c	Tom Lane	17:40
Re: Performance improvements for src/port/snprintf.c	Andres Freund	17:45
Re: Performance improvements for src/port/snprintf.c	Tom Lane	17:51
Re: Performance improvements for src/port/snprintf.c 📎	Tom Lane	18:01
Re: Performance improvements for src/port/snprintf.c	Alvaro Herrera	18:11
Re: Performance improvements for src/port/snprintf.c	Andres Freund	18:35
Re: Performance improvements for src/port/snprintf.c	Tom Lane	18:36
Re: Performance improvements for src/port/snprintf.c	Tom Lane	18:48
pg_upgrade failed with ERROR: null relpartbound for relation 18159 error.	Rajkumar Raghuwanshi	18:58
Shouldn't ExecShutdownNode() be called from standard_ExecutorFinish()?	Andres Freund	19:03
Re: Query is over 2x slower with jit=on	Andres Freund	19:56
Re: executor relation handling	Tom Lane	20:16
Skylake-S warning	Daniel Wood	21:29
DROP DATABASE doesn't force other backends to close FDs	Andres Freund	22:37
Re: Skylake-S warning	Andres Freund	22:55
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons 📎	Peter Geoghegan	23:39

Oct. 4, 2018

Thread	Author	Time
Re: Skylake-S warning	Daniel Wood	00:01
Re: Add SKIP LOCKED to VACUUM and ANALYZE	Michael Paquier	00:09
Re: [RFC] Removing "magic" oids	Vik Fearing	00:22
Re: partition tree inspection functions	Michael Paquier	00:27
Re: Skylake-S warning	Daniel Wood	00:28
Re: Skylake-S warning	Andres Freund	00:30
RE: Function for listing archive_status directory	Iwata, Aya	01:03
Re: Add SKIP LOCKED to VACUUM and ANALYZE	Bossart, Nathan	01:32
Re: SerializeParamList vs machines with strict alignment	Amit Kapila	02:30
Re: [HACKERS] Secondary index access optimizations 📎	David Rowley	03:19
Re: Shouldn't ExecShutdownNode() be called from standard_ExecutorFinish()?	Amit Kapila	04:15
RE: Protect syscache from bloating with negative cache entries	Ideriha, Takeshi	04:27
Re: Skylake-S warning	Adrien Nayrat	06:54
Re: executor relation handling 📎	Amit Langote	06:59
Re: partition tree inspection functions 📎	Amit Langote	07:49
Re: Skylake-S warning	Ants Aasma	07:49
Re: partition tree inspection functions	Amit Langote	07:53
Re: [HACKERS] Optional message to user when terminating/cancelling backend 📎	Michael Paquier	07:59
Re: [HACKERS] Optional message to user when terminating/cancelling backend	Daniel Gustafsson	08:06
RE: speeding up planning with partitions	Imai, Yoshikazu	08:11
Re: partition tree inspection functions	Michael Paquier	08:18
RE: [Proposal] Add accumulated statistics for wait event	Yotsunaga, Naoki	08:31
Re: speeding up planning with partitions	Amit Langote	09:06
Re: [HACKERS] Secondary index access optimizations 📎	Konstantin Knizhnik	09:11
Re: New vacuum option to do only freezing	Masahiko Sawada	09:15
Re: [HACKERS] Secondary index access optimizations	David Rowley	09:19
Re: Early WIP/PoC for inlining CTEs	Andreas Karlsson	09:22
RE: [Proposal] Add accumulated statistics for wait event	Phil Florent	09:32
Re: libpq compression 📎	Konstantin Knizhnik	09:53
Re: [Proposal] Add accumulated statistics for wait event	Michael Paquier	10:58
Re: [HACKERS] Optional message to user when terminating/cancelling backend	Michael Paquier	11:00
Re: Function to promote standby servers 📎	Laurenz Albe	11:26
Possible important data point on stats collection, wondering about possible improvement	Chris Travers	12:11
Poor plan when using EXISTS in the expression list	Pierre Ducroquet	12:11
Re: pg_ls_tmpdir()	Laurenz Albe	12:23
RE: [Proposal] Add accumulated statistics for wait event	Phil Florent	12:54
Re: SerializeParamList vs machines with strict alignment	Tom Lane	13:59
Re: executor relation handling	Tom Lane	14:19
Re: Poor plan when using EXISTS in the expression list	Geoff Winkless	14:46
Re: Multiple primary key on partition table?	Alvaro Herrera	14:55
Re: Segfault when creating partition with a primary key and sql_drop trigger exists	Alvaro Herrera	15:22
Re: [HACKERS] Secondary index access optimizations 📎	Konstantin Knizhnik	15:45
Re: Segfault when creating partition with a primary key and sql_drop trigger exists	Dmitry Dolgov	16:08
Re: Segfault when creating partition with a primary key and sql_drop trigger exists	Alvaro Herrera	16:30
Re: TupleTableSlot abstraction 📎	Amit Khandekar	17:29
Re: Early WIP/PoC for inlining CTEs	David Fetter	18:49
Changes in Brazil DST's period	Emílio B. Pedrollo	19:05
Re: executor relation handling	Andres Freund	19:12
Procedure calls are not tracked in pg_stat_user_functions / track_functions	Lukas Fittl	19:15
Re: executor relation handling	Tom Lane	19:27
Re: executor relation handling	Andres Freund	19:34
Re: executor relation handling	Andres Freund	19:56
Re: executor relation handling	Robert Haas	19:57
Re: Poor plan when using EXISTS in the expression list	Pierre Ducroquet	20:00
Re: Procedure calls are not tracked in pg_stat_user_functions / track_functions	Andres Freund	20:07
Re: executor relation handling	Tom Lane	20:40
snprintf assert is broken by plpgsql #option dump	Pavel Stehule	20:50
Re: executor relation handling	Tom Lane	20:59
Re: snprintf assert is broken by plpgsql #option dump	Tom Lane	21:17
Re: snprintf assert is broken by plpgsql #option dump 📎	Tom Lane	21:57
Re: Segfault when creating partition with a primary key and sql_drop trigger exists	Alvaro Herrera	21:59
Re: Segfault when creating partition with a primary key and sql_drop trigger exists	Tom Lane	22:04
Re: Segfault when creating partition with a primary key and sql_drop trigger exists	Michael Paquier	23:29
Re: [HACKERS] Why does logical replication launcher exit with exit code 1?	Thomas Munro	23:36
Re: Segfault when creating partition with a primary key and sql_drop trigger exists	Andres Freund	23:54

Oct. 5, 2018

Thread	Author	Time
Re: pg_ls_tmpdir()	Michael Paquier	00:31
Re: Segfault when creating partition with a primary key and sql_drop trigger exists	Michael Paquier	00:34
Re: Early WIP/PoC for inlining CTEs	Andrew Gierth	00:40
Re: snprintf assert is broken by plpgsql #option dump	Pavel Stehule	00:54
Re: pg_ls_tmpdir()	Bossart, Nathan	01:14
Re: Tid scan improvements	Edmund Horner	01:24
TAP tests for pg_verify_checksums 📎	Michael Paquier	01:26
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	01:34
Re: executor relation handling	Amit Langote	02:06
Re: Odd 9.4, 9.3 buildfarm failure on s390x 📎	Tom Lane	02:12
Re: dsa_allocate() faliure	Thomas Munro	02:16
Re: Odd 9.4, 9.3 buildfarm failure on s390x	Thomas Munro	02:24
Re: Odd 9.4, 9.3 buildfarm failure on s390x	Tom Lane	02:28
Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru 📎	Michael Paquier	03:16
Re: Segfault when creating partition with a primary key and sql_drop trigger exists	Jonathan S. Katz	03:24
Re: Segfault when creating partition with a primary key and sql_drop trigger exists	Tom Lane	03:37
Assertion failure with ALTER TABLE ATTACH PARTITION with log_min_messages >= DEBUG1 📎	Michael Paquier	04:22
Re: Multiple primary key on partition table?	amul sul	04:50
Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru	Masahiko Sawada	05:21
Re: partition tree inspection functions 📎	Michael Paquier	05:56
Re: partition tree inspection functions	Pavel Stehule	06:05
Re: pg_upgrade failed with ERROR: null relpartbound for relation 18159 error. 📎	Amit Langote	06:06
Re: partition tree inspection functions 📎	Amit Langote	06:31
Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru	Michael Paquier	06:35
Replace PG_AUTOCONF_FILENAME with parameter	Jonathan Jacobson	06:39
Re: Replace PG_AUTOCONF_FILENAME with parameter	Michael Paquier	06:47
Re: partition tree inspection functions	Michael Paquier	06:52
Re: Replace PG_AUTOCONF_FILENAME with parameter	Andrew Gierth	06:56
Re: pg_upgrade failed with ERROR: null relpartbound for relation 18159 error.	Michael Paquier	07:05
out-of-order XID insertion in KnownAssignedXids	Konstantin Knizhnik	07:06
GCI Mentor	Anushi Maheshwari	07:30
Re: Function to promote standby servers	Masahiko Sawada	07:32
Re: pg_upgrade failed with ERROR: null relpartbound for relation 18159 error. 📎	Amit Langote	07:55
Re: out-of-order XID insertion in KnownAssignedXids	Michael Paquier	08:04
Re: [HACKERS] Optional message to user when terminating/cancelling backend 📎	Daniel Gustafsson	08:11
RE: [Proposal] Add accumulated statistics for wait event	Yotsunaga, Naoki	08:21
Re: shared-memory based stats collector 📎	Kyotaro HORIGUCHI	08:30
Re: out-of-order XID insertion in KnownAssignedXids	Konstantin Knizhnik	08:33
Re: pg_upgrade failed with ERROR: null relpartbound for relation 18159 error. 📎	Michael Paquier	08:38
Re: Problem while updating a foreign table pointing to a partitioned table on foreign server 📎	Etsuro Fujita	09:18
Re: Alter index rename concurrently to 📎	Peter Eisentraut	10:03
Re: Problems with plan estimates in postgres_fdw	Etsuro Fujita	10:15
Re: Function for listing archive_status directory	'Christoph Moench-Tegeder'	11:06
Re: transction_timestamp() inside of procedures 📎	Peter Eisentraut	11:28
Re: TAP tests for pg_verify_checksums	Michael Banck	11:38
Re: Procedure calls are not tracked in pg_stat_user_functions / track_functions 📎	Peter Eisentraut	12:15
Re: [HACKERS] Support for Secure Transport SSL library on macOS as OpenSSL alternative	Peter Eisentraut	12:19
Re: partition tree inspection functions	Jesper Pedersen	12:22
Re: Speeding up INSERTs and UPDATEs to partitioned tables 📎	David Rowley	12:55
Re: automatic restore point 📎	Peter Eisentraut	13:26
now() vs transaction_timestamp()	Konstantin Knizhnik	13:29
Re: Relax transactional restrictions on ALTER ENUM ... ADD TYPE (redux)	Andrew Dunstan	13:31
Re: now() vs transaction_timestamp()	Tom Lane	13:56
Re: Libpq support to connect to standby server as priority	Laurenz Albe	14:34
Re: SCRAM with channel binding downgrade attack	Peter Eisentraut	14:53
Re: TupleTableSlot abstraction	Amit Khandekar	14:58
Re: Odd 9.4, 9.3 buildfarm failure on s390x 📎	Tom Lane	15:12
Re: Jsonb transform for pl/python	Peter Eisentraut	15:40
Re: Assertion failure with ALTER TABLE ATTACH PARTITION with log_min_messages >= DEBUG1	Alvaro Herrera	15:41
Re: NOTIFY and pg_notify performance when deduplicating notifications	Catalin Iacob	15:47
Re: Performance improvements for src/port/snprintf.c	Tom Lane	15:54
Re: pgsql: Make WAL segment size configurable at initdb time.	David Steele	16:41
Re: pgsql: Make WAL segment size configurable at initdb time.	Andres Freund	16:54
Re: Performance improvements for src/port/snprintf.c	Andres Freund	16:58
Re: SCRAM with channel binding downgrade attack	Bruce Momjian	17:01
Re: pgsql: Make WAL segment size configurable at initdb time.	David Steele	17:03
Re: Performance improvements for src/port/snprintf.c	Tom Lane	17:10
Re: Skylake-S warning	Andres Freund	17:29

Browse Archives

Prev | Next