pgsql-hackers since 2020-07-04 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

July 4, 2020

Thread Author Time
avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint 📎 Justin Pryzby 00:45
Ideas about a better API for postgres_fdw remote estimates Tom Lane 03:08
Re: track_planning causing performance regression Pavel Stehule 03:22
Re: proposal - psql - possibility to redirect only tabular output Pavel Stehule 03:27
Re: A patch for get origin from commit_ts. Movead Li 05:44
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Amit Kapila 06:04
Re: min_safe_lsn column in pg_replication_slots view Amit Kapila 06:18
Re: pgbench: option delaying queries till connections establishment? 📎 Fabien COELHO 06:34
Re: Missing "Up" navigation link between parts and doc root? Fabien COELHO 06:44
Re: Missing "Up" navigation link between parts and doc root? Fabien COELHO 06:47
Re: Cleanup - Removed unused function parameter in reorder buffer & parallel vacuum Amit Kapila 07:02
Re: Default setting for enable_hashagg_disk (hash_mem) Amit Kapila 09:19
Re: A patch for get origin from commit_ts. 📎 [email protected] 10:01
Re: warnings for invalid function casts 📎 Peter Eisentraut 11:36
Re: new heapcheck contrib module Dilip Kumar 13:04
Re: Resetting spilled txn statistics in pg_stat_replication Ajin Cherian 13:13
Re: POC: rational number type (fractions) Peter Eisentraut 13:29
Re: pg_read_file() with virtual files returns empty string Joe Conway 13:53
Re: warnings for invalid function casts Tom Lane 14:16
Re: POC and rebased patch for CSN based snapshots [email protected] 14:56
Re: pg_read_file() with virtual files returns empty string Justin Pryzby 16:39
Re: pg_read_file() with virtual files returns empty string Tom Lane 16:52
Re: pg_read_file() with virtual files returns empty string Joe Conway 17:10
Re: pg_read_file() with virtual files returns empty string Joe Conway 17:50
Re: Postgres Windows build system doesn't work with python installed in Program Files Juan José Santamaría Flecha 19:17
Re: Default setting for enable_hashagg_disk (hash_mem) Jeff Davis 20:53

July 5, 2020

Thread Author Time
Re: Cleanup - Removed unused function parameter in reorder buffer & parallel vacuum 📎 vignesh C 00:59
Re: Include access method in listTables output vignesh C 01:43
Re: Built-in connection pooler Jaime Casanova 04:17
Re: Persist MVCC forever - retain history Mitar 05:48
Re: suggest to rename enable_incrementalsort Peter Eisentraut 10:20
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 11:05
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 11:17
Re: Parallell hashjoin sometimes ignores temp_tablespaces Magnus Hagander 11:28
Re: proposal - function string_to_table 📎 Pavel Stehule 11:30
Re: doc: vacuum full, fillfactor, and "extra space" Daniel Gustafsson 11:35
Re: psql - improve test coverage from 41% to 88% Daniel Gustafsson 11:38
Re: [Patch] Invalid permission check in pg_stats for functional indexes Daniel Gustafsson 11:44
Re: Online verification of checksums Daniel Gustafsson 11:52
Re: TAP tests and symlinks on Windows Andrew Dunstan 12:18
Re: proposal: schema variables 📎 Pavel Stehule 13:33
Re: Built-in connection pooler Konstantin Knizhnik 13:46
Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... 📎 Anna Akenteva 14:02
Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... 📎 Anna Akenteva 14:12
Re: [Patch] Invalid permission check in pg_stats for functional indexes Tom Lane 14:16
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Dilip Kumar 15:07
Re: Ideas about a better API for postgres_fdw remote estimates Stephen Frost 17:06
Re: SQL/JSON: JSON_TABLE Justin Pryzby 17:15
Re: range_agg Justin Pryzby 17:20
Re: Inlining of couple of functions in pl_exec.c improves performance Tom Lane 17:21
Re: SQL/JSON: functions Justin Pryzby 17:29
Re: Persist MVCC forever - retain history Konstantin Knizhnik 17:31
Re: Default gucs for EXPLAIN Justin Pryzby 17:36
Re: Ideas about a better API for postgres_fdw remote estimates Tom Lane 17:36
Re: Ideas about a better API for postgres_fdw remote estimates Stephen Frost 17:48
Re: Persist MVCC forever - retain history Thomas Kellerer 19:08
Re: range_agg 📎 Paul A Jungwirth 19:11
Re: range_agg Paul A Jungwirth 19:25
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 19:50
Re: proposal: possibility to read dumped table's name from file Pavel Stehule 20:08
Re: Ideas about a better API for postgres_fdw remote estimates Tom Lane 20:25
Re: proposal: possibility to read dumped table's name from file Justin Pryzby 20:31
Re: [Patch] Invalid permission check in pg_stats for functional indexes Daniel Gustafsson 20:32
Re: proposal: possibility to read dumped table's name from file Pavel Stehule 20:37
Re: Binary support for pgoutput plugin Daniel Gustafsson 20:40
Re: vacuum verbose detail logs are unclear; log at *start* of each stage Daniel Gustafsson 20:48
Can I use extern "C" in an extension so I can use C++? Isaac Morland 20:53
Re: Online checksums verification in the backend Daniel Gustafsson 21:00
Re: Binary support for pgoutput plugin Alvaro Herrera 21:11
Re: Binary support for pgoutput plugin Daniel Gustafsson 21:28
Re: Can I use extern "C" in an extension so I can use C++? 📎 Tom Lane 22:07
Re: Can I use extern "C" in an extension so I can use C++? 📎 Isaac Morland 22:41
Re: Can I use extern "C" in an extension so I can use C++? Tom Lane 22:49
Re: Default setting for enable_hashagg_disk (hash_mem) Peter Geoghegan 23:47

July 6, 2020

Thread Author Time
Re: Postgres Windows build system doesn't work with python installed in Program Files Michael Paquier 00:20
Re: A patch for get origin from commit_ts. Michael Paquier 00:36
Re: Can I use extern "C" in an extension so I can use C++? Isaac Morland 00:47
Re: TAP tests and symlinks on Windows Michael Paquier 00:53
Re: Include access method in listTables output Michael Paquier 01:12
Re: Creating a function for exposing memory usage of backend process 📎 torikoshia 03:12
Re: A patch for get origin from commit_ts. 📎 [email protected] 03:12
Re: Cleanup - adjust the code crossing 80-column window limit Amul Sul 03:40
RE: archive status ".ready" files may be created too early [email protected] 04:02
Re: Cache lookup errors with functions manipulation object addresses Michael Paquier 04:11
Re: Cleanup - adjust the code crossing 80-column window limit Bharath Rupireddy 04:27
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 04:34
"tuple concurrently updated" in pg_restore --jobs Justin Pryzby 05:01
Re: proposal - function string_to_table 📎 Pavel Stehule 05:05
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi 05:13
Re: track_planning causing performance regression Fujii Masao 05:29
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 06:01
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 06:13
Re: Creating a function for exposing memory usage of backend process Fujii Masao 06:16
Re: Add Information during standby recovery conflicts 📎 Drouvot, Bertrand 06:41
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 07:36
Re: Cache lookup errors with functions manipulation object addresses 📎 Michael Paquier 07:45
Re: Include access method in listTables output 📎 Georgios 07:54
Re: A patch for get origin from commit_ts. Michael Paquier 08:01
Re: proposal: schema variables 📎 Pavel Stehule 08:17
Performing partition pruning using row value [email protected] 08:25
Re: Using Valgrind to detect faulty buffer accesses (no pin or buffer content lock held) Georgios Kokolatos 08:34
Re: Asymmetric partition-wise JOIN 📎 Andrey V. Lepikhov 08:46
Re: Parallel copy 📎 vignesh C 09:27
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 09:39
Re: Default setting for enable_hashagg_disk (hash_mem) Amit Kapila 10:29
Re: Autovacuum on partitioned table (autoanalyze) 📎 yuzuko 10:35
Proposal: Automatic partition creation 📎 Anastasia Lubennikova 10:45
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 11:45
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Bharath Rupireddy 11:49
Re: jsonpath versus NaN 📎 Alexander Korotkov 12:19
Re: Libpq support to connect to standby server as priority 📎 Greg Nancarrow 12:19
Re: WIP/PoC for parallel backup Daniel Gustafsson 12:24
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Bharath Rupireddy 12:29
Re: Inlining of couple of functions in pl_exec.c improves performance Amit Khandekar 12:29
Re: WIP/PoC for parallel backup Hamid Akhtar 12:39
Re: Yet another fast GiST build (typo) 📎 Andrey M. Borodin 12:55
Re: Binary support for pgoutput plugin Dave Cramer 12:58
Re: Binary support for pgoutput plugin Daniel Gustafsson 13:03
Re: Is it useful to record whether plans are generic or custom? Fujii Masao 13:16
Re: Binary support for pgoutput plugin Dave Cramer 13:35
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Ashutosh Bapat 13:37
Re: Ideas about a better API for postgres_fdw remote estimates Stephen Frost 14:11
Re: Cache lookup errors with functions manipulation object addresses Alvaro Herrera 14:56
Re: Proposal: Automatic partition creation Justin Pryzby 14:59
Re: Ideas about a better API for postgres_fdw remote estimates Tom Lane 15:05
bad status of FETCH PERCENT in commitfest application Pavel Stehule 15:23
Re: bad status of FETCH PERCENT in commitfest application Alvaro Herrera 15:27
Re: bad status of FETCH PERCENT in commitfest application Pavel Stehule 15:28
Re: Ideas about a better API for postgres_fdw remote estimates Stephen Frost 15:28
Re: min_safe_lsn column in pg_replication_slots view Alvaro Herrera 15:29
Re: [Proposal] Global temporary tables Pavel Stehule 15:31
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Robert Haas 15:37
Re: Allow continuations in "pg_hba.conf" files 📎 Fabien COELHO 15:38
Re: Proposal: Automatic partition creation Robert Haas 15:45
Re: Proposal: Automatic partition creation Tom Lane 16:10
Multi-byte character case-folding Thom Brown 17:35
Re: new heapcheck contrib module 📎 Mark Dilger 18:06
Question: PostgreSQL on Amazon linux EC2 Ajay Patel 19:54
Re: [bug] Table not have typarray when created by single user mode 📎 Tom Lane 20:22
Re: Multi-byte character case-folding Tom Lane 20:33
Re: Question: PostgreSQL on Amazon linux EC2 Flavio Henrique Araque Gurgel 20:45
Re: Question: PostgreSQL on Amazon linux EC2 Ajay Patel 21:30
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Alvaro Herrera 21:47
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Tom Lane 22:08
Re: posgres 12 bug (partitioned table) 📎 Soumyadeep Chakraborty 22:45
Re: Multi-byte character case-folding Alvaro Herrera 22:46

July 7, 2020

Thread Author Time
Re: Binary support for pgoutput plugin 📎 Dave Cramer 00:16
Re: Multi-byte character case-folding Tom Lane 00:32
Re: min_safe_lsn column in pg_replication_slots view 📎 Alvaro Herrera 00:54
Re: Parallel worker hangs while handling errors. vignesh C 01:26
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 01:36
Re: min_safe_lsn column in pg_replication_slots view Kyotaro Horiguchi 01:55
Re: A patch for get origin from commit_ts. 📎 [email protected] 02:02
change a function name in a comment correctly 📎 Masahiro Ikeda 02:50
Re: change a function name in a comment correctly Fujii Masao 03:00
Re: min_safe_lsn column in pg_replication_slots view Alvaro Herrera 03:01
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 03:10
Re: Implementing Incremental View Maintenance Andy Fan 03:11
Re: pg_resetwal --next-transaction-id may cause database failed to restart. 📎 [email protected] 03:22
Re: [Proposal] Global temporary tables 曾文旌 03:47
Re: Default setting for enable_hashagg_disk (hash_mem) Jeff Davis 03:48
Re: Default setting for enable_hashagg_disk (hash_mem) Jeff Davis 04:57
Re: Default setting for enable_hashagg_disk (hash_mem) Justin Pryzby 05:02
Re: A patch for get origin from commit_ts. 📎 Michael Paquier 05:35
Re: Cache lookup errors with functions manipulation object addresses Michael Paquier 05:49
Re: Parallel copy vignesh C 05:50
Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks 📎 Bharath Rupireddy 06:35
Re: Global snapshots Amit Kapila 06:40
Re: Cache lookup errors with functions manipulation object addresses Daniel Gustafsson 06:41
Re: some more pg_dump refactoring 📎 Peter Eisentraut 07:00
Re: Yet another fast GiST build (typo) 📎 Andrey M. Borodin 07:03
Quick doc patch 📎 Guillaume Lelarge 07:17
Re: Question: PostgreSQL on Amazon linux EC2 Flavio Henrique Araque Gurgel 07:20
Re: Implementing Incremental View Maintenance Tatsuo Ishii 07:26
Re: [PATCH] Performance Improvement For Copy From Binary Files 📎 Amit Langote 07:28
Re: Add Information during standby recovery conflicts Masahiko Sawada 07:43
Re: Quick doc patch Daniel Gustafsson 07:58
Re: [PATCH] Performance Improvement For Copy From Binary Files Amit Langote 08:16
Re: Resetting spilled txn statistics in pg_stat_replication Magnus Hagander 08:50
RE: archive status ".ready" files may be created too early [email protected] 09:02
Re: Performing partition pruning using row value Etsuro Fujita 09:30
Re: Quick doc patch Michael Paquier 09:36
Re: warnings for invalid function casts 📎 Peter Eisentraut 09:45
Re: Default setting for enable_hashagg_disk (hash_mem) Amit Kapila 09:50
Re: [Proposal] Global temporary tables Pavel Stehule 10:05
Re: Multi-byte character case-folding Daniel Verite 11:33
Re: Question: PostgreSQL on Amazon linux EC2 mailajaypatel 11:41
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎 David Rowley 12:32
Re: Default setting for enable_hashagg_disk (hash_mem) David Rowley 12:54
Re: Multi-byte character case-folding Tom Lane 13:01
Re: Creating a function for exposing memory usage of backend process 📎 torikoshia 13:02
Re: Added tab completion for the missing options in copy statement ahsan hadi 13:06
Re: Default setting for enable_hashagg_disk (hash_mem) Pavel Stehule 13:16
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Tom Lane 13:44
Re: Binary support for pgoutput plugin 📎 Daniel Gustafsson 14:01
Re: posgres 12 bug (partitioned table) 📎 Amit Langote 14:18
Re: Proposal: Automatic partition creation Robert Haas 14:22
Re: TLS checking in pgstat Magnus Hagander 15:01
Re: pg_resetwal --next-transaction-id may cause database failed to restart. Alvaro Herrera 15:06
Re: Cache lookup errors with functions manipulation object addresses Alvaro Herrera 15:08

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31