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

Browse Archives

Prev | Next

July 16, 2018

Thread Author Time
Re: why partition pruning doesn't work? Robert Haas 00:12
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian David Rowley 00:13
Re: why partition pruning doesn't work? David Rowley 00:24
Re: patch to allow disable of WAL recycling Robert Haas 00:32
Re: why partition pruning doesn't work? Tom Lane 00:45
Re: patch to allow disable of WAL recycling Tom Lane 00:55
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian David Rowley 00:55
Re: why partition pruning doesn't work? Robert Haas 01:12
Make foo=null a warning by default. 📎 David Fetter 01:40
Refactor documentation for wait events (Was: pgsql: Add wait event for fsync of WAL segments) 📎 Michael Paquier 02:10
Re: patch to allow disable of WAL recycling Stephen Frost 02:54
RE: How to make partitioning scale better for larger numbers of partitions Tsunakawa, Takayuki 04:16
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian David Rowley 04:27
RE: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian Phil Florent 04:56
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian David Rowley 05:48
Re: AtEOXact_ApplyLauncher() and subtransactions 📎 Amit Khandekar 06:36
Re: [PATCH] Add missing type conversion functions for PL/Python Haozhou Wang 07:35
Parallel queries in single transaction Paul Muntyanu 07:45
Re: Make foo=null a warning by default. Heikki Linnakangas 07:49
Re: Make foo=null a warning by default. Fabien COELHO 07:49
Re: Make foo=null a warning by default. Fabien COELHO 07:53
RE: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian Phil Florent 08:03
Re: Libpq support to connect to standby server as priority Haribabu Kommi 08:14
Re: patch to allow disable of WAL recycling Tomas Vondra 09:26
Re: Parallel queries in single transaction Tomas Vondra 09:44
Re: Parallel queries in single transaction Paul Muntyanu 10:03
Re: Fix some error handling for read() and errno Michael Paquier 11:09
Re: [WIP PATCH] Index scan offset optimisation using visibility map Michail Nikolaev 11:11
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case Ashutosh Bapat 11:52
Re: PATCH: psql tab completion for SELECT Heikki Linnakangas 12:00
Re: [HACKERS] PoC plpgsql - possibility to force custom or generic plan Peter Eisentraut 12:07
Re: Finding database for pg_upgrade missing library Bruce Momjian 12:13
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Tomas Vondra 12:17
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Tomas Vondra 12:23
Re: Parallel queries in single transaction Tomas Vondra 12:28
Re: Finding database for pg_upgrade missing library Bruce Momjian 12:29
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Dean Rasheed 12:54
Re: cursors with prepared statements Peter Eisentraut 12:56
Re: Usage of epoch in txid_current Andres Freund 13:03
Re: patch to allow disable of WAL recycling Andres Freund 13:06
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" Andres Freund 13:13
Re: patch to allow disable of WAL recycling Andres Freund 13:19
Re: Parallel queries in single transaction Paul Muntyanu 13:21
Re: Pluggable Storage - Andres's take Andres Freund 13:35
Re: Pluggable Storage - Andres's take Andres Freund 13:44
Re: Usage of epoch in txid_current Tom Lane 13:55
Re: patch to allow disable of WAL recycling Tom Lane 14:12
Re: cursors with prepared statements Robert Haas 14:25
Re: Vacuum: allow usage of more than 1GB of work mem Claudio Freire 14:34
Re: patch to allow disable of WAL recycling Robert Haas 14:38
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" Tom Lane 14:39
Re: Libpq support to connect to standby server as priority Laurenz Albe 14:42
Re: GiST VACUUM Robert Haas 14:58
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Robert Haas 15:01
Re: Make foo=null a warning by default. Robert Haas 15:06
Re: Make foo=null a warning by default. Tom Lane 15:10
Re: Make foo=null a warning by default. Heikki Linnakangas 15:19
Re: [HACKERS] logical decoding of two-phase transactions Tomas Vondra 15:21
Re: Refactor documentation for wait events (Was: pgsql: Add wait event for fsync of WAL segments) Robert Haas 15:22
Re: Logical decoding from promoted standby with same replication slot Jeremy Finzel 15:24
Re: New GUC to sample log queries Robert Haas 15:24
Re: PATCH: psql tab completion for SELECT Joao De Almeida Pereira 15:27
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Heikki Linnakangas 15:35
Re: Vacuum: allow usage of more than 1GB of work mem Claudio Freire 15:35
Re: Make foo=null a warning by default. Tom Lane 15:37
Re: Vacuum: allow usage of more than 1GB of work mem Heikki Linnakangas 15:47
Re: Make foo=null a warning by default. 📎 David Fetter 15:59
Re: [HACKERS] logical decoding of two-phase transactions Robert Haas 16:15
Another usability issue with our TAP tests Tom Lane 17:13
Re: [HACKERS] logical decoding of two-phase transactions Tom Lane 17:21
Re: GiST VACUUM 📎 Andrey Borodin 17:24
Re: [HACKERS] logical decoding of two-phase transactions Tomas Vondra 17:28
Re: [HACKERS] logical decoding of two-phase transactions Tomas Vondra 17:38
Re: [HACKERS] logical decoding of two-phase transactions Robert Haas 18:09
Re: Vacuum: allow usage of more than 1GB of work mem Andrew Dunstan 18:30
Re: Vacuum: allow usage of more than 1GB of work mem Claudio Freire 18:32
Re: Vacuum: allow usage of more than 1GB of work mem Andrew Dunstan 18:33
Re: [HACKERS] WAL logging problem in 9.4.3? Robert Haas 18:38
Re: [HACKERS] WAL logging problem in 9.4.3? Heikki Linnakangas 18:41
Alter index rename concurrently to 📎 Andrey Klychkov 18:58
Re: Alter index rename concurrently to Andrey Borodin 19:19
Re: [HACKERS] logical decoding of two-phase transactions Tomas Vondra 19:25
Re: Alter index rename concurrently to Victor Yegorov 19:40
Re: Fix some error handling for read() and errno Alvaro Herrera 20:04
Re: [HACKERS] WAL logging problem in 9.4.3? Alvaro Herrera 20:14
Re: New GUC to sample log queries Adrien Nayrat 20:19
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" 📎 Tom Lane 20:36
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Tomas Vondra 20:55
Re: New GUC to sample log queries Tomas Vondra 21:06
Re: AtEOXact_ApplyLauncher() and subtransactions Robert Haas 21:59
Re: patch to allow disable of WAL recycling Jerry Jelinek 22:04
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case Alvaro Herrera 23:17

July 17, 2018

Thread Author Time
Re: [HACKERS] WAL logging problem in 9.4.3? Michael Paquier 00:01
Re: Fix error message when trying to alter statistics on included column Alvaro Herrera 00:04
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian 📎 David Rowley 00:21
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case Amit Langote 00:22
Re: patch to allow disable of WAL recycling Michael Paquier 00:29
Re: PATCH: psql tab completion for SELECT 📎 Edmund Horner 01:31
Re: PATCH: psql tab completion for SELECT Edmund Horner 01:44
Re: How to make partitioning scale better for larger numbers of partitions Amit Langote 01:48
Re: Make foo=null a warning by default. David Fetter 01:49
RE: How to make partitioning scale better for larger numbers of partitions Kato, Sho 03:01
Re: How to make partitioning scale better for larger numbers of partitions Ashutosh Bapat 03:14
Re: Let's remove DSM_IMPL_NONE. Kyotaro HORIGUCHI 04:09
Re: Refactor documentation for wait events (Was: pgsql: Add wait event for fsync of WAL segments) Michael Paquier 04:19
Re: How to make partitioning scale better for larger numbers of partitions Amit Langote 04:37
Re: [HACKERS] Restricting maximum keep segments by repslots Masahiko Sawada 04:37
Re: pgsql: Allow UNIQUE indexes on partitioned tables Alvaro Herrera 04:57
Re: pgsql: Allow UNIQUE indexes on partitioned tables Amit Langote 04:59
untrusted PLs should be GRANTable Craig Ringer 05:20
RE: How to make partitioning scale better for larger numbers of partitions Kato, Sho 05:44
Re: Add SKIP LOCKED to VACUUM and ANALYZE Michael Paquier 06:21
foreign key to foreign table Kaye Ann Ignacio 06:43
Re: missing toast table for pg_policy Michael Paquier 06:46
Re: file cloning in pg_upgrade and CREATE DATABASE Michael Paquier 06:58
Re: Another usability issue with our TAP tests Michael Paquier 07:10
Re: missing toast table for pg_policy John Naylor 07:55
Re: missing toast table for pg_policy Michael Paquier 09:03
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Dean Rasheed 09:09
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Kyotaro HORIGUCHI 09:24
65279 Invisible ASCII Character ramsiddu007 09:30
Re: [HACKERS] advanced partition matching algorithm for partition-wise join 📎 Ashutosh Bapat 09:58
Re: [HACKERS] Restricting maximum keep segments by repslots Kyotaro HORIGUCHI 09:58
Re: 65279 Invisible ASCII Character Christoph Moench-Tegeder 10:12
Re: 65279 Invisible ASCII Character ramsiddu007 10:25
Re: file cloning in pg_upgrade and CREATE DATABASE Peter Eisentraut 10:32
Re: foreign key to foreign table Ashutosh Bapat 11:08
Re: Refactor documentation for wait events (Was: pgsql: Add wait event for fsync of WAL segments) Robert Haas 11:17
Re: Add SKIP LOCKED to VACUUM and ANALYZE Robert Haas 11:30
Re: [HACKERS] [PATCH] kNN for SP-GiST 📎 Nikita Glukhov 11:42
Re[2]: Alter index rename concurrently to Andrey Klychkov 11:48
Re: Make foo=null a warning by default. Fabien COELHO 11:58
Re: Libpq support to connect to standby server as priority Haribabu Kommi 12:15
Re: [HACKERS] WAL logging problem in 9.4.3? Andrew Dunstan 12:28
PG 10: could not generate random cancel key 📎 Dean Rasheed 12:33
Re: Make foo=null a warning by default. Fabien COELHO 12:34
Re[2]: Alter index rename concurrently to Andrey Klychkov 12:36
Re: Pluggable Storage - Andres's take Haribabu Kommi 13:01
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Tomas Vondra 13:03
Re: PG 10: could not generate random cancel key Michael Paquier 13:04
Re: [bug fix] Produce a crash dump before main() on Windows Haribabu Kommi 13:22
Re: PG 10: could not generate random cancel key Dean Rasheed 13:28
Re: [HACKERS] Support for Secure Transport SSL library on macOS as OpenSSL alternative Heikki Linnakangas 14:30
Another fun fact about temp tables and wraparound Grigory Smolkin 14:33
Re: Another fun fact about temp tables and wraparound Alvaro Herrera 14:46
Re: Allow auto_explain to log to NOTICE 📎 Daniel Gustafsson 16:04
Re: Allow auto_explain to log to NOTICE Andrew Dunstan 17:11
Re: PG 10: could not generate random cancel key Robert Haas 17:15
Re: chained transactions Heikki Linnakangas 17:21
Re: PG 10: could not generate random cancel key Alvaro Herrera 17:27
Re: Vacuum: allow usage of more than 1GB of work mem Robert Haas 17:30
Re: PG 10: could not generate random cancel key Robert Haas 17:31
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian Alvaro Herrera 18:01
Re: Allow auto_explain to log to NOTICE Daniel Gustafsson 18:03
Re: [HACKERS] logical decoding of two-phase transactions Robert Haas 18:10
Re: GiST VACUUM 📎 Andrey Borodin 18:41
Re: Another usability issue with our TAP tests Peter Eisentraut 18:46
Re: Allowing multiple DDL commands to run simultaneously Robert Haas 18:47
Re: untrusted PLs should be GRANTable Peter Eisentraut 18:51
Re: Another usability issue with our TAP tests Tom Lane 19:02
Re: patch to allow disable of WAL recycling Peter Eisentraut 19:12
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons 📎 Peter Geoghegan 19:21
Re: "Write amplification" is made worse by "getting tired" while inserting into nbtree secondary indexes (Was: Why B-Tree suffix truncation matters) Robert Haas 20:12
Re: "Write amplification" is made worse by "getting tired" while inserting into nbtree secondary indexes (Was: Why B-Tree suffix truncation matters) Tom Lane 20:29
Re: patch to allow disable of WAL recycling Tomas Vondra 20:47
Re: "Write amplification" is made worse by "getting tired" while inserting into nbtree secondary indexes (Was: Why B-Tree suffix truncation matters) Peter Geoghegan 21:16
Re: "Write amplification" is made worse by "getting tired" while inserting into nbtree secondary indexes (Was: Why B-Tree suffix truncation matters) Peter Geoghegan 21:28
Re: Allowing multiple DDL commands to run simultaneously Simon Riggs 22:00
Re: "Write amplification" is made worse by "getting tired" while inserting into nbtree secondary indexes (Was: Why B-Tree suffix truncation matters) Tom Lane 22:10
Bug in gin insert redo code path during re-compression of empty gin data leaf pages 📎 R, Siva 22:40
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Konstantin Knizhnik 22:41
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) 📎 Fabien COELHO 22:43
Re: Fix some error handling for read() and errno Michael Paquier 23:07
Re: "Write amplification" is made worse by "getting tired" while inserting into nbtree secondary indexes (Was: Why B-Tree suffix truncation matters) Peter Geoghegan 23:39
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Tomas Vondra 23:58

July 18, 2018

Thread Author Time
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" 📎 Tom Lane 00:01
Re: Another usability issue with our TAP tests 📎 Michael Paquier 00:30
Re: "Write amplification" is made worse by "getting tired" while inserting into nbtree secondary indexes (Was: Why B-Tree suffix truncation matters) Robert Haas 00:45
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" Robert Haas 00:52
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" Tom Lane 00:55
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" Robert Haas 00:59
Re: patch to allow disable of WAL recycling Robert Haas 01:01
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" Tom Lane 01:11
Re: PG 10: could not generate random cancel key Michael Paquier 01:57
Re: [HACKERS] PATCH: Keep one postmaster monitoring pipe per process 📎 Thomas Munro 02:02
Re: PG 10: could not generate random cancel key Michael Paquier 02:17
Re: "Write amplification" is made worse by "getting tired" while inserting into nbtree secondary indexes (Was: Why B-Tree suffix truncation matters) Peter Geoghegan 02:23
Re: [bug fix] Produce a crash dump before main() on Windows Craig Ringer 03:12
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" Kyotaro HORIGUCHI 03:42
Re: missing toast table for pg_policy 📎 Michael Paquier 04:02
Re: AtEOXact_ApplyLauncher() and subtransactions Amit Khandekar 04:07
Re: [bug fix] Produce a crash dump before main() on Windows Kyotaro HORIGUCHI 04:10
Re: Make foo=null a warning by default. 📎 David Fetter 04:11
More consistency for some file-related error message 📎 Michael Paquier 04:47
Re: GSOC 2018 Project - A New Sorting Routine Andrey Borodin 05:06
print_path is missing GatherMerge and CustomScan support 📎 Masahiko Sawada 05:35
Re: [Patch] Checksums for SLRU files Andrey Borodin 05:41
Re: "Write amplification" is made worse by "getting tired" while inserting into nbtree secondary indexes (Was: Why B-Tree suffix truncation matters) Simon Riggs 05:42
Re: [Patch] Checksums for SLRU files Thomas Munro 05:54
RE: [bug fix] Produce a crash dump before main() on Windows Tsunakawa, Takayuki 06:09

Browse Archives

Prev | Next