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

Sept. 6, 2018

Thread	Author	Time
RE: automatic restore point 📎	Yotsunaga, Naoki	00:16
Add extension options to control TAP and isolation tests 📎	Michael Paquier	01:48
Re: pgsql: Clean up after TAP tests in oid2name and vacuumlo.	Michael Paquier	01:50
Re: JIT compiling with LLVM v12	Noah Misch	02:26
Re: Implement predicate propagation for non-equivalence clauses	Richard Guo	03:43
Re: Implement predicate propagation for non-equivalence clauses	Richard Guo	04:01
Re: pgsql: Allow extensions to install built as well as unbuilt headers.	Michael Paquier	05:16
Re: pgsql: Allow extensions to install built as well as unbuilt headers.	Andrew Gierth	05:26
Re: Problem while updating a foreign table pointing to a partitioned table on foreign server	Kyotaro HORIGUCHI	05:49
Re: pgsql: Allow extensions to install built as well as unbuilt headers.	Michael Paquier	05:52
Re: pgsql: Allow extensions to install built as well as unbuilt headers.	Andrew Gierth	06:09
Re: [HACKERS] Restricting maximum keep segments by repslots	Kyotaro HORIGUCHI	07:10
Re: A strange GiST error message or fillfactor of GiST build	Kyotaro HORIGUCHI	07:16
Re: Reopen logfile on SIGHUP	Kyotaro HORIGUCHI	08:00
Re: remove ancient pre-dlopen dynloader code 📎	Peter Eisentraut	08:16
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	08:30
Re: Funny hang on PostgreSQL 10 during parallel index scan on slave 📎	Chris Travers	09:08
pgsql: Refactor dlopen() support	Peter Eisentraut	09:38
Re: Bug in ginRedoRecompress that causes opaque data on page to be overrun 📎	Alexander Korotkov	09:53
Re: [HACKERS] PATCH: Keep one postmaster monitoring pipe per process	Kyotaro HORIGUCHI	09:57
Re: [WIP] [B-Tree] Retail IndexTuple deletion 📎	Andrey Lepikhov	10:26
Re: [HACKERS] Restricting maximum keep segments by repslots	Masahiko Sawada	10:55
Re: [HACKERS] PATCH: Keep one postmaster monitoring pipe per process	Kyotaro HORIGUCHI	11:17
Re: Funny hang on PostgreSQL 10 during parallel index scan on slave 📎	Chris Travers	11:31
Re: [HACKERS] Bug in to_timestamp(). 📎	Alexander Korotkov	11:40
Re: Funny hang on PostgreSQL 10 during parallel index scan on slave 📎	Chris Travers	11:44
Re: Optimze usage of immutable functions as relation 📎	Aleksandr Parfenov	11:51
Re: remove ancient pre-dlopen dynloader code	Peter Eisentraut	12:04
[No subject]	[email protected]	12:29
Re: [HACKERS] Bug in to_timestamp(). 📎	Alexander Korotkov	12:58
Re: Add --include-table-data-where option to pg_dump, to export only a subset of table data	Surafel Temesgen	13:18
Re: Funny hang on PostgreSQL 10 during parallel index scan on slave	Chris Travers	13:30
Re: pgsql: Allow extensions to install built as well as unbuilt headers.	Tom Lane	13:38
Re: pgsql: Allow extensions to install built as well as unbuilt headers.	Tom Lane	13:41
Re: pread() and pwrite()	Jesper Pedersen	14:17
Re: remove ancient pre-dlopen dynloader code	Tom Lane	14:36
Re: remove ancient pre-dlopen dynloader code	Thomas Munro	14:49
Re: [HACKERS] Custom compression methods 📎	Ildus Kurbangaliev	15:27
Re: Add --include-table-data-where option to pg_dump, to export only a subset of table data	Jeremy Finzel	15:40
Re: Add --include-table-data-where option to pg_dump, to export only a subset of table data	David G. Johnston	15:47
Re: Add --include-table-data-where option to pg_dump, to export only a subset of table data	Jeremy Finzel	16:08
Re: pgsql: Allow extensions to install built as well as unbuilt headers.	Andrew Gierth	16:18
Re: test_pg_dump missing cleanup actions 📎	Michael Paquier	16:20
Re: *_to_xml() should copy SPI_processed/SPI_tuptable 📎	Tom Lane	16:25
Re: [PATCH] Incremental sort (was: PoC: Partial sort)	James Coleman	16:51
Re: [PATCH] Incremental sort (was: PoC: Partial sort)	Tom Lane	17:39
Re: Bug in ginRedoRecompress that causes opaque data on page to be overrun	R, Siva	18:02
Re: [PATCH] Incremental sort (was: PoC: Partial sort)	James Coleman	18:04
Re: Prevent concurrent DROP SCHEMA when certain objects are being initially created in the namespace	Michael Paquier	18:56
Re: Collation versioning	Peter Eisentraut	19:01
Allow parallelism for deferrable serializable txns	Andres Freund	19:14
Re: Prevent concurrent DROP SCHEMA when certain objects are being initially created in the namespace 📎	Michael Paquier	19:22
Re: Prevent concurrent DROP SCHEMA when certain objects are being initially created in the namespace	Fabrízio de Royes Mello	20:19
Re: *_to_xml() should copy SPI_processed/SPI_tuptable	Peter Eisentraut	20:23
Re: [HACKERS] Restricting maximum keep segments by repslots	Peter Eisentraut	20:32
Re: [PATCH] Incremental sort (was: PoC: Partial sort)	Tomas Vondra	20:34
Re: *_to_xml() should copy SPI_processed/SPI_tuptable	Tom Lane	20:40
Re: *_to_xml() should copy SPI_processed/SPI_tuptable	Andrew Gierth	20:47
Commit fest 2018-09	Michael Paquier	20:50
Re: Commit fest 2018-09	Dmitry Dolgov	21:25
Re: buildfarm: could not read block 3 in file "base/16384/2662": read only 0 of 8192 bytes	Tom Lane	21:38
Re: buildfarm: could not read block 3 in file "base/16384/2662": read only 0 of 8192 bytes	Andres Freund	21:50
Re: Commit fest 2018-09	Michael Paquier	22:00
Re: buildfarm: could not read block 3 in file "base/16384/2662": read only 0 of 8192 bytes	Tom Lane	22:02
Re: Have an encrypted pgpass file	Jeremy Schneider	22:58
Re: Problem while setting the fpw with SIGHUP	Michael Paquier	23:37

Sept. 7, 2018

Thread	Author	Time
Re: Collation versioning	Thomas Munro	00:36
Re: pgsql: Refactor dlopen() support	Tom Lane	06:30
Small performance tweak to run-time partition pruning 📎	David Rowley	07:29
Unused argument from execute_sql_string() 📎	Yugo Nagata	09:05
Re: Use C99 designated initializers for some structs	Peter Eisentraut	09:45
Re: pgsql: Refactor dlopen() support	Peter Eisentraut	09:47
Re: Hint to set owner for tablespace directory 📎	Maksim Milyutin	09:59
Re: Collation versioning	Christoph Berg	10:25
cache lookup failed for constraint when alter table referred by partition table	Rajkumar Raghuwanshi	10:32
Re: [HACKERS] [PROPOSAL] Temporal query processing with range types 📎	Peter Moser	11:02
Standby reads fail when autovacuum take AEL during truncation	Adrien NAYRAT	12:16
Re: [HACKERS] proposal: schema variables	Fabien COELHO	12:34
Re: [HACKERS] Proposal to add work_mem option to postgres_fdw module	Peter Eisentraut	13:17
Re: libpq debug log	Peter Eisentraut	13:28
Re: libpq stricter integer parsing	Peter Eisentraut	13:45
Re: Removing useless \. at the end of copy in pgbench	Peter Eisentraut	13:57
Re: pgsql: Refactor dlopen() support	Tom Lane	14:19
Re: [HACKERS] proposal: schema variables	Pavel Stehule	14:28
Re: Hint to set owner for tablespace directory	Peter Eisentraut	15:05
Re: libpq stricter integer parsing	Fabien COELHO	15:13
Re: Removing useless \. at the end of copy in pgbench	Fabien COELHO	15:14
[PATCH] Fix for infinite signal loop in parallel scan 📎	Chris Travers	15:57
Re: Hint to set owner for tablespace directory	Maksim Milyutin	15:59
Partial index plan/cardinality costing 📎	James Coleman	16:17
Re: pgsql: Refactor dlopen() support	Peter Eisentraut	16:27
Re: [PATCH] Fix for infinite signal loop in parallel scan	Andres Freund	16:56
Re: Standby reads fail when autovacuum take AEL during truncation	Alexander Korotkov	17:36
Re: Incorrect error handling for two-phase state files resulting in data loss	Michael Paquier	18:04
Re: Performance improvements for src/port/snprintf.c	Alexander Kuzmenkov	18:53
Re: A strange GiST error message or fillfactor of GiST build	Bruce Momjian	19:09
Re: pg_constraint.conincluding is useless	Bruce Momjian	19:48
Re: pg_constraint.conincluding is useless	Alvaro Herrera	20:02
Re: A strange GiST error message or fillfactor of GiST build	Tom Lane	20:12
Re: pg_constraint.conincluding is useless	Tom Lane	20:12
Re: pgsql: Allow extensions to install built as well as unbuilt headers.	Michael Paquier	20:52
Re: libpq stricter integer parsing	Michael Paquier	20:56
Re: pgsql: Refactor dlopen() support 📎	Tom Lane	21:13
Re: libpq stricter integer parsing 📎	Fabien COELHO	21:22
Re: Collation versioning	Thomas Munro	21:34
Re: buildfarm: could not read block 3 in file "base/16384/2662": read only 0 of 8192 bytes	Tom Lane	22:16
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist)	Bruce Momjian	22:32
StandbyAcquireAccessExclusiveLock doesn't necessarily	Tom Lane	22:37
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist)	Tom Lane	22:43
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist)	Bruce Momjian	22:56
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist)	Tom Lane	23:05
Re: jsonpath 📎	Nikita Glukhov	23:21

Sept. 8, 2018

Thread	Author	Time
Re: *_to_xml() should copy SPI_processed/SPI_tuptable	Tom Lane	00:10
RE: [HACKERS] Proposal to add work_mem option to postgres_fdw module	Shinoda, Noriyoshi (PN Japan GCS Delivery)	00:53
remove duplicated words in comments .. across lines 📎	Justin Pryzby	01:31
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors	Fabien COELHO	07:17
Does logical replication slot itself would be physically replicated to slaves?	Jinhua Luo	09:37
How to find local logical replication origin?	Jinhua Luo	09:41
Sv: Re: Query is over 2x slower with jit=on	Andreas Joseph Krogh	10:44
Re: StandbyAcquireAccessExclusiveLock doesn't necessarily	Simon Riggs	12:52
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors	Fabien COELHO	13:03
RULE does not like the NOT EXISTS condition	Szima Gábor	15:20
Re: [HACKERS] [BUGS] BUG #14825: enum type: unsafe use? 📎	Thomas Munro	16:01
Re: RULE does not like the NOT EXISTS condition	Andrew Gierth	16:10
Re: RULE does not like the NOT EXISTS condition	Andrew Gierth	17:52
Re: remove duplicated words in comments .. across lines	Michael Paquier	19:25
Re: Prevent concurrent DROP SCHEMA when certain objects are being initially created in the namespace	Michael Paquier	19:53
Re: Does logical replication slot itself would be physically replicated to slaves?	Michael Paquier	20:07
Re: Prevent concurrent DROP SCHEMA when certain objects are being initially created in the namespace	Tom Lane	20:21
Re: Prevent concurrent DROP SCHEMA when certain objects are being initially created in the namespace	Michael Paquier	21:09
Re: libpq stricter integer parsing	Michael Paquier	21:41

Sept. 9, 2018

Thread	Author	Time
Re: Allow to specify a index name as ANALYZE parameter	John Naylor	06:25
Re: libpq stricter integer parsing	Fabien COELHO	07:01
Re: pg_ugprade test failure on data set with column with default value with type bit/varbit	John Naylor	07:47
Re: remove duplicated words in comments .. across lines	Antonin Houska	09:11
Re: How to find local logical replication origin?	Jinhua Luo	14:16
Re: WIP: "More fair" LWLocks	Dmitry Dolgov	16:20
Re: [HACKERS] Bug in to_timestamp().	Alexander Korotkov	18:52
Re: Bug in ginRedoRecompress that causes opaque data on page to be overrun	Alexander Korotkov	18:53
Re: [HACKERS] PATCH: multivariate histograms and MCV lists	Tomas Vondra	21:49
Re: pgbench - add pseudo-random permutation function 📎	Hironobu SUZUKI	22:35

Sept. 10, 2018

Thread	Author	Time
stat() on Windows might cause error if target file is larger than 4GB	Higuchi, Daisuke	02:01
SerializeParamList vs machines with strict alignment	Tom Lane	03:27
Re: How to find local logical replication origin?	Jinhua Luo	03:30
Re: executor relation handling	David Rowley	04:36
Re: Add extension options to control TAP and isolation tests	Michael Paquier	06:22
Re: Problem while setting the fpw with SIGHUP	Amit Kapila	06:24
Re: How to find local logical replication origin?	Michael Paquier	06:30
Re: stat() on Windows might cause error if target file is larger than 4GB	Michael Paquier	06:44
Re: SerializeParamList vs machines with strict alignment	Amit Kapila	06:52
Re: CREATE ROUTINE MAPPING	Kyotaro HORIGUCHI	07:16
Re: CREATE ROUTINE MAPPING	Hannu Krosing	07:28
Re: Pluggable Storage - Andres's take 📎	Haribabu Kommi	07:42
Can I just reload the slave to change primary_conninfo?	Jinhua Luo	08:32
Re: Can I just reload the slave to change primary_conninfo?	Michael Paquier	08:51
Re: Can I just reload the slave to change primary_conninfo?	Sergei Kornilov	09:08
Latest HEAD fails to build	Rafia Sabih	09:22
Re: Latest HEAD fails to build	Daniel Gustafsson	09:26
Re: cache lookup failed for constraint when alter table referred by partition table	Justin Pryzby	09:28
Re: Latest HEAD fails to build	Rafia Sabih	09:35
Re: Latest HEAD fails to build	Daniel Gustafsson	09:41
Bug report: Dramatic increase in conflict with recovery after upgrading 10.2->10.5	Chris Travers	09:43
Re: Avoid extra Sort nodes between WindowAggs when sorting can be reused	Alexander Kuzmenkov	09:50
Re: Query is over 2x slower with jit=on 📎	Amit Khandekar	10:12
Re: [HACKERS] Restricting maximum keep segments by repslots	Kyotaro HORIGUCHI	10:19
Re: Adding a note to protocol.sgml regarding CopyData	Tatsuo Ishii	10:24
Re: Latest HEAD fails to build	Christoph Berg	10:40
Re: Latest HEAD fails to build	Rafia Sabih	10:50
Re: [HACKERS] Restricting maximum keep segments by repslots	Kyotaro HORIGUCHI	10:52
Re: [PATCH][PROPOSAL] Add enum releation option type	Aleksandr Parfenov	11:02
Re: Can I just reload the slave to change primary_conninfo?	Michael Paquier	11:36
Re: How to find local logical replication origin?	Petr Jelinek	12:07
Re: cache lookup failed for constraint when alter table referred by partition table	Alvaro Herrera	12:47
Re: Standby reads fail when autovacuum take AEL during truncation	Adrien NAYRAT	13:17
Re: SerializeParamList vs machines with strict alignment	Tom Lane	13:35
Re: Latest HEAD fails to build	Tom Lane	13:55
Re: Pluggable Storage - Andres's take	Amit Kapila	14:03
Re: patch to allow disable of WAL recycling	Jerry Jelinek	14:10
Re: cache lookup failed for constraint when alter table referred by partition table	Alvaro Herrera	14:36
Re: Loaded footgun open_datasync on Windows 📎	Laurenz Albe	14:46
Re: Can I just reload the slave to change primary_conninfo?	Chris Travers	14:53
Re: Can I just reload the slave to change primary_conninfo?	Sergei Kornilov	15:12
Re: Pluggable Storage - Andres's take	Mithun Cy	16:08
Re: Query is over 2x slower with jit=on	Andres Freund	16:09
Re: master, static inline and #ifndef FRONTEND	Tom Lane	16:39
Re: master, static inline and #ifndef FRONTEND	Andres Freund	16:50
warnings from parser?	Pavel Stehule	17:23
Re: warnings from parser?	Pavel Stehule	17:25
Re: warnings from parser?	Andrew Gierth	17:38
Re: warnings from parser?	Pavel Stehule	17:39
can commitfest application resend a mail?	Pavel Stehule	17:53
Re: warnings from parser?	Pavel Stehule	17:55
Re: can commitfest application resend a mail?	Magnus Hagander	18:01
Re: can commitfest application resend a mail?	Pavel Stehule	18:07
Re: can commitfest application resend a mail?	Alvaro Herrera	18:13
Re: can commitfest application resend a mail?	Pavel Stehule	18:15
Re: StandbyAcquireAccessExclusiveLock doesn't necessarily	Robert Haas	18:16
Re: pg_stat_statements query jumbling question	legrand legrand	18:32
Re: can commitfest application resend a mail?	Alvaro Herrera	18:37
Re: Index Skip Scan	Dmitry Dolgov	21:47

Browse Archives

Prev | Next