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

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
WIP: Avoid creation of the free space map for small tables 📎 John Naylor 18:47
Re: Postgres 11 release notes 📎 Jonathan S. Katz 19:28
Re: Segfault when creating partition with a primary key and sql_drop trigger exists Jonathan S. Katz 19:31
Re: Segfault when creating partition with a primary key and sql_drop trigger exists Andres Freund 19:35
Re: Segfault when creating partition with a primary key and sql_drop trigger exists Jonathan S. Katz 19:43
Re: Segfault when creating partition with a primary key and sql_drop trigger exists Alvaro Herrera 19:57
Re: Segfault when creating partition with a primary key and sql_drop trigger exists Tom Lane 20:04
Re: Odd 9.4, 9.3 buildfarm failure on s390x Tom Lane 20:06
Re: Create roles trigger Nasby, Jim 20:26
Re: Create roles trigger Scott Whitney 20:32
Re: WIP: Avoid creation of the free space map for small tables Thomas Munro 20:42
Re: Create roles trigger Keith Fiske 20:43
Re: Postgres 11 release notes Bruce Momjian 21:22
Re: Postgres 11 release notes Jonathan S. Katz 21:24
Re: now() vs transaction_timestamp() Tom Lane 21:25
Re: now() vs transaction_timestamp() Tom Lane 21:32
Re: Early WIP/PoC for inlining CTEs David Fetter 22:43
Creating Certificates Tatsuo Ishii 23:17
Re: Segfault when creating partition with a primary key and sql_drop trigger exists Michael Paquier 23:54

Oct. 6, 2018

Thread Author Time
Re: Assertion failure with ALTER TABLE ATTACH PARTITION with log_min_messages >= DEBUG1 Michael Paquier 00:00
Re: Relax transactional restrictions on ALTER ENUM ... ADD TYPE (redux) 📎 Thomas Munro 00:35
Re: Segfault when creating partition with a primary key and sql_drop trigger exists Alvaro Herrera 01:10
Re: Assertion failure with ALTER TABLE ATTACH PARTITION with log_min_messages >= DEBUG1 Alvaro Herrera 02:27
Re: Early WIP/PoC for inlining CTEs Andrew Gierth 02:48
Re: Performance improvements for src/port/snprintf.c 📎 Tom Lane 02:58
Re: Performance improvements for src/port/snprintf.c Andrew Gierth 03:10
Re: Performance improvements for src/port/snprintf.c Tom Lane 03:16
Re: Performance improvements for src/port/snprintf.c 📎 Andrew Gierth 03:36
Re: Performance improvements for src/port/snprintf.c Tom Lane 03:59
Re: Performance improvements for src/port/snprintf.c Andrew Gierth 04:32
Re: Calculate total_table_pages after set_base_rel_sizes() Edmund Horner 05:20
Re: Assertion failure with ALTER TABLE ATTACH PARTITION with log_min_messages >= DEBUG1 Michael Paquier 06:00
Re: partition tree inspection functions Michael Paquier 06:26
Re: Creating Certificates Tatsuo Ishii 09:46
Re: BUG #15307: Low numerical precision of (Co-) Variance Dean Rasheed 10:58
Re: Problem while setting the fpw with SIGHUP Amit Kapila 11:01
Re: TAP tests for pg_verify_checksums 📎 Michael Paquier 11:46
Re: now() vs transaction_timestamp() Amit Kapila 11:47
Re: now() vs transaction_timestamp() Pavel Stehule 12:12
Re: now() vs transaction_timestamp() 📎 Konstantin Knizhnik 12:51
Re: Relax transactional restrictions on ALTER ENUM ... ADD TYPE (redux) Andrew Dunstan 13:00
fine tune v11 release notes Justin Pryzby 13:42
Re: fine tune v11 release notes Marko Tiikkaja 13:50
Re: Creating Certificates Andrew Dunstan 14:47
Re: Performance improvements for src/port/snprintf.c Tom Lane 14:52
Re: now() vs transaction_timestamp() Tom Lane 16:10
Re: Segfault when creating partition with a primary key and sql_drop trigger exists 📎 Alvaro Herrera 16:50
Re: Relax transactional restrictions on ALTER ENUM ... ADD TYPE (redux) Tom Lane 16:53
Re: executor relation handling Tom Lane 18:59
Re: Unclear error message 📎 Laurenz Albe 21:16
Re: Creating Certificates Tatsuo Ishii 21:51
pgsql: Fix event triggers for partitioned tables Alvaro Herrera 22:18

Oct. 7, 2018

Thread Author Time
Re: Segfault when creating partition with a primary key and sql_drop trigger exists Alvaro Herrera 00:32
Re: Segfault when creating partition with a primary key and sql_drop trigger exists Michael Paquier 00:45
Re: pg_upgrade failed with ERROR: null relpartbound for relation 18159 error. Alvaro Herrera 01:15
Re: Relax transactional restrictions on ALTER ENUM ... ADD TYPE (redux) 📎 Thomas Munro 02:30
Re: now() vs transaction_timestamp() Amit Kapila 04:58
Re: now() vs transaction_timestamp() Tom Lane 05:06
Re: now() vs transaction_timestamp() Amit Kapila 05:26
Re: now() vs transaction_timestamp() Konstantin Knizhnik 05:42
Re: now() vs transaction_timestamp() Tom Lane 06:11
Defaulting to password_encryption = scram-sha-256 Andres Freund 06:43
Re: pg_upgrade failed with ERROR: null relpartbound for relation 18159 error. Michael Paquier 07:59
Re: Defaulting to password_encryption = scram-sha-256 Michael Paquier 08:03
Re: Unclear error message Michael Paquier 08:14
Re: Calculate total_table_pages after set_base_rel_sizes() David Rowley 08:43
Re: Unclear error message 📎 Michael Paquier 09:37

Browse Archives

Prev | Next