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

Browse Archives

Prev | Next

April 27, 2019

Thread Author Time
Re: What is an item pointer, anyway? Peter Geoghegan 00:02
Re: What is an item pointer, anyway? Tom Lane 00:05
Re: "Routine Reindexing" docs should be updated to reference REINDEX CONCURRENTLY Michael Paquier 00:07
Re: What is an item pointer, anyway? Peter Geoghegan 00:13
Re: Fwd: Add tablespace tap test to pg_rewind Michael Paquier 00:35
Re: clean up docs for v12 Michael Paquier 00:44
Re: Identity columns should own only one sequence Michael Paquier 00:49
Re: Calling PrepareTempTablespaces in BufFileCreateTemp Michael Paquier 00:50
Re: Optimizer items in the release notes David Rowley 02:04
Re: Optimizer items in the release notes Bruce Momjian 02:22
Re: Optimizer items in the release notes David Rowley 02:47
Re: clean up docs for v12 Justin Pryzby 02:56
Re: [PATCH v1] Show whether tables are logged in \dt+ 📎 David Fetter 04:18
Re: clean up docs for v12 Michael Paquier 04:57
nRe: [PATCH v1] Show whether tables are logged in \dt+ Fabien COELHO 07:19
generate documentation keywords table automatically 📎 Peter Eisentraut 07:33
Re: Optimizer items in the release notes Bruce Momjian 11:40
Re: Identity columns should own only one sequence 📎 Peter Eisentraut 12:16
Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault) Etsuro Fujita 13:30
Re: [PATCH v1] Add \echo_stderr to psql 📎 Fabien COELHO 14:05
Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault) Tom Lane 14:47
Re: clean up docs for v12 Tom Lane 15:10
Re: generate documentation keywords table automatically Tom Lane 15:25
pg_ssl Steve 16:54
Re: [PATCH v1] Add \echo_stderr to psql 📎 David Fetter 17:15
Re: nRe: [PATCH v1] Show whether tables are logged in \dt+ 📎 David Fetter 17:43
Re: Failure in contrib test _int on loach Tom Lane 19:05
Re: [PATCH v1] Add \echo_stderr to psql Fabien COELHO 20:09
Re: nRe: [PATCH v1] Show whether tables are logged in \dt+ Fabien COELHO 20:38
Re: speeding up planning with partitions Tom Lane 23:10
Re: Improve search for missing parent downlinks in amcheck Alexander Korotkov 23:57

April 28, 2019

Thread Author Time
Re: Improve search for missing parent downlinks in amcheck Peter Geoghegan 00:03
Re: Improve search for missing parent downlinks in amcheck Alexander Korotkov 00:12
Re: Improve search for missing parent downlinks in amcheck Peter Geoghegan 00:36
Re: Race conditions with checkpointer and shutdown 📎 Tom Lane 00:56
Re: Improve search for missing parent downlinks in amcheck Peter Geoghegan 01:36
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Paul Guo 07:33
Data streaming between different databases Sascha Kuhl 13:59
Re: clean up docs for v12 Michael Paquier 14:05
[PATCH v4] Add \warn to psql 📎 David Fetter 14:58
[PATCH v1] Add a way to supply stdin to TAP tests 📎 David Fetter 15:07
[PATCH v5] Show detailed table persistence in \dt+ 📎 David Fetter 15:15
Re: pg_ssl David Fetter 15:25
Re: speeding up planning with partitions Amit Langote 15:26
Re: pg_ssl Steve 15:28
Re: [HACKERS] Weaker shmem interlock w/o postmaster.pid Noah Misch 17:00
Re: [PATCH v5] Show detailed table persistence in \dt+ Tom Lane 17:14
Re: Improve search for missing parent downlinks in amcheck Alexander Korotkov 17:14
Re: [PATCH v5] Show detailed table persistence in \dt+ Fabien COELHO 17:26
Re: [PATCH v4] Add \warn to psql Fabien COELHO 18:22
Re: jsonpath 📎 Alexander Korotkov 18:28
Re: Data streaming between different databases Tomas Vondra 19:52
"long" type is not appropriate for counting tuples Peter Geoghegan 22:30
Re: "long" type is not appropriate for counting tuples Tom Lane 23:24
Re: "long" type is not appropriate for counting tuples Peter Geoghegan 23:49

April 29, 2019

Thread Author Time
Re: Speed up build on Windows by generating symbol definition in batch Noah Misch 02:49
Do you see any problems with this procedure for Old Master rebuild as a Slave upon switchover ? Avinash Kumar 03:28
Re: BUG #15708: RLS 'using' running as wrong user when called from a view Daurnimator 03:56
Re: [PATCH v5] Show detailed table persistence in \dt+ David Fetter 03:58
Re: [PATCH v4] Add \warn to psql 📎 David Fetter 04:11
Re: [PATCH v5] Show detailed table persistence in \dt+ 📎 David Fetter 04:19
Re: Race conditions with checkpointer and shutdown Thomas Munro 04:52
Re: [PATCH v4] Add \warn to psql Fabien COELHO 06:30
Re: [PATCH v5] Show detailed table persistence in \dt+ Fabien COELHO 06:48
Re: Speed up build on Windows by generating symbol definition in batch David Rowley 07:36
Re: BUG #15708: RLS 'using' running as wrong user when called from a view Dean Rasheed 07:49
Re: Cleanup/remove/update references to OID column Justin Pryzby 10:28
Plain strdup() in frontend code 📎 Daniel Gustafsson 11:47
Re: Plain strdup() in frontend code Michael Paquier 13:01
Re: Refactoring the checkpointer's fsync request queue Alvaro Herrera 13:03
Re: Failure in contrib test _int on loach 📎 Anastasia Lubennikova 13:16
Re: Plain strdup() in frontend code 📎 Daniel Gustafsson 13:35
Typofixes in src/bin 📎 Daniel Gustafsson 13:40
Re: [PATCH v4] Add \warn to psql 📎 David Fetter 14:17
Re: [PATCH v5] Show detailed table persistence in \dt+ 📎 David Fetter 14:23
Re: Typofixes in src/bin Michael Paquier 14:54
Re: pg_ssl Stephen Frost 15:04
Re: jsonpath Tom Lane 15:10
Re: "long" type is not appropriate for counting tuples Andres Freund 15:11
Re: Race conditions with checkpointer and shutdown Tom Lane 15:23
Re: Identity columns should own only one sequence Laurenz Albe 16:28
Re: Race conditions with checkpointer and shutdown Andres Freund 16:35
CHAR vs NVARCHAR vs TEXT performance Rob 16:40
Re: Race conditions with checkpointer and shutdown Tom Lane 16:55
Re: Race conditions with checkpointer and shutdown Andres Freund 17:04
Re: "long" type is not appropriate for counting tuples Peter Geoghegan 17:16
Re: Race conditions with checkpointer and shutdown Ashwin Agrawal 17:26
Re: "long" type is not appropriate for counting tuples Andres Freund 17:28
Re: "long" type is not appropriate for counting tuples Tom Lane 17:32
Re: Race conditions with checkpointer and shutdown Tom Lane 17:35
Re: CHAR vs NVARCHAR vs TEXT performance Tom Lane 17:43
Re: Race conditions with checkpointer and shutdown Ashwin Agrawal 17:44
Re: Race conditions with checkpointer and shutdown Tom Lane 17:50
Re: "long" type is not appropriate for counting tuples Andres Freund 17:52
Re: "long" type is not appropriate for counting tuples Peter Geoghegan 17:56
Re: "long" type is not appropriate for counting tuples Tom Lane 18:10
Re: "long" type is not appropriate for counting tuples Peter Geoghegan 18:18
Re: "long" type is not appropriate for counting tuples 📎 Alvaro Herrera 18:19
Re: "long" type is not appropriate for counting tuples Andres Freund 18:24
Re: "long" type is not appropriate for counting tuples Peter Geoghegan 18:28
Re: "long" type is not appropriate for counting tuples Peter Geoghegan 18:31
Re: generate documentation keywords table automatically Peter Eisentraut 18:45
Re: generate documentation keywords table automatically Chapman Flack 19:19
Re: Calling PrepareTempTablespaces in BufFileCreateTemp Ashwin Agrawal 19:31
Re: Calling PrepareTempTablespaces in BufFileCreateTemp Peter Geoghegan 19:35
Re: [PATCH v4] Add \warn to psql Fabien COELHO 19:39
Re: [PATCH v5] Show detailed table persistence in \dt+ Fabien COELHO 20:03
Re: speeding up planning with partitions 📎 Tom Lane 21:12
Re: "long" type is not appropriate for counting tuples David Rowley 21:29
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6 Tom Lane 22:07
Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6 Andres Freund 22:09
Re: jsonpath 📎 Alexander Korotkov 22:20
Re: Pluggable Storage - Andres's take Ashwin Agrawal 23:17

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

Browse Archives

Prev | Next