pgsql-hackers since 2019-02-28 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. 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
Re: Drop type "smgr"? Robert Haas 15:35
Re: Re: Continue work on changes to recovery.conf API David Steele 15:38
Re: Re: Continue work on changes to recovery.conf API David Steele 15:41
Re: [HACKERS] Custom compression methods 📎 Ildus Kurbangaliev 15:44
Re: Re: Row Level Security − leakproof-ness and performance implications Tom Lane 15:49
Re: Why don't we have a small reserved OID range for patch revisions? Robert Haas 15:58
Re: [HACKERS] WIP: Aggregation push-down 📎 Antonin Houska 16:02
Re: Re: Row Level Security − leakproof-ness and performance implications Joshua Brindle 16:03
Re: Drop type "smgr"? Tom Lane 16:06
Re: Add exclusive backup deprecation notes to documentation Laurenz Albe 16:08
Re: Row Level Security − leakproof-ness and performance implications Chapman Flack 16:13
Re: Row Level Security − leakproof-ness and performance implications Joe Conway 16:14
Re: Row Level Security − leakproof-ness and performance implications Joshua Brindle 16:24
Re: Index INCLUDE vs. Bitmap Index Scan Tom Lane 16:26
Re: Row Level Security − leakproof-ness and performance implications Robert Haas 16:37
Re: Row Level Security − leakproof-ness and performance implications Joe Conway 16:44
Re: Row Level Security − leakproof-ness and performance implications Robert Haas 16:50
Re: Row Level Security − leakproof-ness and performance implications Joe Conway 17:05
Re: Row Level Security − leakproof-ness and performance implications Robert Haas 17:28
Re: Row Level Security − leakproof-ness and performance implications Joe Conway 17:35
Re: Drop type "smgr"? Robert Haas 17:36
Re: Drop type "smgr"? Tom Lane 17:39
plpgsql variable named as SQL keyword Pavel Stehule 17:45
Re: Drop type "smgr"? Shawn Debnath 18:02
Re: Drop type "smgr"? Shawn Debnath 18:06
Re: Bloom index cost model seems to be wrong 📎 Jeff Janes 18:11
Re: Drop type "smgr"? Andres Freund 18:11
Re: Remove Deprecated Exclusive Backup Mode David Steele 18:13
Question about pg_upgrade from 9.2 to X.X Perumal Raj 18:13
Re: Drop type "smgr"? Andres Freund 18:15
Re: Drop type "smgr"? Tom Lane 18:16
Re: [HACKERS] EvalPlanQual behaves oddly for FDW queries involving system columns Andres Freund 18:18
Re: plpgsql variable named as SQL keyword Tom Lane 18:20
Re: Question about pg_upgrade from 9.2 to X.X Mahendra Singh 18:22
Re: Drop type "smgr"? Andres Freund 18:24
Re: plpgsql variable named as SQL keyword Pavel Stehule 18:25
Re: Question about pg_upgrade from 9.2 to X.X Perumal Raj 18:26
Re: Question about pg_upgrade from 9.2 to X.X Sergei Kornilov 18:27
Re: partitioned tables referenced by FKs 📎 Alvaro Herrera 18:28
Re: Question about pg_upgrade from 9.2 to X.X Perumal Raj 18:29
Re: Bloom index cost model seems to be wrong Tom Lane 18:30
Re: [RFC] [PATCH] Flexible "partition pruning" hook Mike Palmiotto 18:36
Re: Question about pg_upgrade from 9.2 to X.X Sergei Kornilov 19:04
Re: Question about pg_upgrade from 9.2 to X.X Perumal Raj 19:21
Re: POC: converting Lists into arrays Tom Lane 19:28
Re: pg_partition_tree crashes for a non-defined relation Alvaro Herrera 19:32
Re: some ri_triggers.c cleanup Peter Eisentraut 19:45
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Alvaro Herrera 19:55
Re: [HACKERS] PATCH: multivariate histograms and MCV lists 📎 Tomas Vondra 19:56
Re: FETCH FIRST clause PERCENT option Tomas Vondra 20:16
Re: Protect syscache from bloating with negative cache entries Robert Haas 20:18
Refresh Publication takes hours and doesn´t finish PegoraroF10 20:23
Re: Segfault when restoring -Fd dump on current HEAD Alvaro Herrera 20:24
Re: ATTACH/DETACH PARTITION CONCURRENTLY 📎 Robert Haas 20:27
Re: Segfault when restoring -Fd dump on current HEAD Dmitry Dolgov 20:38
Re: Drop type "smgr"? Thomas Munro 20:48
Re: get_controlfile() can leak fds in the backend Andres Freund 21:07
Re: get_controlfile() can leak fds in the backend Joe Conway 21:09
Re: Drop type "smgr"? Thomas Munro 21:33
Re: Drop type "smgr"? Shawn Debnath 21:41
Re: [HACKERS] [PROPOSAL] Temporal query processing with range types 📎 Peter Moser 21:43
Re: Index Skip Scan Jeff Janes 21:45
Re: POC: converting Lists into arrays 📎 Tom Lane 21:49
Re: Drop type "smgr"? Andres Freund 22:08
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation Tom Lane 22:17
Re: Drop type "smgr"? Tom Lane 22:20
Re: Index Skip Scan Jeff Janes 22:23
Re: propagating replica identity to partitions Alvaro Herrera 22:25
Re: Drop type "smgr"? Shawn Debnath 22:31
Re: Drop type "smgr"? Thomas Munro 22:32
Re: Why don't we have a small reserved OID range for patch revisions? Peter Geoghegan 22:36
Re: Drop type "smgr"? Thomas Munro 22:38
Re: propagating replica identity to partitions Alvaro Herrera 22:41
Re: Index Skip Scan Thomas Munro 23:03
Re: Drop type "smgr"? Shawn Debnath 23:03
Re: Why don't we have a small reserved OID range for patch revisions? Tom Lane 23:09
Re: Index Skip Scan Tomas Vondra 23:10
Re: Why don't we have a small reserved OID range for patch revisions? Tom Lane 23:40
Re: Why don't we have a small reserved OID range for patch revisions? Peter Geoghegan 23:41
Re: Why don't we have a small reserved OID range for patch revisions? Tomas Vondra 23:57
Re: Why don't we have a small reserved OID range for patch revisions? Peter Geoghegan 23:57

March 1, 2019

Thread Author Time
Re: Online verification of checksums 📎 Michael Banck 00:05
Re: pg_partition_tree crashes for a non-defined relation Michael Paquier 00:22
Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated with wrong context Ramanarayana 00:36
Re: jsonpath 📎 Nikita Glukhov 00:36
Re: jsonpath Andres Freund 00:49
Re: get_controlfile() can leak fds in the backend Michael Paquier 01:00
Re: get_controlfile() can leak fds in the backend Michael Paquier 01:11
Re: SQL/JSON: functions 📎 Nikita Glukhov 01:14
Re: get_controlfile() can leak fds in the backend Andres Freund 01:19
Re: SQL/JSON: JSON_TABLE 📎 Nikita Glukhov 01:19
Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated with wrong context Chapman Flack 01:31
Re: FETCH FIRST clause PERCENT option Kyotaro HORIGUCHI 01:31
RE: Protect syscache from bloating with negative cache entries Tsunakawa, Takayuki 01:46
Re: proposal: variadic argument support for least, greatest function Chapman Flack 01:59
Re: Remove Deprecated Exclusive Backup Mode Martín Marqués 02:07
Re: pgsql: Avoid creation of the free space map for small heap relations, t Amit Kapila 02:19
Fix memleaks and error handling in jsonb_plpython 📎 Nikita Glukhov 02:24
Re: NOT IN subquery optimization Richard Guo 02:27
Tighten error control for OpenTransientFile/CloseTransientFile 📎 Michael Paquier 02:33
Re: Prevent extension creation in temporary schemas Michael Paquier 02:43
Re: 2019-03 Starts Tomorrow Michael Paquier 02:48
Re: Remove Deprecated Exclusive Backup Mode Michael Paquier 02:50
Re: propagating replica identity to partitions Michael Paquier 02:55
RE: extension patch of CREATE OR REPLACE TRIGGER Osumi, Takamichi 02:59
Re: 2019-03 Starts Tomorrow Tom Lane 03:47
Re: Prevent extension creation in temporary schemas Tom Lane 03:52
Re: pg_partition_tree crashes for a non-defined relation Amit Langote 04:38
Re: pg_partition_tree crashes for a non-defined relation Tom Lane 04:50
Re: [HACKERS] CLUSTER command progress monitor 📎 Tatsuro Yamada 04:53
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 05:16

Browse Archives

Prev | Next