pgsql-hackers since 2019-04-18 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)

Browse Archives

Prev | Next

April 18, 2019

Thread Author Time
Re: Cleanup/remove/update references to OID column Andres Freund 00:23
Re: Cleanup/remove/update references to OID column Andres Freund 00:29
Re: pgsql: tableam: basic documentation. Andres Freund 00:36
Re: Cleanup/remove/update references to OID column 📎 Justin Pryzby 00:42
Re: Cleanup/remove/update references to OID column Andres Freund 00:51
Re: jsonpath John Naylor 01:08
REINDEX INDEX results in a crash for an index of pg_class since 9.6 Michael Paquier 01:14
RE: Speeding up creating UPDATE/DELETE generic plan for partitioned table into a lot Kato, Sho 02:09
Pathological performance when inserting many NULLs into a unique index Peter Geoghegan 02:37
Re: pgsql: Fix plan created for inherited UPDATE/DELETE with all tables exc 📎 Amit Langote 02:42
Re: ALTER TABLE with ADD COLUMN and ADD PRIMARY KEY USING INDEX throws spurious "column contains null values" 📎 Tom Lane 03:54
Re: Cleanup/remove/update references to OID column Justin Pryzby 04:14
Re: [HACKERS] Weaker shmem interlock w/o postmaster.pid Thomas Munro 04:30
Re: bug in update tuple routing with foreign partitions Amit Langote 05:06
Re: bug in update tuple routing with foreign partitions Amit Langote 05:08
Re: Runtime pruning problem Amit Langote 05:20
proposal: psql PSQL_TABULAR_PAGER variable Pavel Stehule 05:20
"make installcheck" fails in src/test/recovery Tom Lane 05:45
Re: New vacuum option to do only freezing Masahiko Sawada 06:12
Re: Status of the table access method work Simon Riggs 06:27
Re: bgwriter_lru_maxpages limits in PG 10 sample conf Sergei Kornilov 06:42
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila 06:46
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila 06:48
Re: Fix handling of unlogged tables in FOR ALL TABLES publications Peter Eisentraut 08:14
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor 08:40
Question about the holdable cursor Andy Fan 11:50
Remove page-read callback from XLogReaderState. 📎 Kyotaro HORIGUCHI 12:02
Re: bug in update tuple routing with foreign partitions 📎 Etsuro Fujita 13:10
Re: proposal: psql PSQL_TABULAR_PAGER variable Bruce Momjian 13:51
Re: Question about the holdable cursor Tom Lane 14:09
Re: Race conditions with checkpointer and shutdown 📎 Tom Lane 14:53
Re: block-level incremental backup David Fetter 15:32
Re: block-level incremental backup Bruce Momjian 15:34
Re: proposal: psql PSQL_TABULAR_PAGER variable Pavel Stehule 15:45
Re: proposal: psql PSQL_TABULAR_PAGER variable Bruce Momjian 15:58
Re: proposal: psql PSQL_TABULAR_PAGER variable Pavel Stehule 16:06
Re: proposal: psql PSQL_TABULAR_PAGER variable Bruce Momjian 16:35
Re: proposal: psql PSQL_TABULAR_PAGER variable Pavel Stehule 16:41
Re: block-level incremental backup Robert Haas 16:56
Re: block-level incremental backup Andres Freund 17:00
Re: Question about the holdable cursor Andy Fan 17:02
Re: Runtime pruning problem 📎 Tom Lane 17:25
Re: block-level incremental backup Robert Haas 18:05
Re: Runtime pruning problem Robert Haas 18:13
Re: block-level incremental backup Andres Freund 18:21
Re: ALTER TABLE with ADD COLUMN and ADD PRIMARY KEY USING INDEX throws spurious "column contains null values" Robert Haas 18:32
Re: proposal: psql PSQL_TABULAR_PAGER variable Alvaro Herrera 19:12
Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint Robert Haas 19:16
Re: proposal: psql PSQL_TABULAR_PAGER variable Pavel Stehule 19:29
Re: pgsql: Fix plan created for inherited UPDATE/DELETE with all tables exc Tom Lane 19:41
Re: finding changed blocks using WAL scanning Robert Haas 19:43
Re: Runtime pruning problem Tom Lane 19:50
Re: finding changed blocks using WAL scanning Robert Haas 19:51
Re: finding changed blocks using WAL scanning Bruce Momjian 19:51
Re: finding changed blocks using WAL scanning Robert Haas 20:25
Re: block-level incremental backup Stephen Frost 20:59
Re: Pluggable Storage - Andres's take 📎 Andres Freund 21:05
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund 21:10
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane 21:14
Re: block-level incremental backup Stephen Frost 21:17
Re: finding changed blocks using WAL scanning Bruce Momjian 21:47
Re: pg_dump is broken for partition tablespaces 📎 Alvaro Herrera 21:50
Re: finding changed blocks using WAL scanning Andres Freund 21:52
Re: Race conditions with checkpointer and shutdown 📎 Tom Lane 21:57
Re: Race conditions with checkpointer and shutdown Thomas Munro 21:58
Re: Race conditions with checkpointer and shutdown Tom Lane 22:22
Re: block-level incremental backup Stephen Frost 22:39

April 19, 2019

Thread Author Time
Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint Michael Paquier 00:08
Re: "make installcheck" fails in src/test/recovery Michael Paquier 00:27
Comments for lossy ORDER BY are lacking Andres Freund 00:30
Re: Pathological performance when inserting many NULLs into a unique index 📎 Peter Geoghegan 00:33
Re: Comments for lossy ORDER BY are lacking Andres Freund 00:37
Re: finding changed blocks using WAL scanning Michael Paquier 00:38
Re: Pathological performance when inserting many NULLs into a unique index Michael Paquier 00:46
Re: "make installcheck" fails in src/test/recovery Tom Lane 01:31
Re: ExecForceStoreMinimalTuple leaks memory like there's no tomorrow Andres Freund 02:04
Re: "make installcheck" fails in src/test/recovery Michael Paquier 02:23
Re: Race conditions with checkpointer and shutdown Michael Paquier 02:30
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila 02:37
Re: Race conditions with checkpointer and shutdown Thomas Munro 02:47
Re: Race conditions with checkpointer and shutdown Tom Lane 02:51
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Tom Lane 02:53
Re: Race conditions with checkpointer and shutdown Tom Lane 02:57
Re: Pathological performance when inserting many NULLs into a unique index Peter Geoghegan 03:13
Re: bug in update tuple routing with foreign partitions Etsuro Fujita 03:15
Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown) 📎 Paul Guo 03:40
Re: Race conditions with checkpointer and shutdown Thomas Munro 03:41
Re: Race conditions with checkpointer and shutdown Tom Lane 03:48
Re: bug in update tuple routing with foreign partitions Amit Langote 04:00
Re: Race conditions with checkpointer and shutdown Tom Lane 04:02
Re: bug in update tuple routing with foreign partitions Amit Langote 04:17
Do CustomScan as not projection capable node 📎 Andrey Lepikhov 04:35
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Asim R P 04:38
Re: Do CustomScan as not projection capable node Tom Lane 04:45
Re: bug in update tuple routing with foreign partitions Etsuro Fujita 05:39
Re: bug in update tuple routing with foreign partitions Etsuro Fujita 05:40
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Andres Freund 05:51
Re: bug in update tuple routing with foreign partitions Amit Langote 05:55
Patch: doc for pg_logical_emit_message() 📎 Matsumura, Ryo 06:21
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 06:32
RE: Global shared meta cache Ideriha, Takeshi 06:43
Re: "make installcheck" fails in src/test/recovery Michael Paquier 06:57
Re: pgsql: Fix plan created for inherited UPDATE/DELETE with all tables exc Amit Langote 07:07
Re: Unhappy about API changes in the no-fsm-for-small-rels patch John Naylor 07:47
Re: clean up docs for v12 Michael Paquier 08:00
Re: Runtime pruning problem 📎 Amit Langote 08:00
Re: Runtime pruning problem Amit Langote 08:03
Re: Runtime pruning problem 📎 Amit Langote 08:13
Re: TM format can mix encodings in to_char() Kyotaro HORIGUCHI 08:30
Re: Unhappy about API changes in the no-fsm-for-small-rels patch Amit Kapila 09:16
Re: POC: Cleaning up orphaned files using undo logs 📎 Dilip Kumar 10:15
Re: clean up docs for v12 Justin Pryzby 14:43
Re: POC: Cleaning up orphaned files using undo logs Robert Haas 16:43
Re: TM format can mix encodings in to_char() Tom Lane 16:47
Re: Idea for fixing parallel pg_dump's lock acquisition problem Robert Haas 17:00
Re: Idea for fixing parallel pg_dump's lock acquisition problem Tom Lane 17:17
Re: ExecForceStoreMinimalTuple leaks memory like there's no tomorrow Andres Freund 18:55
Re: Idea for fixing parallel pg_dump's lock acquisition problem Julien Rouhaud 20:52
Re: Idea for fixing parallel pg_dump's lock acquisition problem Tom Lane 21:34

April 20, 2019

Thread Author Time
Re: block-level incremental backup Stephen Frost 00:04
Re: finding changed blocks using WAL scanning Stephen Frost 00:39
Re: [PATCH v20] GSSAPI encryption support Stephen Frost 01:25
Re: Pathological performance when inserting many NULLs into a unique index 📎 Peter Geoghegan 01:34
Re: block-level incremental backup Robert Haas 04:05
Re: finding changed blocks using WAL scanning Robert Haas 04:09
Re: finding changed blocks using WAL scanning Robert Haas 04:17
Re: block-level incremental backup Stephen Frost 04:19
Re: finding changed blocks using WAL scanning Robert Haas 04:21
Re: finding changed blocks using WAL scanning Stephen Frost 04:42
refactoring - share str2*int64 functions Fabien COELHO 11:22
Re: refactoring - share str2*int64 functions 📎 Fabien COELHO 11:23
Re: pgsql: Allow insert and update tuple routing and COPY for foreign table 📎 Laurenz Albe 11:53
Re: finding changed blocks using WAL scanning Bruce Momjian 13:18
Re: finding changed blocks using WAL scanning Bruce Momjian 13:18
Re: Add missing operator <->(box, point) Fabien COELHO 13:41
Re: TM format can mix encodings in to_char() Tom Lane 15:50
Re: block-level incremental backup Andrey Borodin 16:44
Re: jsonpath 📎 Alexander Korotkov 17:54
Re: jsonpath Alexander Korotkov 18:01
Re: TM format can mix encodings in to_char() 📎 Tom Lane 18:46
Re: block-level incremental backup Robert Haas 20:11
Re: block-level incremental backup Robert Haas 20:13
Re: finding changed blocks using WAL scanning Robert Haas 20:17
Re: finding changed blocks using WAL scanning Robert Haas 20:21
Re: block-level incremental backup Stephen Frost 20:32
Re: finding changed blocks using WAL scanning Bruce Momjian 21:54

April 21, 2019

Thread Author Time
Re: TM format can mix encodings in to_char() 📎 Tom Lane 04:28
Re: Runtime pruning problem David Rowley 06:25
Re: block-level incremental backup Andrey Borodin 09:05
Do PostgreSQL have map and set structure(like STL in C++)? 梦旅人 12:32
Re: TM format can mix encodings in to_char() Andrew Dunstan 13:25
Re: TM format can mix encodings in to_char() Tom Lane 14:21
Re: [HACKERS] Weaker shmem interlock w/o postmaster.pid Noah Misch 16:59
Re: Global snapshots Andrey Borodin 17:13
Re: Do PostgreSQL have map and set structure(like STL in C++)? Fabien COELHO 17:22
Re: Do PostgreSQL have map and set structure(like STL in C++)? Andrey Borodin 17:22
[PATCH v1] Add \echo_stderr to psql 📎 David Fetter 18:31
Re: Strange coding in mvdistinct.c Tomas Vondra 18:34
Re: [PATCH v1] Add \echo_stderr to psql Pavel Stehule 18:42
Odd behavior of partitioned ALTER TABLE ONLY ... ADD PRIMARY KEY Tom Lane 19:16
Re: [PATCH v1] Add \echo_stderr to psql Fabien COELHO 19:31
Re: Odd behavior of partitioned ALTER TABLE ONLY ... ADD PRIMARY KEY Alvaro Herrera 19:36
Re: Odd behavior of partitioned ALTER TABLE ONLY ... ADD PRIMARY KEY Tom Lane 19:40
Re: ALTER TABLE with ADD COLUMN and ADD PRIMARY KEY USING INDEX throws spurious "column contains null values" 📎 Tom Lane 21:21
Re: [PATCH v1] Add \echo_stderr to psql David Fetter 21:38
Allow any[] as input arguments for sql/plpgsql functions to mimic format() 📎 Michał phoe Herda 22:03
Re: finding changed blocks using WAL scanning Robert Haas 22:24
Re: jsonpath Tom Lane 22:39
Re: block-level incremental backup Robert Haas 23:02
Re: jsonpath Alexander Korotkov 23:50

April 22, 2019

Thread Author Time
Re: jsonpath John Naylor 00:07
Re: jsonpath Tom Lane 00:27
Re: jsonpath Alvaro Herrera 00:31
Thoughts on nbtree with logical/varwidth table identifiers, v12 on-disk representation Peter Geoghegan 00:46
Re: finding changed blocks using WAL scanning Michael Paquier 02:20
Re: [PATCH v20] GSSAPI encryption support Michael Paquier 02:23
Re: extensions are hitting the ceiling Noah Misch 03:25
Re: [PATCH v1] Add \echo_stderr to psql Corey Huinker 03:52
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Paul Guo 04:36
Re: Runtime pruning problem Amit Langote 05:37
Re: clean up docs for v12 📎 Michael Paquier 05:48
Re: pgsql: Allow insert and update tuple routing and COPY for foreign table Etsuro Fujita 05:50
Re: pgsql: Allow insert and update tuple routing and COPY for foreign table Amit Langote 05:51
Re: [PATCH v1] Add \echo_stderr to psql Fabien COELHO 07:04
Re: standby recovery fails (tablespace related) (tentative patch and discussion) 📎 Kyotaro HORIGUCHI 07:15
Re: block-level incremental backup Konstantin Knizhnik 07:38
Re: standby recovery fails (tablespace related) (tentative patch and discussion) 📎 Kyotaro HORIGUCHI 07:40
display of variables in EXPLAIN VERBOSE Amit Langote 07:49
Re: Allow any[] as input arguments for sql/plpgsql functions to mimic format() Pavel Stehule 10:09
Regression test PANICs with master-standby setup on same machine 📎 Kuntal Ghosh 10:22
Re: bug in update tuple routing with foreign partitions 📎 Etsuro Fujita 11:00
Re: standby recovery fails (tablespace related) (tentative patch and discussion) 📎 Kyotaro HORIGUCHI 12:19
Re: Regression test PANICs with master-standby setup on same machine Kyotaro HORIGUCHI 12:36
Re: pgsql: Allow insert and update tuple routing and COPY for foreign table Etsuro Fujita 12:45
Re: Regression test PANICs with master-standby setup on same machine Kuntal Ghosh 12:51
Re: Runtime pruning problem 📎 David Rowley 13:12
Re: Unhappy about API changes in the no-fsm-for-small-rels patch 📎 Amit Kapila 13:19
Re: display of variables in EXPLAIN VERBOSE David Rowley 13:27
Re: Do CustomScan as not projection capable node Robert Haas 13:40
Re: [PATCH v1] Add \echo_stderr to psql 📎 David Fetter 13:45

Browse Archives

Prev | Next