pgsql-hackers since 2018-11-22 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

Nov. 22, 2018

Thread Author Time
reg* checks in pg_upgrade are out of date Andres Freund 00:12
Re: [RFC] Removing "magic" oids 📎 Andres Freund 00:14
Re: pg_upgrade supported versions policy Stephen Frost 00:25
Re: ALTER INDEX ... ALTER COLUMN not present in dump Michael Paquier 00:31
Re: pg_upgrade supported versions policy Andres Freund 00:34
Re: ToDo: show size of partitioned table Michael Paquier 00:51
Re: Continue work on changes to recovery.conf API Michael Paquier 01:09
Re: Online verification of checksums Stephen Frost 01:12
Re: incorrect xlog.c coverage report Michael Paquier 01:21
Re: incorrect xlog.c coverage report Thomas Munro 01:42
Re: incorrect xlog.c coverage report Masahiko Sawada 01:56
Re: Pluggable Storage - Andres's take Asim R P 02:12
Re: incorrect xlog.c coverage report Michael Paquier 02:15
Re: Speeding up INSERTs and UPDATEs to partitioned tables 📎 Amit Langote 02:32
Re: incorrect xlog.c coverage report Alvaro Herrera 02:45
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Amit Kapila 03:09
Re: incorrect xlog.c coverage report Andres Freund 03:34
Re: zheap: a new storage format for PostgreSQL Amit Kapila 03:35
Re: Use durable_unlink for .ready and .done files for WAL segment removal Michael Paquier 04:16
Re: Speeding up INSERTs and UPDATEs to partitioned tables Michael Paquier 04:26
Re: [RFC] Removing "magic" oids Andrew Dunstan 04:32
Re: A WalSnd issue related to state WALSNDSTATE_STOPPING Michael Paquier 05:29
Re: performance statistics monitoring without spamming logs Justin Pryzby 05:41
Re: MERGE SQL statement for PG12 Pavan Deolasee 06:44
Re: Tid scan improvements 📎 David Rowley 07:41
Re: [Todo item] Add entry creation timestamp column to pg_stat_replication Michael Paquier 07:53
Re: performance statistics monitoring without spamming logs Adrien NAYRAT 08:20
[Logical replication] Does the initial table data copy break the transactional replication? Jinhua Luo 08:31
Hitting CheckRelationLockedByMe() ASSERT with force_generic_plan Rushabh Lathia 09:32
Re: cursors with prepared statements Dmitry Dolgov 10:11
tab-completion debug print 📎 Kyotaro HORIGUCHI 10:13
Re: Ordered Partitioned Table Scans 📎 David Rowley 10:27
Re: A WalSnd issue related to state WALSNDSTATE_STOPPING 📎 Paul Guo 10:31
Re: Control your disk usage in PG: Introduction to Disk Quota Extension 📎 Haozhou Wang 11:25
Re: ToDo: show size of partitioned table Pavel Stehule 11:42
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Magnus Hagander 11:44
Re: pg_upgrade supported versions policy Magnus Hagander 12:57
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Dmitry Dolgov 12:58
Re: [HACKERS] Time to change pg_regress diffs to unified by default? 📎 Christoph Berg 13:10
Re: [WIP] CREATE SUBSCRIPTION with FOR TABLES clause (table filter) 📎 Evgeniy Efimkin 13:23
Re: [PATCH] btree_gist: fix union implementation for variable length columns Pavel Raiskup 13:23
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Alvaro Herrera 13:32
Re: reg* checks in pg_upgrade are out of date Andrew Dunstan 13:49
Constraint documentation 📎 Patrick Francelle 14:16
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Amit Kapila 14:18
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Amit Kapila 14:21
Re: ToDo: show size of partitioned table Michael Paquier 14:29
Re: ToDo: show size of partitioned table Pavel Stehule 14:47
Re: pg_upgrade supported versions policy Peter Eisentraut 14:51
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Peter Eisentraut 14:54
Re: [HACKERS] generated columns Peter Eisentraut 15:16
Re: [HACKERS] generated columns Peter Eisentraut 15:20
Re: dsa_allocate() faliure Justin Pryzby 16:09
Re: Implement predicate propagation for non-equivalence clauses Alexander Kuzmenkov 16:15
Re: pg_upgrade supported versions policy Robert Eckhardt 16:29
Re: MERGE SQL statement for PG12 Tomas Vondra 16:33
Re: using index or check in ALTER TABLE SET NOT NULL Dmitry Dolgov 17:04
Re: New GUC to sample log queries Vik Fearing 17:27
Re: Online verification of checksums Tomas Vondra 17:29
Re: Online verification of checksums Stephen Frost 17:39
Re: Tid scan improvements Tomas Vondra 18:03
Re: 64-bit hash function for hstore and citext data type Tomas Vondra 18:51
Re: Add extension options to control TAP and isolation tests Nikolay Shaplov 19:01
Re: 64-bit hash function for hstore and citext data type Andrew Gierth 20:29
Re: pg_upgrade supported versions policy Andrew Dunstan 20:37
Re: [RFC] Removing "magic" oids Andres Freund 21:14
Re: Hitting CheckRelationLockedByMe() ASSERT with force_generic_plan 📎 David Rowley 22:03
Re: [RFC] Removing "magic" oids Andrew Dunstan 22:12
Re: row filtering for logical replication Petr Jelinek 23:03
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Haribabu Kommi 23:09

Nov. 23, 2018

Thread Author Time
Delay locking partitions during INSERT and UPDATE 📎 David Rowley 00:14
Re: Speeding up INSERTs and UPDATEs to partitioned tables David Rowley 00:16
Re: Add extension options to control TAP and isolation tests Michael Paquier 00:43
Re: row filtering for logical replication Stephen Frost 02:02
Re: Control your disk usage in PG: Introduction to Disk Quota Extension Hubert Zhang 02:22
Re: Should new partitions inherit their tablespace from their parent? 📎 David Rowley 04:03
Re: Hitting CheckRelationLockedByMe() ASSERT with force_generic_plan Tom Lane 04:30
Re: Inadequate executor locking of indexes David Rowley 04:41
Re: Refactoring the checkpointer's fsync request queue 📎 Thomas Munro 04:45
Re: WIP: Avoid creation of the free space map for small tables 📎 John Naylor 06:26
Re: Accounting of zero-filled buffers in EXPLAIN (BUFFERS) 📎 Thomas Munro 07:39
pgsql: Add WL_EXIT_ON_PM_DEATH pseudo-event. Thomas Munro 07:54
Re: [HACKERS] PATCH: Keep one postmaster monitoring pipe per process Thomas Munro 07:56
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock 📎 Andrey Borodin 10:18
Re: COPY FROM WHEN condition 📎 Surafel Temesgen 11:14
Re: Hitting CheckRelationLockedByMe() ASSERT with force_generic_plan Rushabh Lathia 13:17
Re: Support custom socket directory in pg_upgrade Alvaro Herrera 14:07
Re: Psql patch to show access methods info 📎 Sergey Cherkashin 14:13
Re: Add extension options to control TAP and isolation tests 📎 Arthur Zakirov 14:29
Re: dsa_allocate() faliure Jakub Glapa 14:31
Re: row filtering for logical replication Petr Jelinek 14:40
Re: Support custom socket directory in pg_upgrade Tom Lane 14:45
Index-only scan is slower than Index scan. 📎 Konstantin Knizhnik 14:51
Re: row filtering for logical replication Euler Taveira 15:17
Re: pgsql: Add WL_EXIT_ON_PM_DEATH pseudo-event. Tom Lane 15:20
prewarm compiler warnings 📎 Erik Rijkers 15:34
RE: Shared Memory: How to use SYSV rather than MMAP ? 📎 REIX, Tony 15:53
Re: prewarm compiler warnings Alvaro Herrera 16:08
Re: dsa_allocate() faliure Justin Pryzby 16:10
Re: row filtering for logical replication Euler Taveira 16:15
Re: row filtering for logical replication Alvaro Herrera 16:19
Re: Inadequate executor locking of indexes Tom Lane 16:25
Re: row filtering for logical replication David Fetter 16:39
Re: BUG #15160: planner overestimates number of rows in join when there are more than 200 rows coming from CTE Tom Lane 17:17
Re: row filtering for logical replication Petr Jelinek 17:53
Re: row filtering for logical replication Petr Jelinek 17:54
Re: row filtering for logical replication Fabrízio de Royes Mello 18:05
Re: row filtering for logical replication Petr Jelinek 18:13
Re: row filtering for logical replication Fabrízio de Royes Mello 18:29
Re: 64-bit hash function for hstore and citext data type Tom Lane 18:45
Re: row filtering for logical replication Stephen Frost 19:03
Re: 64-bit hash function for hstore and citext data type Tom Lane 19:05
Re: row filtering for logical replication Petr Jelinek 19:14
Re: row filtering for logical replication Tomas Vondra 20:00
Re: row filtering for logical replication Tomas Vondra 20:02
Re: Shared Memory: How to use SYSV rather than MMAP ? Thomas Munro 21:07
Re: pgsql: Add WL_EXIT_ON_PM_DEATH pseudo-event. Thomas Munro 21:09
Re: pg_upgrade supported versions policy David Fetter 21:10
Re: tab-completion debug print Tom Lane 21:32
Re: pg_upgrade supported versions policy Andres Freund 21:46
Re: logical decoding vs. VACUUM FULL / CLUSTER on table with TOAST-ed data 📎 Tomas Vondra 23:20
Re: Inadequate executor locking of indexes David Rowley 23:20
Re: Should new partitions inherit their tablespace from their parent? 📎 David Rowley 23:32
Re: SQL:2011 PERIODS vs Postgres Ranges? 📎 Paul A Jungwirth 23:41

Nov. 24, 2018

Thread Author Time
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock Peter Geoghegan 00:18
Re: [HACKERS] Removing [Merge]Append nodes which contain a single subpath 📎 David Rowley 00:36
Re: Tid scan improvements Edmund Horner 00:56
Re: Add extension options to control TAP and isolation tests 📎 Michael Paquier 01:15
Re: Should new partitions inherit their tablespace from their parent? Michael Paquier 01:18
Re: pgsql: Add WL_EXIT_ON_PM_DEATH pseudo-event. Michael Paquier 01:35
Re: COPY FROM WHEN condition Tomas Vondra 02:09
could not connect to server, in order to operate pgAdmin/PostgreSQL 📎 Anne Marie Harm 02:31
Re: Tid scan improvements Tomas Vondra 02:46
Re: SQL:2011 PERIODS vs Postgres Ranges? 📎 Paul A Jungwirth 02:55
Re: Tid scan improvements Edmund Horner 05:20
Re: could not connect to server, in order to operate pgAdmin/PostgreSQL Ron 06:25
Re: [HACKERS] pgbench - allow to store select results into variables 📎 Fabien COELHO 07:45
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila 07:49
Re: pgbench - doCustom cleanup 📎 Fabien COELHO 08:58
Re: COPY FROM WHEN condition Dean Rasheed 09:02
Re: FETCH FIRST clause WITH TIES option 📎 Surafel Temesgen 09:28
Re: 64-bit hash function for hstore and citext data type 📎 Andrew Gierth 11:36
Centralize use of PG_INTXX_MIN/MAX for integer limits Michael Paquier 12:15
Re: could not connect to server, in order to operate pgAdmin/PostgreSQL Ricardo Martin Gomez 12:16
Re: [HACKERS] Block level parallel vacuum Amit Kapila 12:17
Re: could not connect to server, in order to operate pgAdmin/PostgreSQL Malik Rumi 13:26
Re: could not connect to server, in order to operate pgAdmin/PostgreSQL 📎 Ray O'Donnell 13:37
Re: could not connect to server, in order to operate pgAdmin/PostgreSQL Michael Banck 13:47
Re: pgsql: Add WL_EXIT_ON_PM_DEATH pseudo-event. Christoph Berg 14:38
Re: Copy function for logical replication slots Petr Jelinek 15:27
Re: [HACKERS] pgbench - allow to store select results into variables Alvaro Herrera 15:36
Re: Centralize use of PG_INTXX_MIN/MAX for integer limits Tom Lane 15:41
Re: could not connect to server, in order to operate pgAdmin/PostgreSQL Malik Rumi 16:00
Don't wake up to check trigger file if none is configured 📎 Jeff Janes 16:29
Re: [HACKERS] pgbench - allow to store select results into variables Fabien COELHO 16:57
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) 📎 Fabien COELHO 16:58
Re: could not connect to server, in order to operate pgAdmin/PostgreSQL Ron 18:10
Re: jsonpath Tomas Vondra 20:03
RHEL 8.0 build Jeremy Harris 20:18
Re: Regarding performance regression on specific query Tom Lane 20:32
Re: RHEL 8.0 build Tom Lane 20:49
Re: Desirability of client-side expressions in psql? Corey Huinker 21:03
Re: Centralize use of PG_INTXX_MIN/MAX for integer limits Andrew Gierth 21:54
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons 📎 Peter Geoghegan 23:13
Re: pgsql: Add WL_EXIT_ON_PM_DEATH pseudo-event. Thomas Munro 23:59

Nov. 25, 2018

Thread Author Time
Re: tab-completion debug print 📎 David Fetter 00:17
Re: POC for a function trust mechanism 📎 Noah Misch 00:53
Re: [HACKERS] Block level parallel vacuum Amit Kapila 05:29
Re: pgsql: Add WL_EXIT_ON_PM_DEATH pseudo-event. Thomas Munro 08:56
Re: FETCH FIRST clause PERCENT option 📎 Surafel Temesgen 09:00
Re: FETCH FIRST clause PERCENT option Vik Fearing 10:24
Re: FETCH FIRST clause PERCENT option Surafel Temesgen 11:49
Re: FETCH FIRST clause PERCENT option Vik Fearing 12:05
Re: RHEL 8.0 build Andrew Dunstan 13:12
Re: FETCH FIRST clause PERCENT option Andrew Gierth 13:52
Re: Add extension options to control TAP and isolation tests Nikolay Shaplov 14:49
Re: Centralize use of PG_INTXX_MIN/MAX for integer limits Peter Eisentraut 15:26
Re: Regarding performance regression on specific query Jung, Jinho 15:45
pgsql: Integrate recovery.conf into postgresql.conf Peter Eisentraut 15:49
Re: Continue work on changes to recovery.conf API Peter Eisentraut 15:56
Re: Continue work on changes to recovery.conf API 📎 Sergei Kornilov 16:27
Re: [HACKERS] [PATCH] Generic type subscripting 📎 Dmitry Dolgov 17:08
Re: Desirability of client-side expressions in psql? Pavel Stehule 17:28
Re: pgsql: Add WL_EXIT_ON_PM_DEATH pseudo-event. Tom Lane 17:56
Re: Don't wake up to check trigger file if none is configured 📎 Jeff Janes 17:57
Re: Updated backup APIs for non-exclusive backups Laurenz Albe 18:13
Re: Centralize use of PG_INTXX_MIN/MAX for integer limits Tom Lane 18:13
Re: FETCH FIRST clause PERCENT option Tomas Vondra 18:23
Re: Continue work on changes to recovery.conf API Stephen Frost 18:24
Re: FETCH FIRST clause PERCENT option Tom Lane 18:31
Re: Updated backup APIs for non-exclusive backups Stephen Frost 18:50
Re: Continue work on changes to recovery.conf API Tom Lane 19:16
Re: Updated backup APIs for non-exclusive backups Laurenz Albe 19:17
Re: Support custom socket directory in pg_upgrade Tom Lane 19:36
Re: Updated backup APIs for non-exclusive backups Stephen Frost 19:40
Re: [HACKERS] advanced partition matching algorithm for partition-wise join 📎 Dmitry Dolgov 20:04
Re: [HACKERS] [PATCH] Generic type subscripting Thomas Munro 20:30
Re: Continue work on changes to recovery.conf API Andres Freund 20:39
Re: Continue work on changes to recovery.conf API Andres Freund 20:39
Re: Updated backup APIs for non-exclusive backups Laurenz Albe 20:45

Browse Archives

Prev | Next