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

Aug. 1, 2019

Thread Author Time
Re: concerns around pg_lsn Michael Paquier 09:12
Re: improve PQexec documentation Thomas Munro 09:12
Re: allow online change primary_conninfo Michael Paquier 09:13
Re: How to retain lesser paths at add_path()? Kohei KaiGai 09:28
Store FullTransactionId in TwoPhaseFileHeader/GlobalTransactionData 📎 vignesh C 09:32
Re: refactoring - share str2*int64 functions Fabien COELHO 09:34
Re: partition routing layering in nodeModifyTable.c 📎 Etsuro Fujita 09:38
Re: [PATCH] get rid of StdRdOptions, use individual binary reloptions representation for each relation kind instead Thomas Munro 09:39
Re: idea: log_statement_sample_rate - bottom limit for sampling Adrien Nayrat 09:47
Re: extension patch of CREATE OR REPLACE TRIGGER Thomas Munro 09:49
Re: Proposal for Signal Detection Refactoring Thomas Munro 09:53
Re: Global shared meta cache Konstantin Knizhnik 10:00
Re: \describe* Thomas Munro 10:03
Re: idea: log_statement_sample_rate - bottom limit for sampling Tomas Vondra 10:04
Re: allow online change primary_conninfo Sergei Kornilov 10:09
Re: Avoid full GIN index scan when possible 📎 Julien Rouhaud 10:13
Re: SQL:2011 PERIODS vs Postgres Ranges? Thomas Munro 10:22
Re: How to retain lesser paths at add_path()? Tomas Vondra 10:24
Re: Support for jsonpath .datetime() method Thomas Munro 10:30
Re: Multivariate MCV list vs. statistics target Tomas Vondra 10:30
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Etsuro Fujita 10:36
Re: Avoid full GIN index scan when possible Julien Rouhaud 10:37
Re: Referential Integrity Checks with Statement-level Triggers Thomas Munro 10:49
Re: [PATCH] Improve performance of NOTIFY over many databases (issue blocking on AccessExclusiveLock on object 0 of class 1262 of database 0) Thomas Munro 10:53
Re: pg_waldump and PREPARE Thomas Munro 11:05
Re: Ltree syntax improvement Thomas Munro 11:11
Re: Partial join Richard Guo 11:14
Re: block-level incremental backup 📎 Jeevan Chalke 11:36
Re: Partial join Arne Roland 11:46
Re: Patch to document base64 encoding Thomas Munro 11:47
Re: refactoring - share str2*int64 functions Michael Paquier 11:47
Re: pg_waldump and PREPARE Michael Paquier 11:51
Re: pg_waldump and PREPARE Julien Rouhaud 11:57
Re: pg_waldump and PREPARE Thomas Munro 11:57
Re: How to install login_hook in Postgres 10.5 legrand legrand 12:01
Re: Store FullTransactionId in TwoPhaseFileHeader/GlobalTransactionData Thomas Munro 12:05
Re: How to retain lesser paths at add_path()? Kohei KaiGai 12:14
Fix typos 📎 Sehrope Sarkuni 12:24
Re: FETCH FIRST clause PERCENT option 📎 Surafel Temesgen 12:54
Re: pgbench - implement strict TPC-B benchmark Robert Haas 13:25
Re: Store FullTransactionId in TwoPhaseFileHeader/GlobalTransactionData vignesh C 13:38
BUG #15938: Corrupted WAL segment after crash recovery PG Bug reporting form 13:52
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Tom Lane 14:08
Re: Partial join Tom Lane 14:14
Re: Avoid full GIN index scan when possible Tom Lane 14:37
Re: Multivariate MCV list vs. statistics target Dean Rasheed 14:42
Re: refactoring - share str2*int64 functions Fabien COELHO 14:48
Re: Avoid full GIN index scan when possible Julien Rouhaud 15:19
Re: Patch for SortSupport implementation on inet/cdir Brandur Leach 15:34
Re: tableam vs. TOAST 📎 Robert Haas 16:23
Re: Partial join Arne Roland 16:29
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Shay Rojansky 16:33
Re: Patch for SortSupport implementation on inet/cdir Peter Geoghegan 16:41
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line 📎 Alexey Kondratov 16:53
Re: [HACKERS] Cached plans and statement generalization 📎 Konstantin Knizhnik 16:56
Re: using explicit_bzero Andres Freund 17:06
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Andres Freund 17:19
Re: progress report for ANALYZE Robert Haas 17:48
Re: pgbench - implement strict TPC-B benchmark Andres Freund 17:50
Re: tableam vs. TOAST Andres Freund 17:53
Re: Optimze usage of immutable functions as relation 📎 Anastasia Lubennikova 17:54
Re: tableam vs. TOAST Robert Haas 17:55
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Tom Lane 17:59
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Robert Haas 18:20
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Andres Freund 18:25
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Andres Freund 18:36
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Andres Freund 18:36
Re: [HACKERS] CLUSTER command progress monitor Alvaro Herrera 18:43
Re: Batch insert in CTAS/MatView code Heikki Linnakangas 18:54
Re: \describe* Corey Huinker 18:57
Re: Avoid full GIN index scan when possible 📎 Tom Lane 18:59
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Tom Lane 19:13
Re: Avoid full GIN index scan when possible Alexander Korotkov 19:15
Re: Avoid full GIN index scan when possible Tom Lane 19:28
Re: Referential Integrity Checks with Statement-level Triggers Corey Huinker 19:28
The unused_oids script should have a reminder to use the 8000-8999 OID range Peter Geoghegan 20:36
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Julien Rouhaud 20:42
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Julien Rouhaud 20:49
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Andres Freund 20:51
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Julien Rouhaud 20:57
Re: Tid scan improvements David Rowley 21:04
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Andres Freund 21:05
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Julien Rouhaud 21:08
Re: Speed up transaction completion faster after many relations are accessed in a transaction Thomas Munro 22:15
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Thomas Munro 22:37
Re: [PATCH] kNN for btree Thomas Munro 22:39
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? Thomas Munro 22:41
Re: Optimze usage of immutable functions as relation Tom Lane 22:57
Re: NOT IN subquery optimization Thomas Munro 22:57
Re: Data-only pg_rewind, take 2 Thomas Munro 23:07
Re: [PATCH] src/test/modules/dummy_index -- way to test reloptions from inside of access method Thomas Munro 23:12
Re: [HACKERS] WAL logging problem in 9.4.3? Thomas Munro 23:35
Re: benchmarking Flex practices Thomas Munro 23:51
Re: Removing unneeded self joins Thomas Munro 23:54

Aug. 2, 2019

Thread Author Time
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Thomas Munro 00:18
Re: complier warnings from ecpg tests Michael Paquier 00:55
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Michael Paquier 01:03
Re: Fix typos Michael Paquier 01:06
Re: Problem with default partition pruning Amit Langote 01:30
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Peter Geoghegan 01:59
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Tom Lane 02:13
Re: Fix typos Tom Lane 02:18
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Tom Lane 02:21
Re: Fix typos Alvaro Herrera 03:01
PostgreSQL 12 Beta 3 Release: 2019-08-08 Michael Paquier 04:03
Re: How to install login_hook in Postgres 10.5 Michael Paquier 04:07
Re: Fix typos Michael Paquier 04:11
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Michael Paquier 04:20
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Amit Langote 04:55
Re: Replication & recovery_min_apply_delay Michael Paquier 05:44
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Julien Rouhaud 05:54
Re: [HACKERS] WAL logging problem in 9.4.3? Kyotaro Horiguchi 06:32
Re: pgbench - implement strict TPC-B benchmark Fabien COELHO 06:38
Re: WIP: Data at rest encryption Shawn Wang 06:40
Re: Memory-Bounded Hash Aggregation Adam Lee 06:44
Proposal: Clean up RangeTblEntry nodes after query preparation Daniel Migowski 07:01
Re: Hash join explain is broken Andres Freund 07:05
Re: [proposal] de-TOAST'ing using a iterator John Naylor 07:12
Re: complier warnings from ecpg tests Sergei Kornilov 07:33
Re: idea: log_statement_sample_rate - bottom limit for sampling Adrien Nayrat 07:53
Re: [HACKERS] Cached plans and statement generalization Daniel Migowski 08:25
Re: pgbench - implement strict TPC-B benchmark Fabien COELHO 08:34
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range 📎 Julien Rouhaud 08:42
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Julien Rouhaud 08:54
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik 08:57
Re: [HACKERS] Cached plans and statement generalization Daniel Migowski 09:01
A couple of random BF failures in kerberosCheck Thomas Munro 09:32
Re: Partial join Richard Guo 09:33
Re: Partial join Richard Guo 10:00
Re: Store FullTransactionId in TwoPhaseFileHeader/GlobalTransactionData 📎 Thomas Munro 10:36
Re: Fix typos 📎 Sehrope Sarkuni 10:37
Re: Should we add xid_current() or a int8->xid cast? Thomas Munro 10:42
Re: Fix typos Sehrope Sarkuni 10:45
Re: Built-in connection pooler 📎 Konstantin Knizhnik 11:05
Re: Store FullTransactionId in TwoPhaseFileHeader/GlobalTransactionData Robert Haas 12:06
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 📎 Fabien COELHO 12:11
Re: Index Skip Scan Dmitry Dolgov 12:14
Recent failures in IsolationCheck deadlock-hard Thomas Munro 12:25
Re: block-level incremental backup vignesh C 13:12
Re: pglz performance Konstantin Knizhnik 13:45
Re: Recent failures in IsolationCheck deadlock-hard Tom Lane 14:11
Re: Patch to document base64 encoding Karl O. Pinc 14:32
Re: pglz performance Tomas Vondra 14:43
Re: Patch to document base64 encoding Tom Lane 14:44
Re: Patch to document base64 encoding Chapman Flack 15:00
Re: Patch to document base64 encoding Karl O. Pinc 15:09
Re: Memory-Bounded Hash Aggregation Jeff Davis 15:11
Re: Memory-Bounded Hash Aggregation Tomas Vondra 15:21
Optimize single tuple fetch from nbtree index 📎 Floris Van Nee 15:23
[PATCH] Improve performance of NOTIFY over many databases (v2) 📎 Martijn van Oosterhout 15:40
Re: pglz performance Andrey Borodin 15:40
Re: Index Skip Scan 📎 Jesper Pedersen 16:03
Re: pglz performance Andres Freund 16:39
Re: Add client connection check during the execution of the query Konstantin Knizhnik 16:39
Re: pglz performance Tomas Vondra 17:00
Re: pglz performance Andres Freund 17:12
Re: pglz performance Tomas Vondra 17:52
Re: partition routing layering in nodeModifyTable.c Andres Freund 18:01
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range 📎 Peter Geoghegan 18:12
Re: pglz performance Andres Freund 18:20
Re: pgbench - implement strict TPC-B benchmark Andres Freund 18:31
Re: pglz performance Tomas Vondra 19:48
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Julien Rouhaud 19:51
Re: using index or check in ALTER TABLE SET NOT NULL Tomas Vondra 19:54
Re: using index or check in ALTER TABLE SET NOT NULL Tom Lane 20:02
Re: partition routing layering in nodeModifyTable.c Etsuro Fujita 20:20
First draft of back-branch release notes is done Tom Lane 20:21
Re: SQL:2011 PERIODS vs Postgres Ranges? Ibrar Ahmed 20:28
Re: partition routing layering in nodeModifyTable.c Andres Freund 20:30
Re: Optimize single tuple fetch from nbtree index Tom Lane 20:43
Re: SQL:2011 PERIODS vs Postgres Ranges? 📎 Ibrar Ahmed 20:48
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Tom Lane 20:49
Re: [PROPOSAL] Temporal query processing with range types 📎 Ibrar Ahmed 21:00
Re: partition routing layering in nodeModifyTable.c Andres Freund 21:01
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range 📎 Peter Geoghegan 21:50
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Isaac Morland 21:52
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Peter Geoghegan 22:00
jsonb_plperl bug 📎 Ivan Panchenko 22:05
Re: Optimize single tuple fetch from nbtree index Floris Van Nee 22:18
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Tom Lane 22:19
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Tomas Vondra 22:22
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Tom Lane 22:27
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Stephen Frost 22:38
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Ian Barwick 22:39
Re: jsonb_plperl bug Tom Lane 22:39
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range 📎 Peter Geoghegan 22:42
Re: tableam vs. TOAST Andres Freund 22:42
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Tom Lane 22:47
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Andres Freund 22:49
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Tom Lane 22:52
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Andres Freund 22:56
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Tomas Vondra 23:00
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Tom Lane 23:05
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Tom Lane 23:09
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Ian Barwick 23:18
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Andres Freund 23:20
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Ian Barwick 23:22
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Andres Freund 23:24
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Ian Barwick 23:36
Re: Remove HeapTuple and Buffer dependency for predicate locking functions 📎 Ashwin Agrawal 23:56

Browse Archives

Prev | Next