pgsql-hackers since 2018-07-17 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

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
Re: print_path is missing GatherMerge and CustomScan support Michael Paquier 06:22
Re: [bug fix] Produce a crash dump before main() on Windows Michael Paquier 06:34
Re: print_path is missing GatherMerge and CustomScan support Ashutosh Bapat 06:45
Re: print_path is missing GatherMerge and CustomScan support Michael Paquier 06:55
Re: [bug fix] Produce a crash dump before main() on Windows Craig Ringer 07:17
Add constraint in a Materialized View Kaye Ann Ignacio 07:28
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Konstantin Knizhnik 07:32
RE: Temporary tables prevent autovacuum, leading to XID wraparound Tsunakawa, Takayuki 07:34
Re: [bug fix] Produce a crash dump before main() on Windows Haribabu Kommi 07:37
Re: missing toast table for pg_policy John Naylor 08:13
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Heikki Linnakangas 08:16
Re: Incorrect error handling for two-phase state files resulting in data loss 📎 Michael Paquier 08:18
Re: cursors with prepared statements Heikki Linnakangas 08:26
Re: Speeding up INSERTs and UPDATEs to partitioned tables 📎 Amit Langote 08:29
Re: [HACKERS] PATCH: Keep one postmaster monitoring pipe per process Kyotaro HORIGUCHI 08:30
RE: [bug fix] Produce a crash dump before main() on Windows Tsunakawa, Takayuki 08:38
Re: Bug in gin insert redo code path during re-compression of empty gin data leaf pages Alexander Korotkov 08:59
Re: why partition pruning doesn't work? Amit Langote 08:59
Re: PG 10: could not generate random cancel key 📎 Dean Rasheed 09:14
Re: Alter index rename concurrently to Peter Eisentraut 09:20
Re: documentation about explicit locking Peter Eisentraut 09:30
RE: Speeding up INSERTs and UPDATEs to partitioned tables Kato, Sho 09:44
Re[2]: Alter index rename concurrently to Andrey Klychkov 09:44
Re: Speeding up INSERTs and UPDATEs to partitioned tables David Rowley 10:23
Re: untrusted PLs should be GRANTable Robert Haas 10:36
Re: [HACKERS] WAL logging problem in 9.4.3? Robert Haas 10:42
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. 📎 Etsuro Fujita 12:00
Re: GiST VACUUM Heikki Linnakangas 12:02
Re: Make foo=null a warning by default. Fabien COELHO 12:25
Re: Libpq support to connect to standby server as priority Robert Haas 12:53
Re: PG 10: could not generate random cancel key 📎 Michael Paquier 13:01
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) 📎 Fabien COELHO 13:01
Re: [HACKERS] WAL logging problem in 9.4.3? Michael Paquier 13:06
Re: PG 10: could not generate random cancel key Dean Rasheed 13:07
Re: [HACKERS] WAL logging problem in 9.4.3? Robert Haas 13:29
Re: Alter index rename concurrently to Peter Eisentraut 13:32
Re: why partition pruning doesn't work? Tom Lane 13:32
Re: [HACKERS] PoC: full merge join on comparison clause Ashutosh Bapat 13:58
Re: [HACKERS] logical decoding of two-phase transactions Tomas Vondra 14:08
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" Tom Lane 14:33
Re: Segfault logical replication PG 10.4 Mai Peng 14:35
Re: partition tree inspection functions Jesper Pedersen 14:35
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Heikki Linnakangas 14:44
Re: [HACKERS] logical decoding of two-phase transactions Robert Haas 14:56
Re: More consistency for some file-related error message Tom Lane 14:57
Re: [HACKERS] WAL logging problem in 9.4.3? Heikki Linnakangas 14:58
Re: Segfault logical replication PG 10.4 Tom Lane 15:03
Re: Make foo=null a warning by default. 📎 David Fetter 15:21
Re: [HACKERS] logical decoding of two-phase transactions Tomas Vondra 15:27
One transaction and several processes Valery Kuzmin 15:31
Re: One transaction and several processes Tomas Vondra 15:40
Re: One transaction and several processes David G. Johnston 15:41
Re: Add SKIP LOCKED to VACUUM and ANALYZE Bossart, Nathan 16:58
Re: [HACKERS] logical decoding of two-phase transactions Robert Haas 16:59
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" Robert Haas 17:03
Have an encrypted pgpass file 📎 Marco van Eck 17:46
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" Tom Lane 18:05
Re: Subplan result caching Robert Haas 18:27
Re: GiST VACUUM 📎 Andrey Borodin 18:27
Re: Possible bug in logical replication. 📎 Alvaro Herrera 18:30
Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM) Robert Haas 18:34
Background worker/idle sessions and caching Jeremy Finzel 18:37
Re: [PG-11] Potential bug related to INCLUDE clause of CREATE INDEX Tom Lane 18:44
Re: patch to allow disable of WAL recycling 📎 Jerry Jelinek 19:22
Re: Postgres, fsync, and OSs (specifically linux) Robert Haas 19:23
Re: patch to allow disable of WAL recycling Robert Haas 19:43
Re: patch to allow disable of WAL recycling Robert Haas 19:45
psql's \d versus included-index-column feature 📎 Tom Lane 19:55
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Fabien COELHO 19:56
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Heikki Linnakangas 20:04
Re: Background worker/idle sessions and caching Tom Lane 20:05
Re: psql's \d versus included-index-column feature David G. Johnston 20:14
Re: Make foo=null a warning by default. Fabien COELHO 20:15
Re: psql's \d versus included-index-column feature Alvaro Herrera 20:26
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Fabien COELHO 20:29
Re: Background worker/idle sessions and caching Jeremy Finzel 20:30
Re: psql's \d versus included-index-column feature Tom Lane 20:46
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) 📎 Heikki Linnakangas 21:03
Re: psql's \d versus included-index-column feature Alvaro Herrera 21:05
Re: GiST VACUUM Heikki Linnakangas 21:12
RE: GSOC 2018 Project - A New Sorting Routine Kefan Yang 21:13
Re: GSOC 2018 Project - A New Sorting Routine Tomas Vondra 21:26
Re: Have an encrypted pgpass file Thomas Munro 21:33
Re: Have an encrypted pgpass file Christophe Pettus 21:37
Re: YA race condition in 001_stream_rep.pl (was Re: pgsql: Allow using the updated tuple while moving it to a different par) Tom Lane 21:42
Re: Have an encrypted pgpass file Tom Lane 21:52
Re: GSOC 2018 Project - A New Sorting Routine Alvaro Herrera 22:13
Re: Have an encrypted pgpass file Thomas Munro 22:18
Re: psql's \d versus included-index-column feature Alexander Korotkov 23:11
Re: Have an encrypted pgpass file Alvaro Herrera 23:16
Re: Postgres, fsync, and OSs (specifically linux) Thomas Munro 23:21
Re: Have an encrypted pgpass file Tom Lane 23:25

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31