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

Aug. 3, 2019

Thread Author Time
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Stephen Frost 00:13
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Stephen Frost 00:27
Re: Optimize single tuple fetch from nbtree index Peter Geoghegan 00:34
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Peter Geoghegan 00:40
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Andres Freund 00:45
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Stephen Frost 00:57
Re: Optimize single tuple fetch from nbtree index Peter Geoghegan 01:00
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Andres Freund 01:08
Re: Avoid full GIN index scan when possible 📎 Nikita Glukhov 01:51
Re: POC: Cleaning up orphaned files using undo logs Amit Kapila 04:05
Re: pglz performance Konstantin Knizhnik 05:37
Re[2]: jsonb_plperl bug 📎 Ivan Panchenko 07:03
Re: pgbench - implement strict TPC-B benchmark Fabien COELHO 09:30
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Julien Rouhaud 09:40
Re: partition routing layering in nodeModifyTable.c Etsuro Fujita 10:41
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Tomas Vondra 12:41
Re: Fix XML handling with DOCTYPE 📎 Chapman Flack 15:12
Patch to clean Query after rewrite-and-analyze - reduces memusage up to 50% - increases TPS by up to 50% 📎 Daniel Migowski 15:39
Re: [Patch] Adding CORRESPONDING/CORRESPONDING BY to set operation David Fetter 15:56
Re: [proposal] de-TOAST'ing using a iterator 📎 Binguo Bao 16:11
Re: Fix XML handling with DOCTYPE Alvaro Herrera 16:15
Re: [Patch] Adding CORRESPONDING/CORRESPONDING BY to set operation 📎 David Fetter 16:22
Re: Patch to clean Query after rewrite-and-analyze - reduces memusage up to 50% - increases TPS by up to 50% Tom Lane 16:38
Re: More issues with pg_verify_checksums and checksum verification in base backups Michael Banck 16:47
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Tom Lane 16:59
Re: partition routing layering in nodeModifyTable.c Andres Freund 17:32
Re: partition routing layering in nodeModifyTable.c Tom Lane 17:48
Re: partition routing layering in nodeModifyTable.c Andres Freund 18:03
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions 📎 Tom Lane 19:13
Re: Unused header file inclusion 📎 Andres Freund 19:37
Re: partition routing layering in nodeModifyTable.c Etsuro Fujita 19:45
Re: A couple of random BF failures in kerberosCheck Tom Lane 21:04
Re: Redacting information from logs Tomas Vondra 21:34
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎 Julien Rouhaud 21:58
Re: A couple of random BF failures in kerberosCheck 📎 Tom Lane 22:42
Re: Redacting information from logs Andres Freund 22:47
Re: Redacting information from logs Chapman Flack 22:57
Re: Redacting information from logs Tom Lane 23:14

Aug. 4, 2019

Thread Author Time
Re: pglz performance 📎 Petr Jelinek 00:41
Re: More refactoring for BuildIndexInfo Michael Paquier 02:20
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range 📎 Michael Paquier 02:48
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range Peter Geoghegan 03:25
Re: concerns around pg_lsn 📎 Jeevan Ladhe 03:41
Re: concerns around pg_lsn Alvaro Herrera 03:57
Re: Patch to clean Query after rewrite-and-analyze - reduces memusage up to 50% - increases TPS by up to 50% Daniel Migowski 05:54
Re: Problem with default partition pruning 📎 Alvaro Herrera 06:29
Re: concerns around pg_lsn Michael Paquier 06:43
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? legrand legrand 07:04
Re: Problem with default partition pruning Alvaro Herrera 07:12
Re: POC: Cleaning up orphaned files using undo logs Heikki Linnakangas 09:16
Re: Unused header file inclusion 📎 vignesh C 09:31
Re: pglz performance Andrey Borodin 09:57
Re: pglz performance Tomas Vondra 11:52
Re: A couple of random BF failures in kerberosCheck Andrew Dunstan 12:24
Re: First draft of back-branch release notes is done Jonathan S. Katz 14:16
pgsql: Improve pruning of a default partition Alvaro Herrera 15:22
Re: Problem with default partition pruning Alvaro Herrera 15:24
Re: First draft of back-branch release notes is done Tom Lane 15:52
Re: pglz performance Petr Jelinek 15:52
Re: pglz performance Petr Jelinek 15:53
Re: A couple of random BF failures in kerberosCheck Tom Lane 15:59
Re: First draft of back-branch release notes is done Jonathan S. Katz 16:08
Re: First draft of back-branch release notes is done 📎 Jonathan S. Katz 16:39
Re: pglz performance Tomas Vondra 17:30
Re: Re[2]: jsonb_plperl bug Tom Lane 18:08
Re: Optimize single tuple fetch from nbtree index Michail Nikolaev 18:13
Re: Redacting information from logs Andres Freund 18:17
Re: pgsql: Improve pruning of a default partition Alvaro Herrera 19:00
Re: idea: log_statement_sample_rate - bottom limit for sampling Tomas Vondra 19:10
Re: Patch to clean Query after rewrite-and-analyze - reduces memusage up to 50% - increases TPS by up to 50% Tom Lane 19:14
Re: idea: log_statement_sample_rate - bottom limit for sampling Tom Lane 19:16
Re: pglz performance Andres Freund 19:20
Re: idea: log_statement_sample_rate - bottom limit for sampling Tomas Vondra 19:58
Re: idea: log_statement_sample_rate - bottom limit for sampling Tom Lane 20:25
Re: idea: log_statement_sample_rate - bottom limit for sampling Tomas Vondra 20:48
Fix typos and inconsistencies for HEAD (take 9) 📎 Alexander Lakhin 21:33
Re: idea: log_statement_sample_rate - bottom limit for sampling Tomas Vondra 21:41
Re: pglz performance Petr Jelinek 22:08
Re: SQL:2011 PERIODS vs Postgres Ranges? Paul A Jungwirth 22:11
Re: pglz performance Andres Freund 22:15
Re: pglz performance Petr Jelinek 22:19
Re: Problem with default partition pruning 📎 Alvaro Herrera 22:43

Browse Archives

Prev | Next