pgsql-hackers since 2019-03-08 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

March 8, 2019

Thread	Author	Time
Re: Update does not move row across foreign partitions in v11	Amit Langote	00:36
Re: Tighten error control for OpenTransientFile/CloseTransientFile	Alvaro Herrera	01:00
Re: pg_basebackup against older server versions	Michael Paquier	01:18
Re: Tighten error control for OpenTransientFile/CloseTransientFile	Michael Paquier	01:23
Re: patch to allow disable of WAL recycling	Thomas Munro	01:25
Re: pgsql: Removed unused variable, openLogOff. 📎	Michael Paquier	01:27
Re: Add exclusive backup deprecation notes to documentation	Michael Paquier	01:35
Re: Re: Feature: temporary materialized views	Michael Paquier	01:38
RE: ECPG regression with DECLARE STATEMENT support	Kuroda, Hayato	01:54
Re: Update does not move row across foreign partitions in v11 📎	Amit Langote	02:06
Re: Add exclusive backup deprecation notes to documentation	Magnus Hagander	02:08
Re: pg_dump multi VALUES INSERT	David Rowley	02:22
Re: PostgreSQL vs SQL/XML Standards	Alvaro Herrera	02:44
Re: House style for DocBook documentation?	Chapman Flack	04:04
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons 📎	Peter Geoghegan	04:22
RE: Protect syscache from bloating with negative cache entries	Ideriha, Takeshi	04:40
Re: any plan to support shared servers like Oracle in PG?	Andy Fan	04:49
Re: Psql patch to show access methods info	Kyotaro HORIGUCHI	04:52
The two "XML Fixes" patches still in need of review 📎	Chapman Flack	05:08
Re: New vacuum option to do only freezing	Masahiko Sawada	05:10
Re: Fix memleaks and error handling in jsonb_plpython 📎	Michael Paquier	05:59
Re: Small doc fix for pageinspect	Michael Paquier	06:13
Re: speeding up planning with partitions 📎	Amit Langote	06:26
Re: [PROPOSAL] Drop orphan temp tables in single-mode	Michael Paquier	06:27
Re: PostgreSQL vs SQL/XML Standards 📎	Pavel Stehule	06:41
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)	Masahiko Sawada	06:45
RE: speeding up planning with partitions 📎	Imai, Yoshikazu	07:16
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)	Antonin Houska	07:36
RE: Timeout parameters	Nagaura, Ryohei	08:03
Re: [HACKERS] CLUSTER command progress monitor 📎	Tatsuro Yamada	08:13
Re: [HACKERS] advanced partition matching algorithm for partition-wise join	Rajkumar Raghuwanshi	08:42
Re: pg_basebackup against older server versions 📎	Sergei Kornilov	08:46
Re: PostgreSQL vs SQL/XML Standards	Pavel Stehule	08:52
Re: Covering GiST indexes 📎	Alexander Korotkov	08:58
Re: Small doc fix for pageinspect	Laurenz Albe	09:15
Re: speeding up planning with partitions 📎	Amit Langote	09:18
Re: insensitive collations 📎	Peter Eisentraut	10:07
Re: insensitive collations	Peter Eisentraut	10:09
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons	Heikki Linnakangas	10:12
Add tablespace tap test to pg_rewind 📎	Shaoqi Bai	10:14
Re: BUG #15672: PostgreSQL 11.1/11.2 crashed after dropping a partition table 📎	Amit Langote	10:22
Re: Update does not move row across foreign partitions in v11	David Rowley	10:29
Is it too soon for a PG12 open items wiki page?	David Rowley	10:49
Re: Is it too soon for a PG12 open items wiki page?	Julien Rouhaud	10:51
Re: Update does not move row across foreign partitions in v11	Etsuro Fujita	11:09
Re: Update does not move row across foreign partitions in v11	David Rowley	11:21
Re: WIP: Avoid creation of the free space map for small tables	Amit Kapila	11:43
Re: PostgreSQL vs SQL/XML Standards 📎	Pavel Stehule	11:45
Re: WIP: Avoid creation of the free space map for small tables	Amit Kapila	11:45
Re: WIP: Avoid creation of the free space map for small tables	Amit Kapila	11:49
Re: Online verification of checksums 📎	Michael Banck	11:51
Re: PostgreSQL vs SQL/XML Standards	Alvaro Herrera	12:20
Re: Reporting script runtimes in pg_regress	Peter Eisentraut	12:21
Re: PostgreSQL vs SQL/XML Standards	Pavel Stehule	12:35
Re: House style for DocBook documentation?	Peter Eisentraut	12:38
Re: psql show URL with help	Peter Eisentraut	12:45
Re: Pluggable Storage - Andres's take	Dagfinn Ilmari Mannsåker	12:56
Re: pg_basebackup ignores the existing data directory permissions	Peter Eisentraut	12:59
Re: Reporting script runtimes in pg_regress	Christoph Berg	13:02
Re: Is it too soon for a PG12 open items wiki page?	Amit Langote	13:06
Re: Reporting script runtimes in pg_regress	Alvaro Herrera	13:12
Fwd: Add tablespace tap test to pg_rewind 📎	Shaoqi Bai	13:42
Re: Update does not move row across foreign partitions in v11 📎	Amit Langote	13:52
Re: Update does not move row across foreign partitions in v11	Alvaro Herrera	14:09
Re: PostgreSQL vs SQL/XML Standards	Alvaro Herrera	14:31
Re: House style for DocBook documentation?	Chapman Flack	14:38
Re: Update does not move row across foreign partitions in v11 📎	Amit Langote	14:43
Re: Update does not move row across foreign partitions in v11	Alvaro Herrera	15:03
Re: psql show URL with help	David Fetter	15:11
Re: Online verification of checksums	Julien Rouhaud	15:19
Re: Should we increase the default vacuum_cost_limit?	Jeff Janes	15:20
Re: Minimal logical decoding on standbys	Amit Khandekar	15:29
Re: Update does not move row across foreign partitions in v11 📎	Amit Langote	16:13
Re: Problems with plan estimates in postgres_fdw	Antonin Houska	16:25
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)	Antonin Houska	16:38
Re: Why don't we have a small reserved OID range for patch revisions?	Tom Lane	17:14
Re: Online verification of checksums	Tomas Vondra	17:49
Re: Online verification of checksums	Julien Rouhaud	17:59
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)	Tomas Vondra	18:08
Re: Should we increase the default vacuum_cost_limit?	Tom Lane	18:10
Re: PostgreSQL vs SQL/XML Standards	Pavel Stehule	18:13
Hash index initial size is too large given NULLs or partial indexes	Jeff Janes	18:14
Re: Hash index initial size is too large given NULLs or partial indexes	Tomas Vondra	18:27
Re: PostgreSQL vs SQL/XML Standards	Alvaro Herrera	18:34
Re: PostgreSQL vs SQL/XML Standards 📎	Alvaro Herrera	18:44
Re: PostgreSQL vs SQL/XML Standards	Pavel Stehule	18:48
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons	Peter Geoghegan	18:48
Re: Performance issue in foreign-key-aware join estimation	Tom Lane	19:05
Re: Reaping Temp tables to avoid XID wraparound	Magnus Hagander	19:14
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons	Peter Geoghegan	19:53
Re: Ordered Partitioned Table Scans	Tom Lane	20:14
Re: Oddity with parallel safety test for scan/join target in grouping_planner	Tom Lane	20:36
Re: Checksum errors in pg_stat_database 📎	Julien Rouhaud	20:54
Re: Ordered Partitioned Table Scans	Julien Rouhaud	21:20
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons	Peter Geoghegan	21:21
Re: Ordered Partitioned Table Scans	Tom Lane	21:52
Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru	Andrew Dunstan	22:05
Re: BUG #15383: Join Filter cost estimation problem in 10.5 📎	Tom Lane	23:04
Re: Binary upgrade from <12 to 12 creates toast table for partitioned tables 📎	Alvaro Herrera	23:18
Re: Binary upgrade from <12 to 12 creates toast table for partitioned tables	Andres Freund	23:20
Re: Checksum errors in pg_stat_database 📎	Magnus Hagander	23:35
Re: Should we increase the default vacuum_cost_limit?	David Rowley	23:47
Re: Tighten error control for OpenTransientFile/CloseTransientFile	Michael Paquier	23:53

March 9, 2019

Thread	Author	Time
Re: Is it too soon for a PG12 open items wiki page?	Michael Paquier	00:02
Re: Pluggable Storage - Andres's take 📎	Haribabu Kommi	00:03
Re: Fwd: Add tablespace tap test to pg_rewind	Michael Paquier	00:09
Re: Performance issue in foreign-key-aware join estimation	David Rowley	00:18
Re: \describe* 📎	Corey Huinker	00:19
Re: Ordered Partitioned Table Scans	David Rowley	01:09
Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru	Michael Paquier	01:15
Re: pg_basebackup ignores the existing data directory permissions	Haribabu Kommi	01:19
Re: Reaping Temp tables to avoid XID wraparound	Michael Paquier	01:28
Re: Should we increase the default vacuum_cost_limit?	Andrew Dunstan	01:29
Re: dropdb --force	Thomas Munro	01:53
Re: Should we increase the default vacuum_cost_limit?	Tom Lane	01:54
Re: Re: proposal: make NOTIFY list de-duplication optional	Thomas Munro	02:30
Re: Should we increase the default vacuum_cost_limit?	Tom Lane	03:11
Re: Pluggable Storage - Andres's take 📎	Andres Freund	03:13
Re: Pluggable Storage - Andres's take	Andres Freund	03:18
Re: PostgreSQL vs SQL/XML Standards	Pavel Stehule	04:17
Re: Hash index initial size is too large given NULLs or partial indexes	Amit Kapila	04:25
Re: \describe*	Pavel Stehule	05:10
proposal: type info support functions for functions that use "any" type	Pavel Stehule	06:22
Re: Ordered Partitioned Table Scans 📎	David Rowley	06:51
Re: Is it too soon for a PG12 open items wiki page?	David Rowley	06:53
Re: [HACKERS] Weaker shmem interlock w/o postmaster.pid 📎	Noah Misch	07:16
Re: Is it too soon for a PG12 open items wiki page?	Julien Rouhaud	08:21
Re: Checksum errors in pg_stat_database	Julien Rouhaud	08:34
Re: Should we increase the default vacuum_cost_limit?	David Rowley	09:28
RE: Timeout parameters	Fabien COELHO	10:35
Re: Should we increase the default vacuum_cost_limit?	Andrew Dunstan	13:28
Re: [HACKERS] Removing [Merge]Append nodes which contain a single subpath 📎	David Rowley	14:04
Re: Should we increase the default vacuum_cost_limit?	Tom Lane	16:31
Re: Should we increase the default vacuum_cost_limit?	Tom Lane	17:55
Re: [HACKERS] PATCH: multivariate histograms and MCV lists	Dean Rasheed	18:33
Re: Checksum errors in pg_stat_database	Julien Rouhaud	18:41
Re: Checksum errors in pg_stat_database	Magnus Hagander	18:48
Re: Checksum errors in pg_stat_database	Magnus Hagander	18:49
Re: Checksum errors in pg_stat_database	Julien Rouhaud	18:53
Re: Checksum errors in pg_stat_database	Julien Rouhaud	18:58
Re: Should we increase the default vacuum_cost_limit?	Andrew Dunstan	18:58
Re: [PATCH] pg_hba.conf : new auth option : clientcert=verify-full 📎	Magnus Hagander	19:03
Re: Should we increase the default vacuum_cost_limit?	Julien Rouhaud	19:12
Re: [PATCH] pg_hba.conf : new auth option : clientcert=verify-full	Magnus Hagander	20:22
Re: Should we increase the default vacuum_cost_limit?	Gavin Flower	20:36
Re: Patch to document base64 encoding	Karl O. Pinc	20:53
Re: Should we increase the default vacuum_cost_limit? 📎	Tom Lane	21:04
Re: Should we increase the default vacuum_cost_limit?	Tom Lane	21:06
Re: proposal: plpgsql pragma statement 📎	Pavel Stehule	21:17
Re: PATCH: Include all columns in default names for foreign key constraints. 📎	Paul Martinez	21:27
Re: Should we increase the default vacuum_cost_limit?	Tom Lane	22:14

March 10, 2019

Thread	Author	Time
Re: Re: SQL:2011 PERIODS vs Postgres Ranges? 📎	Paul A Jungwirth	00:41
Re: Pluggable Storage - Andres's take	Dmitry Dolgov	04:49
Re: Pluggable Storage - Andres's take	Andres Freund	04:54
Re: SQL:2011 PERIODS vs Postgres Ranges?	David Steele	06:42
Re: Feature: temporary materialized views	David Steele	06:55
Re: Patch to document base64 encoding	Fabien COELHO	07:15
what makes the PL cursor life-cycle must be in the same transaction?	Andy Fan	08:14
Re: Performance issue in foreign-key-aware join estimation 📎	David Rowley	08:34
Re: Covering GiST indexes	Alexander Korotkov	08:39
Re: Should we add GUCs to allow partition pruning to be disabled?	David Rowley	09:53
Re: dropdb --force 📎	Filip Rembiałkowski	10:20
Re: jsonpath 📎	Alexander Korotkov	10:51
Re: Re: proposal: make NOTIFY list de-duplication optional 📎	Filip Rembiałkowski	10:53
Re: Performance issue in foreign-key-aware join estimation 📎	David Rowley	11:08
Re: using index or check in ALTER TABLE SET NOT NULL 📎	Sergei Kornilov	11:13
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) 📎	Fabien COELHO	11:26
Re: Checksum errors in pg_stat_database	Julien Rouhaud	12:13
Re: [HACKERS] PATCH: multivariate histograms and MCV lists	Dean Rasheed	13:09
Re: Should we increase the default vacuum_cost_limit?	Julien Rouhaud	13:10
Re: Should we increase the default vacuum_cost_limit?	Julien Rouhaud	13:18
Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query;	Ramanarayana	13:26
Re: Batch insert in CTAS/MatView code	Paul Guo	13:55
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons	Heikki Linnakangas	14:09
Re: WIP: Avoid creation of the free space map for small tables 📎	John Naylor	14:16
Re: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name 📎	David Rowley	15:18
Re: Should we add GUCs to allow partition pruning to be disabled?	Justin Pryzby	15:25
Re: Should we increase the default vacuum_cost_limit?	Tom Lane	15:47
Re: Should we increase the default vacuum_cost_limit?	Julien Rouhaud	15:56
Re: [HACKERS] PATCH: multivariate histograms and MCV lists	Dean Rasheed	15:57
Re: Binary upgrade from <12 to 12 creates toast table for partitioned tables	Alvaro Herrera	16:29
Re: proposal: plpgsql pragma statement 📎	Pavel Stehule	16:39
Re: GiST VACUUM 📎	Andrey Borodin	16:40
Re: Covering GiST indexes	Andrey Borodin	16:42
Re: Why don't we have a small reserved OID range for patch revisions? 📎	John Naylor	17:11
Re: [HACKERS] PATCH: multivariate histograms and MCV lists	Tomas Vondra	17:36
Re: monitoring CREATE INDEX [CONCURRENTLY]	David Fetter	17:43
Re: subscriptionCheck failures on nightjar	Andrew Dunstan	18:40
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons	Peter Geoghegan	18:53
Re: Batch insert in CTAS/MatView code	David Fetter	18:58
pgsql: Include GUC's unit, if it has one, in out-of-range error message	Tom Lane	19:18
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons	Heikki Linnakangas	19:53
Re: performance issue in remove_from_unowned_list()	Alvaro Herrera	20:09
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons	Peter Geoghegan	20:11
Re: Should we increase the default vacuum_cost_limit? 📎	Tom Lane	20:58
Re: Segfault when restoring -Fd dump on current HEAD 📎	Dmitry Dolgov	21:38
Re: [HACKERS] PATCH: multivariate histograms and MCV lists	David Rowley	22:27
Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query;	Michael Paquier	22:42
Re: Fwd: Add tablespace tap test to pg_rewind	Michael Paquier	22:50
Re: what makes the PL cursor life-cycle must be in the same transaction?	Dagfinn Ilmari Mannsåker	23:07

Browse Archives

Prev | Next