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

Thread Author Time
Re: no partition pruning when partitioning using array type Alvaro Herrera 00:19
Re: peripatus build failures.... Larry Rosenman 00:53
Re: Explain buffers wrong counter with parallel plans Amit Kapila 02:15
Transition relations: correlating OLD TABLE and NEW TABLE Brent Kerby 03:03
Re: Transition relations: correlating OLD TABLE and NEW TABLE David G. Johnston 03:36
Re: Explain buffers wrong counter with parallel plans 📎 Amit Kapila 04:03
Re: EXPLAIN of Parallel Append Amit Kapila 05:08
Re: Constraint documentation Fabien COELHO 08:23
Re: Desirability of client-side expressions in psql? Fabien COELHO 08:31
Re: setproctitle_fast() Emre Hasegeli 11:57
Re: Transition relations: correlating OLD TABLE and NEW TABLE Brent Kerby 12:05
Re: setproctitle_fast() Thomas Munro 13:11
Re: Desirability of client-side expressions in psql? Stephen Frost 14:31
Re: peripatus build failures.... Tom Lane 15:11
Re: Transition relations: correlating OLD TABLE and NEW TABLE David G. Johnston 15:16
Re: peripatus build failures.... Larry Rosenman 15:20
Re: peripatus build failures.... Tom Lane 15:24
Re: peripatus build failures.... Larry Rosenman 16:05
Re: How can we submit code patches that implement our (pending) patents? David Fetter 17:12
Re: How can we submit code patches that implement our (pending) patents? Andres Freund 17:20
Re: How can we submit code patches that implement our (pending) patents? David Fetter 17:37
Re: How can we submit code patches that implement our (pending) patents? Andres Freund 18:05
Re: Make deparsing of column defaults faster Jeff Janes 18:07
Re: peripatus build failures.... Tom Lane 18:28
Re: peripatus build failures.... Larry Rosenman 18:33
Re: peripatus build failures.... Larry Rosenman 18:37
Re: peripatus build failures.... Tom Lane 18:47
Re: How can we submit code patches that implement our (pending) patents? David Fetter 18:51
Re: How can we submit code patches that implement our (pending) patents? Andres Freund 19:01
Re: wrong query result with jit_above_cost= 0 📎 Dmitry Dolgov 19:41
Re: How can we submit code patches that implement our (pending) patents? David Fetter 19:52
Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM) 📎 Andres Freund 20:01
Re: [HACKERS] Bug in to_timestamp(). Alexander Korotkov 21:15
Re: WAL prefetch 📎 Tomas Vondra 21:47

July 8, 2018

Thread Author Time
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Haribabu Kommi 02:48
Re: Desirability of client-side expressions in psql? Fabien COELHO 07:28
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Fabien COELHO 08:39
Re: [PATCH] Use access() to check file existence in GetNewRelFileNode(). Michael Paquier 10:00
Re: Invisible Indexes Jeff Janes 14:52
pglife and devel branch content Bruce Momjian 15:23
Re: How can we submit code patches that implement our (pending) patents? Alvaro Herrera 15:46
Re: How can we submit code patches that implement our (pending) patents? Andres Freund 17:43
XLogSegNoOffsetToRecPtr fixup 📎 Alvaro Herrera 18:23
Re: XLogSegNoOffsetToRecPtr fixup Andres Freund 18:27
Re: hot_standby_feedback vs excludeVacuum and snapshots Noah Misch 18:51
Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated with wrong context 📎 Markus Winand 19:15
Re: pgsql: Add wait event for fsync of WAL segments 📎 Julien Rouhaud 20:23
Re: cost_sort() improvements Tomas Vondra 21:59
Re: cost_sort() improvements Tomas Vondra 23:22
"Write amplification" is made worse by "getting tired" while inserting into nbtree secondary indexes (Was: Why B-Tree suffix truncation matters) 📎 Peter Geoghegan 23:59

July 9, 2018

Thread Author Time
Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw Jeff Davis 00:00
Re: WAL prefetch Sean Chittenden 00:26
Re: Copy function for logical replication slots Masahiko Sawada 01:06
Re: Failure assertion in GROUPS mode of window function in current HEAD Masahiko Sawada 01:15
Re: [HACKERS] Secondary index access optimizations 📎 David Rowley 01:26
Re: [HACKERS] Crash on promotion when recovery.conf is renamed Michael Paquier 01:29
Re: Copy function for logical replication slots Michael Paquier 01:34
[GSoC] working status Charles Cui 01:38
Re: pgsql: Add wait event for fsync of WAL segments Michael Paquier 01:47
Re: Let's remove DSM_IMPL_NONE. Michael Paquier 01:49
Re: no partition pruning when partitioning using array type Amit Langote 01:59
Re: Typo in Japanese translation of psql. Michael Paquier 01:59
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Michael Paquier 02:24
Re: no partition pruning when partitioning using array type 📎 Amit Langote 02:48
RE: Locking B-tree leafs immediately in exclusive mode Imai, Yoshikazu 03:18
Incorrect error handling for two-phase state files resulting in data loss 📎 Michael Paquier 05:03
Re: Postgres 11 release notes Tatsuro Yamada 05:18
Re: Non-reserved replication slots and slot advancing 📎 Michael Paquier 05:18
Re: Postgres 11 release notes Andres Freund 05:28
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query 📎 Haribabu Kommi 05:39
Re: [HACKERS] Restricting maximum keep segments by repslots 📎 Kyotaro HORIGUCHI 05:47
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query 📎 Haribabu Kommi 05:57
Re: Non-reserved replication slots and slot advancing Kyotaro HORIGUCHI 06:13
Re: How can we submit code patches that implement our (pending) patents? Markus Wanner 06:19
Re: Non-reserved replication slots and slot advancing 📎 Michael Paquier 06:48
Re: Possible bug in logical replication. 📎 Michael Paquier 07:02
RE: Typo in Japanese translation of psql. Taiki Kondo 07:09
Re: Generating partitioning tuple conversion maps faster 📎 David Rowley 07:13
Re: Possible bug in logical replication. Arseny Sher 07:15
Re: Flexible configuration for full-text search 📎 Aleksandr Parfenov 07:25
RE: How can we submit code patches that implement our (pending) patents? Tsunakawa, Takayuki 07:51
Re: Range phrase operator in tsquery 📎 Aleksandr Parfenov 08:09
Re: How can we submit code patches that implement our (pending) patents? Craig Ringer 08:09
Re: [HACKERS] Replication status in logical replication Masahiko Sawada 08:25
RE: How can we submit code patches that implement our (pending) patents? Tsunakawa, Takayuki 08:29
Re: Let's remove DSM_IMPL_NONE. 📎 Kyotaro HORIGUCHI 09:07
Re: Subplan result caching David Rowley 09:08
Re: Non-reserved replication slots and slot advancing Kyotaro HORIGUCHI 09:14
Re: Let's remove DSM_IMPL_NONE. Arthur Zakirov 09:30
How to set array element to null value Brahmam Eswar 09:58
Re: WAL prefetch Tomas Vondra 09:59
Allowing multiple DDL commands to run simultaneously Simon Riggs 10:00
Re: How to set array element to null value Pavel Stehule 10:26
Re: How to set array element to null value Thomas Kellerer 10:29
Re: How can we submit code patches that implement our (pending) patents? Nico Williams 10:47
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 11:03
Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw Etsuro Fujita 11:05
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Ashutosh Bapat 11:06
Re: How can we submit code patches that implement our (pending) patents? Nico Williams 11:09
Re: How can we submit code patches that implement our (pending) patents? Nico Williams 11:20
Re: Generating partitioning tuple conversion maps faster Alexander Kuzmenkov 11:28
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 11:35
Re: Concurrency bug in UPDATE of partition-key Amit Kapila 11:36
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Ashutosh Bapat 11:43
Re: [GSoC] working status Aleksander Alekseeev 11:57
Re: [GSoC] working status Aleksander Alekseeev 12:16
Re: [GSoC] working status Aleksander Alekseeev 12:22
Re: missing toast table for pg_policy Peter Eisentraut 12:45
Un peu décu : Re: Performance regression with PostgreSQL 11 and partitioning Christophe Courtois 12:47
Re: How can we submit code patches that implement our (pending) patents? David Fetter 12:52
Oops... Re: Un peu décu : Re: Performance regression with PostgreSQL 11 and partitioning Christophe Courtois 12:59
Re: How to set array element to null value David Fetter 13:01
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Fabien COELHO 13:05
Re: [HACKERS] PoC: full merge join on comparison clause Ashutosh Bapat 13:12
Re: EXPLAIN of Parallel Append 📎 Jesper Pedersen 13:30
Re: Simplify final sync in pg_rewind's target folder and add --no-sync Heikki Linnakangas 13:38
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Heikki Linnakangas 13:49
cannot restore schema with is not distinct from on hstore since PG 9.6.8 Marc Cousin 13:52
LLVM jit and matview Dmitry Dolgov 14:04
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Fujii Masao 14:26
Re: Postgres 11 release notes Bruce Momjian 14:36
Re: Postgres 11 release notes David Fetter 14:52
Re: [GSoC] working status Charles Cui 14:54
Re: pgsql: Add wait event for fsync of WAL segments Tom Lane 15:16
Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10)) Bruce Momjian 15:19
Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 Tom Lane 15:34
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Simon Riggs 15:57
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Heikki Linnakangas 15:59
Re: Locking B-tree leafs immediately in exclusive mode Alexander Korotkov 16:43
Re: Locking B-tree leafs immediately in exclusive mode Peter Geoghegan 17:17
Re: Locking B-tree leafs immediately in exclusive mode Simon Riggs 17:25
Re: [PATCH] btree_gist: fix union implementation for variable length columns Tom Lane 17:41
Re: [HACKERS] [PATCH] kNN for SP-GiST Andrey Borodin 17:47
Re: How can we submit code patches that implement our (pending) patents? Andres Freund 18:24
Re: pgsql: Add wait event for fsync of WAL segments Alvaro Herrera 18:24
Re: WAL prefetch Andres Freund 18:28
Re: Proposed fix for Bug #15259 (invalid empty array returned by intarray "&" operator) Tom Lane 18:28
Re: [HACKERS] PoC: full merge join on comparison clause Alexander Kuzmenkov 18:35
Re: Non-reserved replication slots and slot advancing Andres Freund 18:39
Re: Non-reserved replication slots and slot advancing Alvaro Herrera 18:48
Re: no partition pruning when partitioning using array type Alvaro Herrera 18:57
Re: pgsql: Add wait event for fsync of WAL segments Peter Geoghegan 19:12
Re: [PATCH] Improve geometric types Tomas Vondra 19:21
Re: [HACKERS] plpgsql - additional extra checks Tomas Vondra 19:25
Re: [HACKERS] plpgsql - additional extra checks Alvaro Herrera 19:44
Re: [HACKERS] plpgsql - additional extra checks Andres Freund 19:51
Re: Generating partitioning tuple conversion maps faster David Rowley 19:58
Re: [HACKERS] plpgsql - additional extra checks Alvaro Herrera 20:01
Re: Un peu décu : Re: Performance regression with PostgreSQL 11 and partitioning David Rowley 20:10
Re: How can we submit code patches that implement our (pending) patents? Markus Wanner 20:38
Re: pgsql: Fix crash when ALTER TABLE recreates indexes on partitions Andres Freund 20:39
Re: no partition pruning when partitioning using array type Tom Lane 20:53
Re: peripatus build failures.... Tom Lane 21:25
Re: peripatus build failures.... Larry Rosenman 21:30
Re: WAL prefetch Konstantin Knizhnik 21:35
Re: [PATCH] Improve geometric types Thomas Munro 21:38
Re: pgsql: Add wait event for fsync of WAL segments Michael Paquier 21:41
Re: no partition pruning when partitioning using array type 📎 Alvaro Herrera 21:46
Re: no partition pruning when partitioning using array type Tom Lane 21:59
Re: WAL prefetch Konstantin Knizhnik 22:02
Re: Locking B-tree leafs immediately in exclusive mode Alexander Korotkov 22:23
Re: Failure assertion in GROUPS mode of window function in current HEAD Tom Lane 22:24
Re: Locking B-tree leafs immediately in exclusive mode Peter Geoghegan 22:49
Re: [HACKERS] Clock with Adaptive Replacement Peter Geoghegan 23:24
Re: [HACKERS] Possibly too stringent Assert() in b-tree code Tom Lane 23:29
Re: Usage of epoch in txid_current 📎 Thomas Munro 23:35
small development tip: Consider using the gold linker Andres Freund 23:40
Re: Usage of epoch in txid_current Andres Freund 23:43
Costing bug in hash join logic for semi joins RK 23:44
Re: Usage of epoch in txid_current Tom Lane 23:56

July 10, 2018

Thread Author Time
Re: Simplify final sync in pg_rewind's target folder and add --no-sync Michael Paquier 00:04
Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 Andrew Dunstan 00:06
Re: Usage of epoch in txid_current Andres Freund 00:08
Re: LLVM jit and matview Michael Paquier 00:19
Re: Usage of epoch in txid_current Andres Freund 00:52
Re: Non-reserved replication slots and slot advancing 📎 Michael Paquier 00:54
Re: Postgres 11 release notes Tatsuro Yamada 01:09
Re: [HACKERS] Replication status in logical replication Michael Paquier 01:14
Re: missing toast table for pg_policy Michael Paquier 01:16
Re: Postgres 11 release notes Andres Freund 01:17
Re: missing toast table for pg_policy Joe Conway 01:19
Re: Usage of epoch in txid_current 📎 Thomas Munro 01:20
Re: missing toast table for pg_policy Michael Paquier 01:29
Re: Usage of epoch in txid_current Andres Freund 01:30
[PATCH] Timestamp for a XLOG_BACKUP_END WAL-record 📎 Andrey V. Lepikhov 01:41
Extension relocation vs. schema qualification Noah Misch 01:43
Re: [PATCH] Timestamp for a XLOG_BACKUP_END WAL-record Andres Freund 01:45
Re: Usage of epoch in txid_current 📎 Thomas Munro 02:15
Re: Usage of epoch in txid_current Craig Ringer 02:32
Re: Usage of epoch in txid_current Craig Ringer 02:33
Re: Usage of epoch in txid_current Andres Freund 02:40
Re: Failure assertion in GROUPS mode of window function in current HEAD Masahiko Sawada 03:03
Re: Usage of epoch in txid_current Craig Ringer 03:32
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 03:38
Re: Usage of epoch in txid_current 📎 Thomas Munro 04:20
Re: Recovery performance of DROP DATABASE with many tablespaces Michael Paquier 06:04
Re: Let's remove DSM_IMPL_NONE. 📎 Kyotaro HORIGUCHI 06:49
Re: Performance regression with PostgreSQL 11 and partitioning Christophe Courtois 06:57
Recovery performance of standby for multiple concurrent truncates on large tables Jamison, Kirk 07:05
Re: Recovery performance of standby for multiple concurrent truncates on large tables Andres Freund 07:14

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