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

July 6, 2018

Thread	Author	Time
Re: [HACKERS] Optional message to user when terminating/cancelling backend	Thomas Munro	00:18
Re: Copy function for logical replication slots	Michael Paquier	00:21
Re: Why B-Tree suffix truncation matters	Peter Geoghegan	00:26
RE: Global shared meta cache	Ideriha, Takeshi	01:30
Re: Should contrib modules install .h files?	Michael Paquier	01:42
Re: Should contrib modules install .h files?	Michael Paquier	01:45
Re: [HACKERS] Optional message to user when terminating/cancelling backend	Michael Paquier	01:47
Re: documentation fixes for partition pruning, round three	Amit Langote	01:49
Re: Global shared meta cache	Amit Langote	01:52
Re: documentation about explicit locking 📎	Amit Langote	02:00
Re: hot_standby_feedback vs excludeVacuum and snapshots	Thomas Munro	02:30
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled.	Etsuro Fujita	03:40
Re: Non-reserved replication slots and slot advancing	Kyotaro HORIGUCHI	04:07
Re: Legacy GiST invalid tuples	Tom Lane	04:09
Re: [HACKERS] Replication status in logical replication 📎	Michael Paquier	05:21
Re: using expression syntax for partition bounds 📎	Kyotaro HORIGUCHI	05:26
Re: Non-reserved replication slots and slot advancing	Michael Paquier	05:26
Re: using expression syntax for partition bounds	Amit Langote	05:33
Re: Test patch for partitionwise join with partitioned tables containing default partition	Rajkumar Raghuwanshi	05:51
Re: Non-reserved replication slots and slot advancing 📎	Kyotaro HORIGUCHI	06:37
Re: Fix error message when trying to alter statistics on included column	Yugo Nagata	07:09
Re: CREATE TABLE .. LIKE .. EXCLUDING documentation	Yugo Nagata	07:36
Re: make installcheck-world in a clean environment	Alexander Lakhin	07:45
How to remove elements from array .	Brahmam Eswar	07:49
Re: pgsql: Fix "base" snapshot handling in logical decoding	Arseny Sher	07:55
small doc fix - using expressions in plpgsql FETCH command	Pavel Stehule	07:58
RE: automatic restore point	Yotsunaga, Naoki	08:05
RE: automatic restore point	Yotsunaga, Naoki	08:10
RE: How to remove elements from array .	Charles Clavadetscher	08:19
Re: How to remove elements from array .	Pavel Stehule	08:23
Re: How to remove elements from array .	Pavel Stehule	08:26
Re: Fix to not check included columns in ANALYZE on indexes	Yugo Nagata	08:28
Typo in Japanese translation of psql. 📎	Taiki Kondo	08:33
Re: Fix to not check included columns in ANALYZE on indexes	Yugo Nagata	08:40
Re: Typo in Japanese translation of psql.	Yugo Nagata	09:14
RE: Speeding up INSERTs and UPDATEs to partitioned tables	Kato, Sho	09:25
Re: How to remove elements from array .	Brahmam Eswar	09:45
Re: How to remove elements from array .	Pavel Stehule	09:57
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled.	Etsuro Fujita	10:59
Re: [HACKERS] Crash on promotion when recovery.conf is renamed	Andrew Dunstan	11:01
Re: [HACKERS] WIP: Aggregation push-down	Antonin Houska	11:11
Re: [HACKERS] Crash on promotion when recovery.conf is renamed	Michael Paquier	11:18
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled.	Ashutosh Bapat	11:20
Re: log_min_messages shows debug instead of debug2	Andrew Dunstan	11:36
Re: PATCH: Update snowball stemmers	Andrew Dunstan	11:52
Re: How can we submit code patches that implement our (pending) patents?	Dave Cramer	12:04
Re: [HACKERS] Crash on promotion when recovery.conf is renamed	Andrew Dunstan	12:05
Re: [HACKERS] Crash on promotion when recovery.conf is renamed	Michael Paquier	12:09
Re: [HACKERS] Optional message to user when terminating/cancelling backend	Pavel Stehule	12:12
Re: patch to allow disable of WAL recycling	Jerry Jelinek	12:44
Re: Push down Aggregates below joins 📎	Antonin Houska	12:58
Re: [HACKERS] PoC: full merge join on comparison clause	Ashutosh Bapat	13:01
Re: Generating partitioning tuple conversion maps faster 📎	Alexander Kuzmenkov	13:08
Re: Explain buffers wrong counter with parallel plans	Amit Kapila	13:44
Re: shared-memory based stats collector	Magnus Hagander	14:29
Re: no partition pruning when partitioning using array type	Andrew Dunstan	15:13
Re: hot_standby_feedback vs excludeVacuum and snapshots	Simon Riggs	15:32
Re: BUG #14999: pg_rewind corrupts control file global/pg_control	Andrew Dunstan	15:45
Re: PATCH: Update snowball stemmers	Tom Lane	16:37
pgbench issue	Sichen Zhao	16:58
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query	Fujii Masao	17:26
pg_recvlogical use of SIGHUP	Dave Cramer	17:49
Re: pg_recvlogical use of SIGHUP	Andres Freund	18:11
"interesting" issue with restore from a pg_dump with a database-wide search_path	Larry Rosenman	18:27
Re: "interesting" issue with restore from a pg_dump with a database-wide search_path	Joshua D. Drake	18:35
Re: pgbench issue	Andres Freund	18:37
Re: pg_recvlogical use of SIGHUP	Dave Cramer	18:37
Re: "interesting" issue with restore from a pg_dump with a database-wide search_path	Larry Rosenman	18:37
Re: shared-memory based stats collector	Robert Haas	18:49
Re: shared-memory based stats collector	Andres Freund	18:57
Re: shared-memory based stats collector	Joshua D. Drake	19:02
Re: Explain buffers wrong counter with parallel plans	Robert Haas	19:14
Re: pg_recvlogical use of SIGHUP 📎	Dave Cramer	19:15
Re: PATCH: Update snowball stemmers	Arthur Zakirov	19:17
Re: documentation fixes for partition pruning, round three	Alvaro Herrera	19:33
Re: shared-memory based stats collector	Robert Haas	19:34
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query	Robert Haas	19:35
Re: shared-memory based stats collector	Andres Freund	19:36
Re: shared-memory based stats collector	Joshua D. Drake	19:46
Re: shared-memory based stats collector	Magnus Hagander	20:03
Re: shared-memory based stats collector	Andres Freund	20:10
Re: "interesting" issue with restore from a pg_dump with a database-wide search_path	Tom Lane	20:10
Re: Make deparsing of column defaults faster	Peter Eisentraut	20:47
Re: [PATCH] Use access() to check file existence in GetNewRelFileNode().	Peter Eisentraut	20:52
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query	Sergei Kornilov	20:56
Re: Let's remove DSM_IMPL_NONE.	Peter Eisentraut	21:08
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query	Alvaro Herrera	21:10
Re: [HACKERS] Bug in to_timestamp().	Tom Lane	21:30
Re: Should contrib modules install .h files?	Peter Eisentraut	22:02
Re: Should contrib modules install .h files?	Andrew Gierth	22:14
Re: peripatus build failures....	Larry Rosenman	22:19
Re: peripatus build failures....	Tom Lane	22:40
Re: peripatus build failures....	Larry Rosenman	23:05
Re: BUG #14999: pg_rewind corrupts control file global/pg_control	Michael Paquier	23:12
Re: peripatus build failures....	Larry Rosenman	23:15
Re: peripatus build failures....	Tom Lane	23:18

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

Browse Archives

Prev | Next