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

April 17, 2018

Thread Author Time
Re: [HACKERS] Runtime Partition Pruning David Rowley 00:11
Re: Oddity in tuple routing for foreign partitions Amit Langote 01:10
Re: Oddity in tuple routing for foreign partitions Etsuro Fujita 01:59
Re: Oddity in tuple routing for foreign partitions Kyotaro HORIGUCHI 02:13
Re: Overcoming SELECT ... FOR UPDATE permission restrictions Michael Paquier 02:18
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera 02:33
Re: [HACKERS] Runtime Partition Pruning 📎 David Rowley 02:46
Re: Overcoming SELECT ... FOR UPDATE permission restrictions Tom Lane 02:49
Re: Proposal: Adding json logging Michael Paquier 03:12
Re: Fix slot's xmin advancement and subxact's lost snapshots in decoding. Michael Paquier 03:17
Re: SHOW ALL does not honor pg_read_all_settings membership Michael Paquier 03:28
pg_recvlogical broken in back branches 📎 Euler Taveira 06:01
Re: pg_recvlogical broken in back branches Michael Paquier 06:38
Re: Oddity in tuple routing for foreign partitions Amit Langote 07:10
Re: Oddity in tuple routing for foreign partitions Etsuro Fujita 07:41
Re: Built-in connection pooling Konstantin Knizhnik 07:44
Re: ON CONFLICT DO UPDATE for partitioned tables 📎 Amit Langote 07:45
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 08:35
Re: Standby corruption after master is restarted Emre Hasegeli 08:55
Re: ON CONFLICT DO UPDATE for partitioned tables 📎 Amit Langote 09:00
BUG #15160: planner overestimates number of rows in join when there are more than 200 rows coming from CTE PG Bug reporting form 09:40
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. 📎 Ashutosh Bapat 09:43
Test coverage for mark_invalid_subplans_as_finished 📎 David Rowley 09:46
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 10:00
Re: WIP: Covering + unique indexes. Alexander Korotkov 10:12
Re: pg_recvlogical broken in back branches Euler Taveira 11:07
Re: Proposal: Adding json logging Peter Eisentraut 11:16
Re: Proposal: Adding json logging Daniel Verite 11:55
remove quoting hacks and simplify bootscanner.l 📎 John Naylor 12:10
Re: Standby corruption after master is restarted Tomas Vondra 12:11
Re: Proposal: Adding json logging David Arnold 12:31
Re: Proposal: Adding json logging David Arnold 14:06
Re: [HACKERS] proposal: schema variables Arthur Zakirov 14:14
Re: BUG #15160: planner overestimates number of rows in join when there are more than 200 rows coming from CTE Tom Lane 14:15
Re: Proposal: Adding json logging Alvaro Herrera 14:26
Re: ON CONFLICT DO UPDATE for partitioned tables Alvaro Herrera 15:02
Re: ON CONFLICT DO UPDATE for partitioned tables Alvaro Herrera 15:04
Re: Standby corruption after master is restarted Emre Hasegeli 15:14
Re: Test coverage for mark_invalid_subplans_as_finished Alvaro Herrera 15:30
Re: Proposal: Adding json logging David Arnold 15:45
Re: Speedup of relation deletes during recovery 📎 Fujii Masao 15:46
Re: Typos from Covering Index patch Heikki Linnakangas 15:57
Re: Typos from Covering Index patch Heikki Linnakangas 15:57
Re: Sample values for pg_stat_statements 📎 Vik Fearing 15:58
Re: Speedup of relation deletes during recovery Fujii Masao 16:12
Re: Deadlock in multiple CIC. 📎 Tom Lane 16:23
Re: [HACKERS] proposal: schema variables Pavel Stehule 16:28
Re: WIP: Covering + unique indexes. Peter Geoghegan 16:45
[ANN] PG-Strom v2.0 is released Kohei KaiGai 16:56
pgindent run soon? Tom Lane 16:57
Re: Built-in connection pooling Nikolay Samokhvalov 17:09
Re: WIP: a way forward on bootstrap data 📎 John Naylor 17:23
reloption to prevent VACUUM from truncating empty pages at the end of relation Fujii Masao 17:35
Re: WIP: a way forward on bootstrap data Tom Lane 17:54
Re: remove quoting hacks and simplify bootscanner.l Tom Lane 18:01
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Tom Lane 18:09
Re: Deadlock in multiple CIC. Alvaro Herrera 18:13
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Peter Geoghegan 18:13
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Alvaro Herrera 18:18
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Tom Lane 19:09
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Andres Freund 19:12
Re: pgsql: Support partition pruning at execution time Alvaro Herrera 19:26
Re: Gotchas about pg_verify_checksums Michael Banck 19:43
Append's first_partial_plan Alvaro Herrera 19:52
Re: Setting rpath on llvmjit.so? Robert Haas 19:56
Repeated crashes in GENERATED ... AS IDENTITY tests Tom Lane 19:59
Re: Setting rpath on llvmjit.so? Tom Lane 20:01
Re: Setting rpath on llvmjit.so? Andres Freund 20:13
Re: Setting rpath on llvmjit.so? Andres Freund 20:14
Re: pgsql: Store 2PC GID in commit/abort WAL recs for logical decoding Heikki Linnakangas 20:15
Re: partitioning code reorganization Alvaro Herrera 20:18
Re: [sqlsmith] Unpinning error in parallel worker Jonathan Rudenberg 20:52
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Bruce Momjian 21:19
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Bruce Momjian 21:29
Re: Append's first_partial_plan David Rowley 21:30
Re: pgsql: Support partition pruning at execution time David Rowley 21:30
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Bruce Momjian 21:32
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Andres Freund 21:34
Re: Append's first_partial_plan Alvaro Herrera 21:40
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Andres Freund 21:41
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Bruce Momjian 21:49
Re: pruning disabled for array, enum, record, range type partition keys 📎 Alvaro Herrera 22:11
Re: [sqlsmith] Unpinning error in parallel worker Thomas Munro 22:38
Re: [sqlsmith] Unpinning error in parallel worker 📎 Jonathan Rudenberg 23:01
Re: [sqlsmith] Unpinning error in parallel worker Thomas Munro 23:31
Re: [sqlsmith] Unpinning error in parallel worker 📎 Jonathan Rudenberg 23:43

April 18, 2018

Thread Author Time
Should we add GUCs to allow partition pruning to be disabled? David Rowley 00:07
Re: Gotchas about pg_verify_checksums Michael Paquier 00:09
Re: Typos from Covering Index patch Michael Paquier 00:14
Re: Should we add GUCs to allow partition pruning to be disabled? Justin Pryzby 00:42
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Michael Paquier 01:00
Re: Should we add GUCs to allow partition pruning to be disabled? David G. Johnston 01:03
Re: Should we add GUCs to allow partition pruning to be disabled? David Rowley 01:12
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Andres Freund 01:13
Re: Speedup of relation deletes during recovery Michael Paquier 01:44
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Michael Paquier 01:46
Re: Should we add GUCs to allow partition pruning to be disabled? David G. Johnston 01:47
VM map freeze corruption Wood, Dan 02:07
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Andres Freund 02:16
Re: pruning disabled for array, enum, record, range type partition keys 📎 Amit Langote 02:52
Re: Problem while updating a foreign table pointing to a partitioned table on foreign server 📎 Kyotaro HORIGUCHI 04:13
Re: ON CONFLICT DO UPDATE for partitioned tables Amit Langote 04:13
Re: ON CONFLICT DO UPDATE for partitioned tables 📎 Amit Langote 04:35
Re: Excessive PostmasterIsAlive calls slow down WAL redo 📎 Thomas Munro 05:04
Re: Oddity in tuple routing for foreign partitions Amit Langote 05:44
Double-writes, take two? Michael Paquier 06:22
Re: Bugs in TOAST handling, OID assignment and redo recovery Pavan Deolasee 06:37
Re: [HACKERS] PATCH: Keep one postmaster monitoring pipe per process 📎 Thomas Munro 06:55
Re: Problem while updating a foreign table pointing to a partitioned table on foreign server 📎 Ashutosh Bapat 07:53
Re: Should we add GUCs to allow partition pruning to be disabled? Ashutosh Bapat 09:36
Re: Double-writes, take two? Fabien COELHO 09:40
Re: Fix for documentation of Covering Indexes Heikki Linnakangas 09:52
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Bruce Momjian 09:52
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Craig Ringer 10:04
Re: Built-in connection pooling Konstantin Knizhnik 10:10
Re: Setting rpath on llvmjit.so? Yuriy Zhuravlev 10:16
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Craig Ringer 10:19
Re: Boolean partitions syntax 📎 Amit Langote 10:27
de-deduplicate code in DML execution hooks in postgres_fdw 📎 Ashutosh Bapat 10:34
Re: Built-in connection pooling Heikki Linnakangas 10:36
Re: VM map freeze corruption Pavan Deolasee 10:49
hostorder and failover_timeout for libpq 📎 Ildar Musin 11:34
Re: [HACKERS] proposal: schema variables Arthur Zakirov 11:37
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Bruce Momjian 11:46
Re: Built-in connection pooling Konstantin Knizhnik 11:52
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 11:54
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS 📎 Bruce Momjian 11:56
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Craig Ringer 12:45
Re: Oddity in tuple routing for foreign partitions 📎 Etsuro Fujita 12:55
Re: Built-in connection pooling Craig Ringer 13:09
Re: Built-in connection pooling David Fetter 13:24
Re: Built-in connection pooling Konstantin Knizhnik 13:31
Re: Built-in connection pooling Konstantin Knizhnik 13:36
Re: VM map freeze corruption 📎 Alvaro Herrera 13:36
Re: ON CONFLICT DO UPDATE for partitioned tables Alvaro Herrera 13:40
Re: Built-in connection pooling Heikki Linnakangas 13:41
Re: Built-in connection pooling Konstantin Knizhnik 13:46
Re: Postgres stucks in deadlock detection 📎 Konstantin Knizhnik 14:08
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Amit Kapila 14:11
Re: Built-in connection pooling Vladimir Borodin 14:13
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Pavan Deolasee 14:29
Re: remove quoting hacks and simplify bootscanner.l Tom Lane 14:30
Re: Documentation for bootstrap data conversion Tom Lane 14:34
Re: Setting rpath on llvmjit.so? Peter Eisentraut 14:35
Re: Problem while setting the fpw with SIGHUP Amit Kapila 14:37
Re: Problem while setting the fpw with SIGHUP Robert Haas 14:52
Re: Setting rpath on llvmjit.so? Robert Haas 14:57
Re: Setting rpath on llvmjit.so? Tom Lane 14:57
Re: pruning disabled for array, enum, record, range type partition keys Alvaro Herrera 15:01
Re: pruning disabled for array, enum, record, range type partition keys Amit Langote 15:09
Re: [HACKERS] Runtime Partition Pruning Robert Haas 15:13
Re: pgindent run soon? Robert Haas 15:20
Re: Deadlock in multiple CIC. Tom Lane 15:27
Query is over 2x slower with jit=on Andreas Joseph Krogh 15:35
Re: Deadlock in multiple CIC. Alvaro Herrera 15:36
Re: Deadlock in multiple CIC. Tom Lane 15:38
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Simon Riggs 15:44
Re: [FEATURE PATCH] pg_stat_statements with plans (v02) Julian Markwort 15:48
Re: Query is over 2x slower with jit=on Andres Freund 15:50
Re: Setting rpath on llvmjit.so? Yuriy Zhuravlev 15:54
Re: Setting rpath on llvmjit.so? Andres Freund 15:58
Re: Setting rpath on llvmjit.so? Yuriy Zhuravlev 16:00
Re: Setting rpath on llvmjit.so? Yuriy Zhuravlev 16:03
Sv: Re: Query is over 2x slower with jit=on Andreas Joseph Krogh 16:26
Re: Query is over 2x slower with jit=on Simon Riggs 16:27
Re: Deadlock in multiple CIC. Alvaro Herrera 16:36
Re: Query is over 2x slower with jit=on Chapman Flack 16:50
Re: Speedup of relation deletes during recovery Fujii Masao 16:52
Re: Query is over 2x slower with jit=on Andres Freund 17:02
Re: WIP: Covering + unique indexes. 📎 Teodor Sigaev 17:10
Re: pgindent run soon? Teodor Sigaev 17:14
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Fujii Masao 17:20
Re: pgindent run soon? Tom Lane 17:25
Re: WIP: Covering + unique indexes. Peter Geoghegan 17:32
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Pavan Deolasee 17:42
Truncation failure in autovacuum results in data corruption (duplicate keys) MauMau 18:03
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Tom Lane 18:13
Re: Deadlock in multiple CIC. Tom Lane 18:34
Re: Proposal: Adding json logging Robert Haas 18:59
Re: Truncation failure in autovacuum results in data corruption (duplicate keys) Tom Lane 19:03
Re: Proposal: Adding json logging Christophe Pettus 19:10
Re: Query is over 2x slower with jit=on Robert Haas 19:16
Re: Query is over 2x slower with jit=on Andres Freund 19:29
Re: Proposal: Adding json logging David Arnold 19:32
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Tom Lane 19:33
Re: Proposal: Adding json logging Alvaro Herrera 19:54
Re: Truncation failure in autovacuum results in data corruption (duplicate keys) MauMau 19:59
Re: Truncation failure in autovacuum results in data corruption (duplicate keys) Tom Lane 20:09
Re: WIP: Covering + unique indexes. 📎 Teodor Sigaev 20:32
Re: WIP: Covering + unique indexes. Peter Geoghegan 20:45
Re: Truncation failure in autovacuum results in data corruption (duplicate keys) Tom Lane 20:49
Re: Should we add GUCs to allow partition pruning to be disabled? David Rowley 21:24
Re: pruning disabled for array, enum, record, range type partition keys 📎 Alvaro Herrera 21:45
Re: WIP: Covering + unique indexes. Peter Geoghegan 22:04
Re: Query is over 2x slower with jit=on Robert Haas 22:37
Re: pruning disabled for array, enum, record, range type partition keys Tom Lane 22:56
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Mark Kirkwood 23:31
Adding an LWLockHeldByMe()-like function that reports if any buffer content lock is held Peter Geoghegan 23:53

April 19, 2018

Thread Author Time
Re: [HACKERS] Runtime Partition Pruning 📎 David Rowley 00:04
Re: [HACKERS] Runtime Partition Pruning David Rowley 00:05

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