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

Browse Archives

Prev | Next

April 30, 2019

Thread	Author	Time
Re: Plain strdup() in frontend code	Michael Paquier	01:23
Re: Caveats from reloption toast_tuple_target	David Rowley	02:20
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	03:03
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	04:37
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	04:44
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	04:50
performance regression when filling in a table	Fabien COELHO	05:12
Re: generate documentation keywords table automatically	Peter Eisentraut	06:02
Re: Unhappy about API changes in the no-fsm-for-small-rels patch 📎	John Naylor	06:12
Re: standby recovery fails (tablespace related) (tentative patch and discussion) 📎	Paul Guo	06:33
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	07:05
Re: performance regression when filling in a table	Andres Freund	07:13
ERROR: failed to add item to the index page	Andreas Joseph Krogh	09:03
ERROR: tuple concurrently updated when modifying privileges	nickb	09:26
Re: CHAR vs NVARCHAR vs TEXT performance	Rob	09:43
Re: performance regression when filling in a table	Fabien COELHO	10:32
Re: [Patch] Base backups and random or zero pageheaders	Michael Banck	13:07
Re: ERROR: failed to add item to the index page	Tom Lane	13:43
Re: [PATCH v4] Add \warn to psql	Fabien COELHO	13:46
Sv: Re: ERROR: failed to add item to the index page	Andreas Joseph Krogh	13:49
Re: Sv: Re: ERROR: failed to add item to the index page	Tom Lane	13:53
Sv: Re: Sv: Re: ERROR: failed to add item to the index page	Andreas Joseph Krogh	14:03
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	Alvaro Herrera	14:22
Sv: Sv: Re: Sv: Re: ERROR: failed to add item to the index page	Andreas Joseph Krogh	14:27
Re: "long" type is not appropriate for counting tuples	Alvaro Herrera	14:41
Re: "long" type is not appropriate for counting tuples	Tom Lane	14:51
message style	Alvaro Herrera	14:58
Re: message style	Andres Freund	15:09
Heap lock levels for REINDEX INDEX CONCURRENTLY not quite right?	Andres Freund	15:17
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	15:51
Re: Failure in contrib test _int on loach	Teodor Sigaev	16:32
Re: Sv: Sv: Re: Sv: Re: ERROR: failed to add item to the index page	Andrew Dunstan	16:34
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	16:40
Re: ERROR: failed to add item to the index page	Andreas Joseph Krogh	16:44
Re: ERROR: failed to add item to the index page	Peter Geoghegan	16:45
Re: ERROR: failed to add item to the index page	Tom Lane	16:47
Re: ERROR: failed to add item to the index page	Peter Geoghegan	16:48
Re: ERROR: failed to add item to the index page	Andreas Joseph Krogh	16:56
Re: ERROR: failed to add item to the index page	Peter Geoghegan	16:59
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6 📎	Andres Freund	17:34
Re: performance regression when filling in a table	Andres Freund	17:49
Re: ERROR: failed to add item to the index page 📎	Peter Geoghegan	17:58
Re: CHAR vs NVARCHAR vs TEXT performance	Steve Crawford	17:59
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	18:05
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	18:27
Turning off enable_partition_pruning doesn't	Tom Lane	18:35
Re: doc: improve PG 12 to_timestamp()/to_date() wording 📎	Justin Pryzby	18:36
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	18:41
Re: Turning off enable_partition_pruning doesn't	Alvaro Herrera	18:43
Re: doc: improve PG 12 to_timestamp()/to_date() wording	Alexander Korotkov	18:48
Match table_complete_speculative() code to comment	Ashwin Agrawal	18:53
Sv: Re: ERROR: failed to add item to the index page	Andreas Joseph Krogh	18:54
Re: Re: ERROR: failed to add item to the index page	Peter Geoghegan	18:55
Re: ERROR: failed to add item to the index page	Andres Freund	18:59
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	19:03
Re: speeding up planning with partitions	Tom Lane	19:08
Re: Turning off enable_partition_pruning doesn't	Tom Lane	19:10
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	19:11
Re: ERROR: failed to add item to the index page	Andreas Joseph Krogh	19:23
Re: ERROR: failed to add item to the index page	Andres Freund	19:26
Sv: Re: ERROR: failed to add item to the index page	Andreas Joseph Krogh	19:33
Re: Calling PrepareTempTablespaces in BufFileCreateTemp	Melanie Plageman	21:25
Re: Calling PrepareTempTablespaces in BufFileCreateTemp	Tom Lane	21:36
Re: Initializing LWLock Array from Server Code	Souvik Bhattacherjee	21:52
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	22:10
Re: Calling PrepareTempTablespaces in BufFileCreateTemp	Tom Lane	22:22
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	22:24
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	22:42
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	22:53
Re: clean up docs for v12	Andres Freund	23:48
Re: clean up docs for v12	Andres Freund	23:50

May 1, 2019

Thread	Author	Time
Re: doc: improve PG 12 to_timestamp()/to_date() wording	Justin Pryzby	00:14
Adding a test for speculative insert abort case	Melanie Plageman	00:15
Re: Adding a test for speculative insert abort case	Andres Freund	00:22
Re: Initializing LWLock Array from Server Code	Robert Haas	00:26
walsender vs. XLogBackgroundFlush during shutdown	Tomas Vondra	00:28
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)	Robert Haas	00:30
Re: message style	Robert Haas	00:31
Re: POC: Cleaning up orphaned files using undo logs	Robert Haas	00:32
Re: Initializing LWLock Array from Server Code	Robert Haas	00:35
Re: [HACKERS] Weaker shmem interlock w/o postmaster.pid	Noah Misch	00:57
Re: Improve search for missing parent downlinks in amcheck	Peter Geoghegan	00:58
Re: ERROR: failed to add item to the index page 📎	Peter Geoghegan	01:28
Re: Adding a test for speculative insert abort case	Melanie Plageman	01:34
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	01:36
Re: Adding a test for speculative insert abort case	Peter Geoghegan	01:43
Re: performance regression when filling in a table	Fabien COELHO	01:53
PostgreSQL Asian language support for full text search using ICU (and also updating pg_trgm)	Chanon Sajjamanochai	01:55
Re: Adding a test for speculative insert abort case	Andres Freund	02:09
Re: Adding a test for speculative insert abort case	Thomas Munro	02:13
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	Amit Kapila	03:43
Re: POC: Cleaning up orphaned files using undo logs	Amit Kapila	03:58
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	John Naylor	04:08
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	John Naylor	04:27
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	Amit Kapila	04:35
Re: POC: Cleaning up orphaned files using undo logs 📎	Amit Kapila	04:38
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	04:43
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	John Naylor	05:19
Re: [PATCH v4] Add \warn to psql	Arthur Zakirov	07:05
Re: [PATCH v4] Add \warn to psql 📎	David Fetter	07:38
Re: [PATCH v4] Add \warn to psql	Fabien COELHO	10:02
Re: walsender vs. XLogBackgroundFlush during shutdown	Alexander Kukushkin	12:13
to_timestamp docs 📎	Bruce Momjian	13:38
Re: to_timestamp docs	Tom Lane	14:01
Re: walsender vs. XLogBackgroundFlush during shutdown 📎	Tomas Vondra	15:02
Re: to_timestamp docs	Bruce Momjian	15:04
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	Andres Freund	15:24
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	Bruce Momjian	15:28
Re: New vacuum option to do only freezing	Andres Freund	15:36
Re: walsender vs. XLogBackgroundFlush during shutdown	Andres Freund	15:53
Re: hyrax vs. RelationBuildPartitionDesc	Andres Freund	15:59
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	Andres Freund	16:08
Re: reloption to prevent VACUUM from truncating empty pages at the end of relation	Andres Freund	16:11
Re: New vacuum option to do only freezing	Andres Freund	16:14
Re: pgsql: Compute XID horizon for page level index vacuum on primary.	Andres Freund	16:15
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	Bruce Momjian	16:17
Re: compiler warning in pgcrypto imath.c	Andres Freund	16:18
Re: using index or check in ALTER TABLE SET NOT NULL	Andres Freund	16:20
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	16:20
Re: pgsql: Compute XID horizon for page level index vacuum on primary.	Robert Haas	16:34
Re: using index or check in ALTER TABLE SET NOT NULL	Tom Lane	16:38
Re: New vacuum option to do only freezing	Robert Haas	16:39
Re: walsender vs. XLogBackgroundFlush during shutdown	Tomas Vondra	16:46
Re: pgsql: Compute XID horizon for page level index vacuum on primary.	Tom Lane	16:50
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	16:59
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	17:06
Re: hyrax vs. RelationBuildPartitionDesc	Robert Haas	17:09
Re: pgsql: Compute XID horizon for page level index vacuum on primary.	Robert Haas	17:10
Re: walsender vs. XLogBackgroundFlush during shutdown	Alexander Kukushkin	17:12
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6 📎	Andres Freund	17:21
Re: using index or check in ALTER TABLE SET NOT NULL	Sergei Kornilov	18:18
Re: Adding a test for speculative insert abort case	Melanie Plageman	18:18
Re: Adding a test for speculative insert abort case	Andres Freund	18:41
Re: [HACKERS] Commits 8de72b and 5457a1 (COPY FREEZE)	Tom Lane	18:44
Re: [HACKERS] Commits 8de72b and 5457a1 (COPY FREEZE)	Andres Freund	19:05
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	19:08
Re: [HACKERS] Commits 8de72b and 5457a1 (COPY FREEZE)	Tom Lane	19:13
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	Alvaro Herrera	19:21
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	19:39
pg_upgrade --clone error checking	Jeff Janes	20:10
Re: to_timestamp docs	Arthur Zakirov	20:20
Re: to_timestamp docs	Bruce Momjian	20:41
Re: [HACKERS] Commits 8de72b and 5457a1 (COPY FREEZE)	Tom Lane	21:00
Re: to_timestamp docs	Alexander Korotkov	21:49
Re: to_timestamp docs	Bruce Momjian	22:02
Re: to_timestamp docs	Arthur Zakirov	22:03
Re: [HACKERS] Commits 8de72b and 5457a1 (COPY FREEZE) 📎	Tom Lane	23:01
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	23:41

May 2, 2019

Thread	Author	Time
Re: using index or check in ALTER TABLE SET NOT NULL	David Rowley	00:57
Re: PostgreSQL Asian language support for full text search using ICU (and also updating pg_trgm)	Tatsuo Ishii	01:07
Re: using index or check in ALTER TABLE SET NOT NULL	Tom Lane	01:08
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	01:25
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6 📎	Tom Lane	02:01
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	John Naylor	02:06
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	02:19
Re: using index or check in ALTER TABLE SET NOT NULL	David Rowley	02:22
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	Amit Kapila	03:24
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	Amit Kapila	03:46
Re: POC: Cleaning up orphaned files using undo logs 📎	Dilip Kumar	04:00
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	Amit Kapila	06:31
Re: Unhappy about API changes in the no-fsm-for-small-rels patch	John Naylor	07:09
Re: Failure in contrib test _int on loach	Heikki Linnakangas	07:37
Re: How to estimate the shared memory size required for parallel scan? 📎	Thomas Munro	08:06
Re: Heap lock levels for REINDEX INDEX CONCURRENTLY not quite right? 📎	Peter Eisentraut	08:44
Re: Unhappy about API changes in the no-fsm-for-small-rels patch 📎	Amit Kapila	08:56
Volatile function weirdness	Vik Fearing	09:04
Re: Volatile function weirdness	Julien Rouhaud	09:11
Re: POC: Cleaning up orphaned files using undo logs	Dilip Kumar	09:32
Re: speeding up planning with partitions	Amit Langote	09:33
Fixing order of resowner cleanup in 12, for Windows	Thomas Munro	10:30
Re: walsender vs. XLogBackgroundFlush during shutdown	Tomas Vondra	12:35
Bad canonicalization for dateranges with 'infinity' bounds	Laurenz Albe	12:40
Re: Bad canonicalization for dateranges with 'infinity' bounds 📎	Laurenz Albe	12:49
Re: POC: Cleaning up orphaned files using undo logs	Robert Haas	13:30
Re: pgbench - add option to show actual builtin script code	Ibrar Ahmed	13:55
Re: walsender vs. XLogBackgroundFlush during shutdown	Simon Riggs	14:00
Inconsistent error message wording for REINDEX CONCURRENTLY	Tom Lane	14:06
Re: Fixing order of resowner cleanup in 12, for Windows	Tom Lane	14:15
Re: New vacuum option to do only freezing	Robert Haas	14:20
Re: pgbench - add option to show actual builtin script code 📎	Fabien COELHO	14:25
Re: New vacuum option to do only freezing	Andres Freund	14:28
Re: Heap lock levels for REINDEX INDEX CONCURRENTLY not quite right?	Andres Freund	14:33
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	14:49
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	14:50
Re: pgbench - add option to show actual builtin script code	Ibrar Ahmed	14:54
Why is infinite_recurse test suddenly failing?	Tom Lane	15:02
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	15:08
Re: New vacuum option to do only freezing	Robert Haas	15:09
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	15:31
Re: New vacuum option to do only freezing	Andres Freund	15:32
Re: Why is infinite_recurse test suddenly failing?	Andres Freund	15:38
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	15:41
Re: Why is infinite_recurse test suddenly failing?	Tom Lane	15:45
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Andres Freund	15:56
Re: pg_upgrade --clone error checking	Peter Eisentraut	15:57
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6	Tom Lane	16:02
Re: New vacuum option to do only freezing	Robert Haas	16:02
Re: New vacuum option to do only freezing 📎	Alvaro Herrera	16:03
Re: Attempt to consolidate reading of XLOG page 📎	Antonin Houska	16:17
Re: pg_upgrade --clone error checking	Jeff Janes	16:24

Browse Archives

Prev | Next