pgsql-hackers since 2019-02-27 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

Feb. 27, 2019

Thread Author Time
Re: NOT IN subquery optimization Li, Zheng 00:05
Re: Allowing extensions to supply operator-/function-specific info Tom Lane 00:09
Re: Pluggable Storage - Andres's take Andres Freund 00:10
Re: NOT IN subquery optimization Tom Lane 00:13
Re: Autovaccuum vs temp tables crash Tom Lane 00:21
Re: NOT IN subquery optimization David Rowley 00:24
Re: NOT IN subquery optimization David Rowley 00:26
Re: NOT IN subquery optimization Li, Zheng 00:41
Re: NOT IN subquery optimization David Rowley 00:48
Re: Index INCLUDE vs. Bitmap Index Scan Justin Pryzby 01:00
Re: New vacuum option to do only freezing Bossart, Nathan 01:02
Re: Early WIP/PoC for inlining CTEs Andrew Gierth 01:11
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Jeff Janes 01:35
RE: Timeout parameters Jamison, Kirk 01:35
Re: Pluggable Storage - Andres's take Haribabu Kommi 02:06
Re: Proving IS NOT NULL inference for ScalarArrayOpExpr's 📎 James Coleman 02:13
Re: Problem with default partition pruning Amit Langote 02:21
Re: pgsql: Avoid creation of the free space map for small heap relations, t 📎 Amit Kapila 04:05
RE: Timeout parameters 📎 Nagaura, Ryohei 04:25
Re: Early WIP/PoC for inlining CTEs Tom Lane 04:45
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Pavan Deolasee 04:56
Re: Early WIP/PoC for inlining CTEs Andrew Gierth 05:16
Re: pgsql: Avoid creation of the free space map for small heap relations, t John Naylor 05:19
Re: TupleTableSlot abstraction Michael Paquier 05:21
RE: Protect syscache from bloating with negative cache entries Ideriha, Takeshi 05:26
Re: Index INCLUDE vs. Bitmap Index Scan Markus Winand 05:36
Re: pgsql: Avoid creation of the free space map for small heap relations, t John Naylor 05:37
Re: TupleTableSlot abstraction Andres Freund 05:42
Re: Index INCLUDE vs. Bitmap Index Scan Markus Winand 05:50
When is the MessageContext released? Andy Fan 06:08
Re: NOT IN subquery optimization Richard Guo 06:14
Re: When is the MessageContext released? Andres Freund 06:15
Re: psql display of foreign keys Michael Paquier 06:24
Re: TupleTableSlot abstraction Michael Paquier 06:34
Re: TupleTableSlot abstraction Andres Freund 06:38
Re: Autovaccuum vs temp tables crash Michael Paquier 06:39
Re: TupleTableSlot abstraction Michael Paquier 06:42
Re: Libpq support to connect to standby server as priority 📎 Haribabu Kommi 06:44
Re: TupleTableSlot abstraction Andres Freund 06:45
RE: Problem with default partition pruning Yuzuko Hosoya 06:50
Re: Offline enabling/disabling of data checksums Fabien COELHO 06:59
Re: [HACKERS] generated columns Peter Eisentraut 07:05
Re: [HACKERS] generated columns Peter Eisentraut 07:08
Re: Offline enabling/disabling of data checksums Michael Paquier 07:26
Re: [HACKERS] generated columns Michael Paquier 07:31
Re: Remove Deprecated Exclusive Backup Mode Laurenz Albe 07:35
get_controlfile() can leak fds in the backend 📎 Michael Paquier 07:47
Re: psql show URL with help 📎 Peter Eisentraut 08:14
RE: Protect syscache from bloating with negative cache entries Ideriha, Takeshi 08:16
Re: BUG #15589: Due to missing wal, restore ends prematurely and opens database for read/write leif 09:14
Re: get_controlfile() can leak fds in the backend Fabien COELHO 09:23
Re: get_controlfile() can leak fds in the backend Andres Freund 09:32
Re: Segfault when restoring -Fd dump on current HEAD Dmitry Dolgov 09:36
Re: BUG #15623: Inconsistent use of default for updatable view 📎 Dean Rasheed 09:37
Re: Oddity with parallel safety test for scan/join target in grouping_planner Etsuro Fujita 09:55
Re: Why don't we have a small reserved OID range for patch revisions? Peter Eisentraut 09:59
Re: Pluggable Storage - Andres's take Heikki Linnakangas 10:00
Re: Set fallback_application_name for a walreceiver to cluster_name Peter Eisentraut 10:02
Re: New vacuum option to do only freezing Masahiko Sawada 10:04
Re: get_controlfile() can leak fds in the backend Fabien COELHO 10:50
Re: When is the MessageContext released? Andy Fan 10:59
some hints to understand the plsql cursor. Andy Fan 11:11
Re: Segfault when restoring -Fd dump on current HEAD Alvaro Herrera 12:32
Unneeded parallel safety tests in grouping_planner 📎 Etsuro Fujita 12:45
pg_dump/pg_restore fail for TAR_DUMP and CUSTOM_DUMP from v94/v95/v96 to v11/master. Prabhat Sahu 13:38
Re: readdir is incorrectly implemented at Windows Grigory Smolkin 14:00
Re: get_controlfile() can leak fds in the backend Joe Conway 15:26
Re: [RFC] [PATCH] Flexible "partition pruning" hook 📎 Mike Palmiotto 15:27
Re: some hints to understand the plsql cursor. Dilip Kumar 15:35
Re: Parallel query vs smart shutdown and Postmaster death Robert Haas 15:38
Re: Unneeded parallel safety tests in grouping_planner Robert Haas 15:46
Re: Oddity with parallel safety test for scan/join target in grouping_planner Robert Haas 15:52
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Robert Haas 15:55
Re: [HACKERS] Can ICU be used for a database's default sort order? Marius Timmer 16:32
Re: Index INCLUDE vs. Bitmap Index Scan Tom Lane 16:54
Re: Segfault when restoring -Fd dump on current HEAD Tom Lane 17:02
Re: Segfault when restoring -Fd dump on current HEAD 📎 Dmitry Dolgov 17:21
Re: Pluggable Storage - Andres's take Andres Freund 17:29
Re: [RFC] [PATCH] Flexible "partition pruning" hook Peter Eisentraut 17:36
Re: Index INCLUDE vs. Bitmap Index Scan Tomas Vondra 17:41
Re: [HACKERS] Block level parallel vacuum Robert Haas 17:44
Re: New vacuum option to do only freezing Bossart, Nathan 17:45
Re: query logging of prepared statements 📎 Justin Pryzby 18:06
Re: Remove Deprecated Exclusive Backup Mode Christophe Pettus 18:22
Re: psql display of foreign keys 📎 Alvaro Herrera 18:37
Re: pg_partition_tree crashes for a non-defined relation Alvaro Herrera 18:48
Re: Update does not move row across foreign partitions in v11 Derek Hans 18:53
Re: Index INCLUDE vs. Bitmap Index Scan Tom Lane 19:23
Re: Update does not move row across foreign partitions in v11 Alvaro Herrera 19:31
Re: POC: converting Lists into arrays 📎 Tom Lane 20:26
Re: POC: converting Lists into arrays Robert Haas 20:32
Re: [HACKERS] EvalPlanQual behaves oddly for FDW queries involving system columns Andres Freund 20:33
Re: POC: converting Lists into arrays Tom Lane 20:47
Re: Refactoring the checkpointer's fsync request queue 📎 Shawn Debnath 21:26
Re: Why don't we have a small reserved OID range for patch revisions? Tom Lane 21:27
Re: POC: converting Lists into arrays Alvaro Herrera 21:41
Re: Refactoring the checkpointer's fsync request queue Thomas Munro 21:43
Re: Why don't we have a small reserved OID range for patch revisions? Peter Geoghegan 21:50
Re: Why don't we have a small reserved OID range for patch revisions? Tom Lane 21:59
Re: Why don't we have a small reserved OID range for patch revisions? Tom Lane 22:09
Re: Why don't we have a small reserved OID range for patch revisions? Peter Eisentraut 22:38
Re: Why don't we have a small reserved OID range for patch revisions? Peter Eisentraut 22:44
Re: Why don't we have a small reserved OID range for patch revisions? Peter Geoghegan 22:44
Re: Why don't we have a small reserved OID range for patch revisions? Peter Geoghegan 22:45
Re: Why don't we have a small reserved OID range for patch revisions? Tom Lane 22:57
Re: Row Level Security − leakproof-ness and performance implications 📎 Joe Conway 23:03
Re: patch to allow disable of WAL recycling 📎 Alvaro Herrera 23:10
Re: Allowing extensions to supply operator-/function-specific info Paul Ramsey 23:11
Re: some hints to understand the plsql cursor. Andy Fan 23:35
Re: Allowing extensions to supply operator-/function-specific info Tom Lane 23:40
Re: Allowing extensions to supply operator-/function-specific info Paul Ramsey 23:50

Feb. 28, 2019

Thread Author Time
Re: pgsql: Avoid creation of the free space map for small heap relations, t Amit Kapila 00:24
Re: get_controlfile() can leak fds in the backend 📎 Joe Conway 00:45
RE: reloption to prevent VACUUM from truncating empty pages at the end of relation 📎 Tsunakawa, Takayuki 00:48
Re: get_controlfile() can leak fds in the backend Michael Paquier 00:49
Re: get_controlfile() can leak fds in the backend Andres Freund 00:50
Re: get_controlfile() can leak fds in the backend Michael Paquier 00:54
Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events Marc Dean 01:01
RE: reloption to prevent VACUUM from truncating empty pages at the end of relation Tsunakawa, Takayuki 01:05
Re: pg_partition_tree crashes for a non-defined relation 📎 Michael Paquier 01:45
RE: Libpq support to connect to standby server as priority Tsunakawa, Takayuki 01:59
Re: Segfault when restoring -Fd dump on current HEAD Michael Paquier 02:10
Re: pgsql: Avoid creation of the free space map for small heap relations, t John Naylor 02:15
RE: Protect syscache from bloating with negative cache entries Tsunakawa, Takayuki 02:15
Re: readdir is incorrectly implemented at Windows Michael Paquier 02:15
Re: pg_partition_tree crashes for a non-defined relation Amit Langote 02:21
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Michael Paquier 02:24
Re: Allowing extensions to supply operator-/function-specific info Tom Lane 02:26
Re: pgsql: Avoid creation of the free space map for small heap relations, t Amit Kapila 02:40
RE: proposal: pg_restore --convert-to-text Imai, Yoshikazu 02:48
RE: Timeout parameters 📎 Nagaura, Ryohei 03:07
Re: A note about recent ecpg buildfarm failures Mark Wong 03:21
Re: pgsql: Avoid creation of the free space map for small heap relations, t 📎 Amit Kapila 03:25
Re: psql display of foreign keys Michael Paquier 03:25
RE: reloption to prevent VACUUM from truncating empty pages at the end of relation Tsunakawa, Takayuki 03:41
Re: Why don't we have a small reserved OID range for patch revisions? Tom Lane 03:41
Re: POC: converting Lists into arrays David Rowley 04:08
Re: POC: converting Lists into arrays Tom Lane 04:23
Re: pgsql: Avoid creation of the free space map for small heap relations, t John Naylor 04:29
Re: POC: converting Lists into arrays 📎 David Rowley 04:41
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Alvaro Herrera 05:14
Re: partitioned tables referenced by FKs Amit Langote 05:21
Re: POC: converting Lists into arrays Tom Lane 05:40
Re: POC: converting Lists into arrays Andrew Gierth 05:42
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Tom Lane 05:54
Drop type "smgr"? 📎 Thomas Munro 06:02
Re: Drop type "smgr"? Tom Lane 06:08
RE: Prevent extension creation in temporary schemas Kuroda, Hayato 06:13
Re: Drop type "smgr"? Thomas Munro 06:21
Re: POC: converting Lists into arrays Tom Lane 06:27
Re: Drop type "smgr"? Tom Lane 06:37
Re: bgwriter_lru_maxpages limits in PG 10 sample conf Sergei Kornilov 07:28
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Laurenz Albe 07:32
Re: Drop type "smgr"? Thomas Munro 07:39
Re: Drop type "smgr"? Haribabu Kommi 07:44
Re: BUG #15623: Inconsistent use of default for updatable view Amit Langote 07:46
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Sergei Kornilov 07:50
Re: New vacuum option to do only freezing 📎 Masahiko Sawada 08:09
Re: Prevent extension creation in temporary schemas Sergei Kornilov 08:15
RE: reloption to prevent VACUUM from truncating empty pages at the end of relation Tsunakawa, Takayuki 08:16
RE: Problem with default partition pruning Imai, Yoshikazu 08:26
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Laurenz Albe 08:33
extension patch of CREATE OR REPLACE TRIGGER 📎 Osumi, Takamichi 08:43
RE: Protect syscache from bloating with negative cache entries Ideriha, Takeshi 08:48
Re: get_controlfile() can leak fds in the backend Fabien COELHO 08:54
Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated with wrong context Ramanarayana 08:58
2019-03 Starts Tomorrow David Steele 09:05
Re: [HACKERS] EvalPlanQual behaves oddly for FDW queries involving system columns Etsuro Fujita 09:28
Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated with wrong context Pavel Stehule 09:31
Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated with wrong context Ramanarayana 09:49
Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated with wrong context Pavel Stehule 10:04
Re: FETCH FIRST clause PERCENT option 📎 Surafel Temesgen 10:32
Re: FETCH FIRST clause PERCENT option Kyotaro HORIGUCHI 11:26
Re: extension patch of CREATE OR REPLACE TRIGGER David Rowley 11:26
Re: FETCH FIRST clause PERCENT option Kyotaro HORIGUCHI 11:49
Re: get_controlfile() can leak fds in the backend Joe Conway 12:11
Re: get_controlfile() can leak fds in the backend Michael Paquier 12:20
Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated with wrong context Pavel Stehule 12:24
Re: Libpq support to connect to standby server as priority Dave Cramer 12:32
Re: pgbench MAX_ARGS David Rowley 13:20
Re: Online verification of checksums Fabien COELHO 13:29
Re: Why don't we have a small reserved OID range for patch revisions? Robert Haas 13:59
Re: BUG #15623: Inconsistent use of default for updatable view Dean Rasheed 14:07
Re: Removing unneeded self joins 📎 Alexander Kuzmenkov 14:09
Re: Row Level Security − leakproof-ness and performance implications Robert Haas 14:12
Re: Drop type "smgr"? Robert Haas 14:15
Re: Optimze usage of immutable functions as relation Alexander Kuzmenkov 14:27
Re: Remove Deprecated Exclusive Backup Mode Fujii Masao 14:44
Re: Row Level Security − leakproof-ness and performance implications Joe Conway 14:45
Re: Row Level Security − leakproof-ness and performance implications Dean Rasheed 14:52
Re: Remove Deprecated Exclusive Backup Mode Stephen Frost 14:53
Add exclusive backup deprecation notes to documentation 📎 David Steele 15:01
Re: Row Level Security − leakproof-ness and performance implications Chapman Flack 15:04
Re: Row Level Security − leakproof-ness and performance implications Joshua Brindle 15:04
Re: Remove Deprecated Exclusive Backup Mode David Steele 15:08
Re: Drop type "smgr"? Tom Lane 15:09
Re: Prevent extension creation in temporary schemas Tom Lane 15:13
Re: [HACKERS] Incomplete startup packet errors 📎 Christoph Berg 15:13
PostgreSQL Participates in GSoC 2019! Stephen Frost 15:22
Re: Why don't we have a small reserved OID range for patch revisions? Tom Lane 15:27

Browse Archives

Prev | Next