pgsql-hackers since 2019-09-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)

Advanced Search

Browse Archives

Prev | Next

Sept. 22, 2019

Thread	Author	Time
Re: range_agg 📎	Paul A Jungwirth	04:50
Re: pgbench - allow to create partitioned tables	Amit Kapila	05:07
Re: pgbench - allow to create partitioned tables	Fabien COELHO	06:52
Re: The flinfo->fn_extra question, from me this time.	Dent John	10:40
Re: Wrong results using initcap() with non normalized string 📎	Juan José Santamaría Flecha	11:15
Re: Unwanted expression simplification in PG12b2	Darafei Komяpa Praliaskouski	11:47
Re: Allow to_date() and to_timestamp() to accept localized names 📎	Juan José Santamaría Flecha	12:33
Re: Index Skip Scan 📎	Dmitry Dolgov	13:45
Re: The flinfo->fn_extra question, from me this time.	Tom Lane	15:01
Re: WAL recycled despite logical replication slot	Jeff Janes	15:32
Re: WAL recycled despite logical replication slot	Jeff Janes	15:45
Re: [PATCH] Improve performance of NOTIFY over many databases (v2)	Tom Lane	15:48
Re: Wrong sentence in the README?	Tom Lane	16:28
JSONPATH documentation	Jeff Janes	18:18
Re: [bug fix??] Fishy code in tts_cirtual_copyslot()	Tom Lane	18:24
Re: JSONPATH documentation	Jeff Janes	20:36
Re: JSONPATH documentation	Alexander Korotkov	20:56
Re: Efficient output for integer types 📎	David Fetter	21:58
Re: JSONPATH documentation	Tom Lane	22:03
Re: scorpionfly needs more semaphores	Thomas Munro	22:29
Re: strong memory leak in plpgsql from handled rollback and lazy cast	Tom Lane	22:43
Re: JSONPATH documentation	Alexander Korotkov	23:03
Re: WAL recycled despite logical replication slot	Andres Freund	23:37
Re: strong memory leak in plpgsql from handled rollback and lazy cast	Andres Freund	23:57

Sept. 23, 2019

Thread	Author	Time
Re: strong memory leak in plpgsql from handled rollback and lazy cast	Tom Lane	00:16
Re: strong memory leak in plpgsql from handled rollback and lazy cast	Andres Freund	01:59
Re: Index Skip Scan	Alvaro Herrera	02:02
Re: pgbench - allow to create partitioned tables	Amit Kapila	02:53
Re: row filtering for logical replication	movead li	04:59
Re: pgbench - allow to create partitioned tables 📎	Fabien COELHO	06:28
Re:PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node	Thunder	07:48
Re: Global temporary tables	Konstantin Knizhnik	07:57
Re: Efficient output for integer types	Tels	08:28
Re: pgbench - allow to create partitioned tables	Amit Kapila	09:16
Re: Attempt to consolidate reading of XLOG page 📎	Antonin Houska	10:44
Re: Hi guys, HELP please	Tomas Vondra	11:42
Re: PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node	Tomas Vondra	11:45
Re: Efficient output for integer types	Andrew Gierth	12:16
Re: Unwanted expression simplification in PG12b2	Robert Haas	12:58
Proposal: Better query optimization for "NOT IN" clause 📎	John Bester	13:43
Re: [proposal] de-TOAST'ing using a iterator 📎	Binguo Bao	13:55
Re: Commit fest 2019-09	Alvaro Herrera	15:12
Re: Wrong sentence in the README?	Daniel Westermann (DWE)	15:18
overhead due to casting extra parameters with aggregates (over and over)	Tomas Vondra	15:56
Re: pg_upgrade check fails on Solaris 10	Marina Polyakova	15:57
Re: pg_upgrade check fails on Solaris 10	Alvaro Herrera	16:41
Re: [proposal] de-TOAST'ing using a iterator	Alvaro Herrera	16:45
Re: Global temporary tables	Pavel Stehule	16:50
Re: JSONPATH documentation	Steven Pousty	16:52
Re: overhead due to casting extra parameters with aggregates (over and over)	Tom Lane	16:53
Re: overhead due to casting extra parameters with aggregates (over and over)	Tomas Vondra	17:44
Re: JSONPATH documentation	Alexander Korotkov	18:06
Re: scorpionfly needs more semaphores	Mikael Kjellström	18:34
Re: Support for jsonpath .datetime() method 📎	Alexander Korotkov	19:05
Re: JSONPATH documentation	Steven Pousty	19:10
Re: Cache lookup errors with functions manipulation object addresses	Dmitry Dolgov	19:15
Re: Proposal: Better query optimization for "NOT IN" clause	legrand legrand	19:25
Re: JSONPATH documentation	Alexander Korotkov	19:29
Re: JSONPATH documentation	Steven Pousty	19:52
Re: Psql patch to show access methods info 📎	Alexander Korotkov	19:54
Re: subscriptionCheck failures on nightjar	Andrew Dunstan	20:12
Re: Efficient output for integer types	David Fetter	20:25
[PATCH] Sort policies and triggers by table name in pg_dump. 📎	Benjie Gillam	21:34
Re: Efficient output for integer types 📎	David Fetter	21:35
Re: scorpionfly needs more semaphores	Jungle Boogie	21:43
Re: Attempt to consolidate reading of XLOG page	Alvaro Herrera	22:00
Re: Attempt to consolidate reading of XLOG page 📎	Alvaro Herrera from 2ndQuadrant	22:00
Re: Cache lookup errors with functions manipulation object addresses 📎	Michael Paquier	23:58
RE: [bug fix??] Fishy code in tts_cirtual_copyslot()	Tsunakawa, Takayuki	23:59

Sept. 24, 2019

Thread	Author	Time
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. 📎	Peter Geoghegan	00:13
Re: Unwanted expression simplification in PG12b2	Finnerty, Jim	01:19
Re: PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node 📎	Michael Paquier	01:40
Fix example in partitioning documentation 📎	Amit Langote	01:52
Re: [PATCH] Sort policies and triggers by table name in pg_dump.	Michael Paquier	02:02
Re: Add "password_protocol" connection parameter to libpq	Michael Paquier	02:07
Re: Fix example in partitioning documentation	Michael Paquier	02:14
Re: Custom reloptions and lock modes 📎	Michael Paquier	02:33
Re: Fix example in partitioning documentation	Amit Langote	02:36
Re: [PATCH] src/test/modules/dummy_index -- way to test reloptions from inside of access method 📎	Michael Paquier	02:39
Re: PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node	Kyotaro Horiguchi	03:46
Re: Efficient output for integer types 📎	David Fetter	04:30
Re: Memory Accounting	Michael Paquier	05:21
recovery starting when backup_label exists, but not recovery.signal	Fujii Masao	05:25
Re: Efficient output for integer types 📎	David Fetter	05:26
Re: PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node	Kyotaro Horiguchi	05:48
Re: Option to dump foreign data in pg_dump	Surafel Temesgen	06:25
Re: Cache lookup errors with functions manipulation object addresses	Kyotaro Horiguchi	06:25
Re: pg_upgrade check fails on Solaris 10	Marina Polyakova	07:00
PostgreSQL12 and older versions of OpenSSL	Victor Wagner	07:18
Re: Hypothetical indexes using BRIN broken since pg10	Julien Rouhaud	07:20
Re: [PATCH] Sort policies and triggers by table name in pg_dump. 📎	Benjie Gillam	07:48
Re: Index Skip Scan	Kyotaro Horiguchi	08:35
Re: [PATCH] Speedup truncates of relation forks	Fujii Masao	08:40
Re: Index Skip Scan	Kyotaro Horiguchi	08:41
Re: abort-time portal cleanup	Amit Kapila	09:30
log message in proto.c 📎	Fujii Masao	09:41
Re: PostgreSQL12 and older versions of OpenSSL	Michael Paquier	09:49
Re: Option to dump foreign data in pg_dump	Luis Carril	09:52
Re: PostgreSQL12 and older versions of OpenSSL 📎	Victor Wagner	10:07
Re: abort-time portal cleanup	Dilip Kumar	10:34
Re: Optimze usage of immutable functions as relation	rmrodriguez	11:39
Excessive disk usage in WindowAgg	Andrew Gierth	11:49
Re: Memory Accounting	Tomas Vondra	12:05
Re: Index Skip Scan	Alvaro Herrera	12:06
Re: [PATCH] src/test/modules/dummy_index -- way to test reloptions from inside of access method	Alvaro Herrera	12:25
Re: dropdb --force	Amit Kapila	12:52
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎	Alexey Kondratov	13:02
Re: pgbench - allow to create partitioned tables 📎	Fabien COELHO	13:29
Re: [PATCH] src/test/modules/dummy_index -- way to test reloptions from inside of access method	Nikolay Shaplov	13:49
DROP SUBSCRIPTION with no slot	Jeff Janes	14:31
Re: PostgreSQL12 and older versions of OpenSSL	Alvaro Herrera	15:13
Re: Optimze usage of immutable functions as relation	Tom Lane	15:17
Re: [PATCH] src/test/modules/dummy_index -- way to test reloptions from inside of access method	Nikolay Shaplov	15:20
Re: PostgreSQL12 and older versions of OpenSSL	Tom Lane	15:25
Re: Attempt to consolidate reading of XLOG page	Antonin Houska	15:33
Re: [PATCH] src/test/modules/dummy_index -- way to test reloptions from inside of access method	Alvaro Herrera	15:38
Re: FETCH FIRST clause WITH TIES option	Alvaro Herrera	15:48
Re: dropdb --force	vignesh C	15:51
Re: [HACKERS] advanced partition matching algorithm for partition-wise join 📎	Etsuro Fujita	15:59
Re: Unwanted expression simplification in PG12b2	Robert Haas	16:01
Re: PostgreSQL12 and older versions of OpenSSL	Tom Lane	16:43
Re: log message in proto.c	Robert Haas	17:15
Re: WIP/PoC for parallel backup	Robert Haas	17:53
Re: Take skip header out of a loop in COPY FROM	Tom Lane	18:04
Re: The flinfo->fn_extra question, from me this time.	Robert Haas	18:09
Re: Memory Accounting	Melanie Plageman	18:46
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. 📎	Peter Geoghegan	19:41
Re: Attempt to consolidate reading of XLOG page	Alvaro Herrera	19:50
Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown)	Alvaro Herrera	20:12
Re: allocation limit for encoding conversion 📎	Tom Lane	20:19
Re: abort-time portal cleanup	Andres Freund	20:45
Re: JSONPATH documentation	Peter Eisentraut	21:08
Improving on MAX_CONVERSION_GROWTH	Tom Lane	21:14
Re: DROP SUBSCRIPTION with no slot	Peter Eisentraut	21:25
Release 11 of PostgreSQL Buildfarm client	Andrew Dunstan	21:26
Re: allocation limit for encoding conversion	Andres Freund	21:42
Re: PostgreSQL12 and older versions of OpenSSL	Peter Eisentraut	21:52
Re: Hypothetical indexes using BRIN broken since pg10	Alvaro Herrera	21:53
Re: [bug fix??] Fishy code in tts_cirtual_copyslot()	Andres Freund	21:57
Re: allocation limit for encoding conversion	Tom Lane	22:09
Re: Bug in GiST paring heap comparator 📎	Nikita Glukhov	22:19
Re: DROP SUBSCRIPTION with no slot	Ziga	22:41
Re: Bug in GiST paring heap comparator	Alexander Korotkov	22:57
Re: allocation limit for encoding conversion	Andres Freund	22:57
Re: FETCH FIRST clause WITH TIES option	Tom Lane	22:57
Re: DROP SUBSCRIPTION with no slot	Jeff Janes	23:07
Re: DROP SUBSCRIPTION with no slot	Jeff Janes	23:22
RE: [PATCH] Speedup truncates of relation forks	Jamison, Kirk	23:57

Sept. 25, 2019

Thread	Author	Time
Re: Memory Accounting	Michael Paquier	00:47
Re: Index Skip Scan	Kyotaro Horiguchi	01:03
Re: Custom reloptions and lock modes	Michael Paquier	01:23
Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown)	Paul Guo	02:03
Re: dropdb --force	Amit Kapila	02:13
Re: [PATCH] src/test/modules/dummy_index -- way to test reloptions from inside of access method	Michael Paquier	02:15
Re: [PATCH] src/test/modules/dummy_index -- way to test reloptions from inside of access method	Michael Paquier	03:13
Re: PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node	Michael Paquier	03:24
Re: range test for hash index?	Amit Kapila	03:37
Re: dropdb --force	vignesh C	04:37
Re: Fix example in partitioning documentation	Michael Paquier	04:47
Re: Cache lookup errors with functions manipulation object addresses	Michael Paquier	05:02
Re: Hypothetical indexes using BRIN broken since pg10	Julien Rouhaud	05:03
Re: allow online change primary_conninfo 📎	Kyotaro Horiguchi	05:19
Re: Fix example in partitioning documentation	Amit Langote	05:36
Re: Remove page-read callback from XLogReaderState. 📎	Kyotaro Horiguchi	06:50
Re: PostgreSQL12 and older versions of OpenSSL	Michael Paquier	06:55
Re: PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node	Kyotaro Horiguchi	06:55
Re: [PATCH] Sort policies and triggers by table name in pg_dump.	Michael Paquier	07:15
Re: [PATCH] Sort policies and triggers by table name in pg_dump.	Benjie Gillam	07:36
Re: Index Skip Scan 📎	Dmitry Dolgov	09:34
Re: Batch insert in CTAS/MatView code	Asim R P	10:39
PostgreSQL 12 RC1 Press Release Draft 📎	Jonathan S. Katz	10:42
Re: PostgreSQL 12 RC1 Press Release Draft	Sehrope Sarkuni	10:50
Re: PostgreSQL 12 RC1 Press Release Draft 📎	Jonathan S. Katz	11:08
Re: row filtering for logical replication	Euler Taveira	11:08
Re: Zedstore - compressed in-core columnar storage 📎	Ashutosh Sharma	11:09
Re: Cache lookup errors with functions manipulation object addresses	Alvaro Herrera	12:17
Re: Cache lookup errors with functions manipulation object addresses	Alvaro Herrera	12:21
Re: PostgreSQL 12 RC1 Press Release Draft	Erikjan Rijkers	12:21
Re: backup manifests	vignesh C	12:46
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	13:25
Proposal for syntax to support creation of partition tables when creating parent table 📎	Muhammad Usama	14:31
Re: JSONPATH documentation 📎	Liudmila Mantrova	14:46
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. 📎	Anastasia Lubennikova	15:05
Re: Proposal for syntax to support creation of partition tables when creating parent table	Fabien COELHO	15:22
Re: Proposal for syntax to support creation of partition tables when creating parent table	Tom Lane	15:53
Re: PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node	Fujii Masao	16:13
Re: PostgreSQL 12 RC1 Press Release Draft	Jonathan S. Katz	17:28
Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown)	Alvaro Herrera	17:48
Re: DROP SUBSCRIPTION with no slot	Žiga Kranjec	17:55
Re: DROP SUBSCRIPTION with no slot	Isaac Morland	18:41
Re: Proposal for syntax to support creation of partition tables when creating parent table	Ahsan Hadi	18:46
Re: [PATCH][PROPOSAL] Add enum releation option type	Alvaro Herrera	18:59
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index.	Peter Geoghegan	19:14
Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown)	Laurenz Albe	19:26
Re: Control your disk usage in PG: Introduction to Disk Quota Extension	Alvaro Herrera	19:54
Re: Support for jsonpath .datetime() method 📎	Alexander Korotkov	19:55
Re: add a MAC check for TRUNCATE	Alvaro Herrera	19:56
Re: Allow to_date() and to_timestamp() to accept localized names	Alvaro Herrera	19:57
Re: Don't codegen deform code for virtual tuples in expr eval for scan fetch	Andres Freund	20:02
Re: Add FOREIGN to ALTER TABLE in pg_dump	Alvaro Herrera	20:04

Browse Archives

Prev | Next