pgsql-hackers since 2020-01-07 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

Jan. 7, 2020

Thread	Author	Time
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema	Michael Paquier	00:22
Re: Setting min/max TLS protocol in clientside libpq	Michael Paquier	00:51
Re: RFC: seccomp-bpf support	Tomas Vondra	01:37
Re: Greatest Common Divisor	Fabien COELHO	02:33
Re: Recognizing superuser in pg_hba.conf	Tom Lane	02:36
Re: bitmaps and correlation	Dilip Kumar	03:51
Re: adding partitioned tables to publications 📎	Amit Langote	05:01
Re: bitmaps and correlation	Justin Pryzby	05:26
pg_repack failure	Nagaraj Raj	06:15
Re: pgsql: Add basic TAP tests for psql's tab-completion logic.	Amit Kapila	06:18
Re: pg_repack failure	Michael Paquier	06:46
Re: Fetching timeline during recovery	Kyotaro Horiguchi	06:57
Re: TRUNCATE on foreign tables	Michael Paquier	07:02
DROP OWNED CASCADE vs Temp tables	Mithun Cy	07:22
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly	Michael Paquier	08:05
Re: table partitioning and access privileges 📎	Amit Langote	08:15
Re: pgbench - use pg logging capabilities	Michael Paquier	08:24
Re: pgbench - use pg logging capabilities 📎	Fabien COELHO	09:32
Re: WIP: System Versioned Temporal Table	Kyotaro Horiguchi	10:32
Re: Errors when update a view with conditional-INSTEAD rules 📎	Dean Rasheed	11:00
Re: RFC: seccomp-bpf support	Joe Conway	11:02
Re: Greatest Common Divisor	Dean Rasheed	11:21
[Logical Replication] TRAP: FailedAssertion("rel->rd_rel->relreplident == REPLICA_IDENTITY_DEFAULT || rel->rd_rel->relreplident == REPLICA_IDENTITY_FULL || rel->rd_rel->relreplident == REPLICA_IDENTITY_INDEX"	Neha Sharma	12:08
Re: Greatest Common Divisor	Tom Lane	12:30
Re: RFC: seccomp-bpf support	Tomas Vondra	12:59
Re: reduce size of fmgr_builtins array	Heikki Linnakangas	13:08
Re: adding partitioned tables to publications	Rafia Sabih	14:18
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema	Robert Haas	15:59
Re: TRUNCATE on foreign tables	Kohei KaiGai	16:08
Re: [PATCH] Atomic pgrename on Windows	Tomas Vondra	16:16
Re: RFC: seccomp-bpf support	Robert Haas	16:33
[QUESTION/PROPOSAL] loose quadtree in spgist	Peter Griggs	16:33
Re: ERROR: attribute number 6 exceeds number of columns 5	Tom Lane	16:53
Re: Removing pg_pltemplate and creating "trustable" extensions	Robert Haas	17:08
Re: [PATCH] Increase the maximum value track_activity_query_size	Robert Haas	17:21
Re: ERROR: attribute number 6 exceeds number of columns 5 📎	Tom Lane	17:47
Re: RFC: seccomp-bpf support	Tomas Vondra	17:56
Re: Berserk Autovacuum (let's save next Mandrill)	Tomas Vondra	18:05
Re: backup manifests	Robert Haas	18:05
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema	Tom Lane	18:06
Re: Removing pg_pltemplate and creating "trustable" extensions	Stephen Frost	18:17
Re: [PATCH] Atomic pgrename on Windows	Alexander Korotkov	18:26
Re: [PATCH] Atomic pgrename on Windows	Tom Lane	18:40
Re: [PATCH] Atomic pgrename on Windows	Alexander Korotkov	18:54
Re: Removing pg_pltemplate and creating "trustable" extensions	Robert Haas	18:55
Re: RFC: seccomp-bpf support	Robert Haas	19:17
Re: tableam vs. TOAST	Robert Haas	19:38
Re: [PATCH] Atomic pgrename on Windows	Tom Lane	20:04
Re: jsonb_set() strictness considered harmful to data 📎	Pavel Stehule	20:37
Re: xact_start for walsender & logical decoding not updated	Alvaro Herrera	21:17
Re: Removing pg_pltemplate and creating "trustable" extensions	Stephen Frost	21:36
Re: pgsql: Add basic TAP tests for psql's tab-completion logic.	Tom Lane	22:28
Re: Proposal: Global Index	Nasby, Jim	22:55
Re: [QUESTION/PROPOSAL] loose quadtree in spgist	Tomas Vondra	22:56
Re: xact_start for walsender & logical decoding not updated	Tom Lane	23:07
Re: A rather hackish POC for alternative implementation of WITH TIES	Andrew Gierth	23:10
Re: xact_start for walsender & logical decoding not updated	Tom Lane	23:12
Re: Extracting only the columns needed for a query	Melanie Plageman	23:40
Re: Removing pg_pltemplate and creating "trustable" extensions	Robert Haas	23:49
Re: xact_start for walsender & logical decoding not updated 📎	Alvaro Herrera	23:52

Jan. 8, 2020

Thread	Author	Time
Re: Avoiding hash join batch explosions with extreme skew and weird stats	Thomas Munro	00:13
Re: Created feature for to_date() conversion using patterns 'YYYY-WW', 'YYYY-WW-D', 'YYYY-MM-W' and 'YYYY-MM-W-D'	Tom Lane	00:22
Re: Removing pg_pltemplate and creating "trustable" extensions	Stephen Frost	00:32
Re: xact_start for walsender & logical decoding not updated	Tom Lane	00:42
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema 📎	Michael Paquier	00:44
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema	Tom Lane	00:55
Re: mdclose() does not cope w/ FileClose() failure	Kyotaro Horiguchi	01:13
Re: backup manifests	Stephen Frost	01:33
Re: Make autovacuum sort tables in descending order of xid_age	David Kimura	01:40
Re: Consolidate 'unique array values' logic into a reusable function?	Thomas Munro	01:49
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema 📎	Michael Paquier	01:56
Re: [PATCH] Increase the maximum value track_activity_query_size	Michael Paquier	01:56
RE: Let people set host(no)ssl settings from initdb	[email protected]	02:53
Re: pgsql: Add basic TAP tests for psql's tab-completion logic.	Amit Kapila	02:59
Re: sidewinder has one failure	Amit Kapila	03:29
Re: [PATCH] lazy relations delete	Kyotaro Horiguchi	04:18
Re: [PATCH] lazy relations delete	Thomas Munro	04:56
Re: parallel vacuum options/syntax	Masahiko Sawada	06:01
Re: parallel vacuum options/syntax	Amit Kapila	06:31
Re: jsonb_set() strictness considered harmful to data	Andrew Dunstan	06:54
Re: [Proposal] Global temporary tables	曾文旌 (义从)	07:03
Re: Memory-Bounded Hash Aggregation 📎	Adam Lee	07:12
Re: Parallel grouping sets 📎	Richard Guo	07:24
Re: [HACKERS] pg_shmem_allocations view	Kyotaro Horiguchi	07:28
Re: parallel vacuum options/syntax	Masahiko Sawada	07:34
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	07:42
Re: Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings	Peter Eisentraut	09:06
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Amit Khandekar	09:20
Re: Improve checking for pg_index.xmin	Heikki Linnakangas	09:28
Re: Memory-Bounded Hash Aggregation	Heikki Linnakangas	10:38
Re: adding partitioned tables to publications	Peter Eisentraut	10:54
Re: adding partitioned tables to publications	Peter Eisentraut	10:57
Re: Fastpath while arranging the changes in LSN order in logical decoding	Heikki Linnakangas	11:58
Re: pgbench - use pg logging capabilities 📎	Fabien COELHO	12:07
Re: remove separate postgres.(sh)description files	Heikki Linnakangas	12:33
Re: Fastpath while arranging the changes in LSN order in logical decoding	Dilip Kumar	12:36
Re: [HACKERS] Block level parallel vacuum 📎	Amit Kapila	13:16
Re: sidewinder has one failure	Tom Lane	13:17
Re: parallel vacuum options/syntax	Amit Kapila	13:19
Re: pgbench - use pg logging capabilities	Peter Eisentraut	13:27
Fixing parallel make of libpq 📎	Dagfinn Ilmari Mannsåker	13:33
Re: Improve checking for pg_index.xmin	Tom Lane	13:37
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. 📎	Heikki Linnakangas	13:56
Re: pgbench - use pg logging capabilities	Fabien COELHO	14:02
Re: pgbench - use pg logging capabilities	Michael Paquier	14:12
Re: pgbench - use pg logging capabilities	Peter Eisentraut	14:31
src/test/recovery regression failure on bionic	Christoph Berg	14:38
Re: src/test/recovery regression failure on bionic	Tom Lane	15:04
Re: Modernizing SQL functions' result type coercions	Heikki Linnakangas	15:06
Re: Modernizing SQL functions' result type coercions	Tom Lane	15:22
Re: weird libpq GSSAPI comment	Stephen Frost	15:58
Re: Avoid full GIN index scan when possible 📎	Alexander Korotkov	16:31
Re: xact_start for walsender & logical decoding not updated	Alvaro Herrera	18:12
Re: xact_start for walsender & logical decoding not updated	Tom Lane	18:38
Re: More issues with expressions always false (no patch)	Andreas Karlsson	18:41
our checks for read-only queries are not great 📎	Robert Haas	19:09
Re: [QUESTION/PROPOSAL] loose quadtree in spgist	Peter Griggs	19:36
Re: our checks for read-only queries are not great	Tom Lane	19:57
Re: [QUESTION/PROPOSAL] loose quadtree in spgist	Tom Lane	20:07
Re: our checks for read-only queries are not great	Robert Haas	20:11
Re: our checks for read-only queries are not great	Tom Lane	20:26
Re: our checks for read-only queries are not great	Robert Haas	20:37
Re: WIP: System Versioned Temporal Table 📎	Vik Fearing	21:23
Re: remove support for old Python versions	Peter Eisentraut	22:04
Re: Recognizing superuser in pg_hba.conf	Peter Eisentraut	22:13
Re: src/test/recovery regression failure on bionic	Tom Lane	22:31
Re: Removing pg_pltemplate and creating "trustable" extensions	Robert Haas	22:49
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index.	Peter Geoghegan	22:56
Re: our checks for read-only queries are not great	Stephen Frost	22:57
Re: Removing pg_pltemplate and creating "trustable" extensions	Stephen Frost	23:09
Re: src/test/recovery regression failure on bionic	Andres Freund	23:22
Re: Recognizing superuser in pg_hba.conf	Vik Fearing	23:55

Jan. 9, 2020

Thread	Author	Time
Re: src/test/recovery regression failure on bionic	Tom Lane	00:18
Re: Removing pg_pltemplate and creating "trustable" extensions	Robert Haas	02:07
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Amit Kapila	02:12
Re: src/test/recovery regression failure on bionic	Amit Kapila	02:31
Re: remove support for old Python versions	Michael Paquier	03:09
Re: pgbench - use pg logging capabilities 📎	Michael Paquier	04:02
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	04:05
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema	Michael Paquier	04:06
Re: Patch to document base64 encoding	Karl O. Pinc	04:32
Re: NOT IN subquery optimization	Andrey Lepikhov	04:47
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	05:00
Re: [HACKERS] Block level parallel vacuum	Masahiko Sawada	05:10
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Noah Misch	05:37
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Tom Lane	05:45
Re: [Logical Replication] TRAP: FailedAssertion("rel->rd_rel->relreplident == REPLICA_IDENTITY_DEFAULT || rel->rd_rel->relreplident == REPLICA_IDENTITY_FULL || rel->rd_rel->relreplident == REPLICA_IDENTITY_INDEX"	Michael Paquier	06:08
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Amit Kapila	06:17
Re: Add pg_file_sync() to adminpack 📎	Fujii Masao	06:31
Re: Physical replication slot advance is not persistent 📎	Kyotaro Horiguchi	06:36
Re: Fixing parallel make of libpq	Michael Paquier	06:38
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	06:39
Re: Add pg_file_sync() to adminpack	Fujii Masao	06:43
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	07:10
Re: [Logical Replication] TRAP: FailedAssertion("rel->rd_rel->relreplident == REPLICA_IDENTITY_DEFAULT || rel->rd_rel->relreplident == REPLICA_IDENTITY_FULL || rel->rd_rel->relreplident == REPLICA_IDENTITY_INDEX"	Neha Sharma	07:20
Re: Patch to document base64 encoding	Fabien COELHO	07:27
Re: [Logical Replication] TRAP: FailedAssertion("rel->rd_rel->relreplident == REPLICA_IDENTITY_DEFAULT || rel->rd_rel->relreplident == REPLICA_IDENTITY_FULL || rel->rd_rel->relreplident == REPLICA_IDENTITY_INDEX"	Dilip Kumar	07:47
pgsql: Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings	Andrew Dunstan	08:11
Re: Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings	Andrew Dunstan	08:14
[PATCH] Resolve Parallel Hash Join Performance Issue 📎	Deng, Gang	08:53
Verify true root on replicas with amcheck 📎	godjan •	08:55
Re: Recognizing superuser in pg_hba.conf	Simon Riggs	09:07
Re: Add support for automatically updating Unicode derived files	Peter Eisentraut	09:16
Re: Unicode normalization SQL functions	Peter Eisentraut	09:20
Re: pgbench - use pg logging capabilities 📎	Fabien COELHO	09:28
Re: Change atoi to strtol in same place	Peter Eisentraut	09:49
Re: Remove libpq.rc, use win32ver.rc for libpq	Peter Eisentraut	09:56
Re: [PATCH] Resolve Parallel Hash Join Performance Issue	Thomas Munro	10:04
Re: remove some STATUS_* symbols	Peter Eisentraut	10:15
Re: adding partitioned tables to publications	Amit Langote	10:26
Re: [Logical Replication] TRAP: FailedAssertion("rel->rd_rel->relreplident == REPLICA_IDENTITY_DEFAULT || rel->rd_rel->relreplident == REPLICA_IDENTITY_FULL || rel->rd_rel->relreplident == REPLICA_IDENTITY_INDEX"	Rafia Sabih	10:28
Re: Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings	Christoph Berg	10:30
Re: [HACKERS] Block level parallel vacuum 📎	Amit Kapila	10:33
Re: Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings	Christoph Berg	10:45
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Amit Kapila	10:51
Re: base backup client as auxiliary backend process	Alexandra Wang	10:57
Re: Fixing parallel make of libpq	Dagfinn Ilmari Mannsåker	11:03
Re: Questions/Observations related to Gist vacuum	Mahendra Singh Thalor	11:11
Re: [Proposal] Global temporary tables	Konstantin Knizhnik	11:17
Re: [HACKERS] Block level parallel vacuum	Sergei Kornilov	12:01
Re: Error message inconsistency	MBeena Emerson	12:12
Re: Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings	Christoph Berg	12:48
Re: Add pg_file_sync() to adminpack	Julien Rouhaud	13:34
Re: Add pg_file_sync() to adminpack	Julien Rouhaud	13:39
Re: Fixing parallel make of libpq	Tom Lane	14:17
Re: pgsql: Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings	Robert Haas	14:18
Re: Fixing parallel make of libpq	Dagfinn Ilmari Mannsåker	14:35
Re: pgsql: Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings	Christoph Berg	14:38
Re: [PATCH] Resolve Parallel Hash Join Performance Issue	Tom Lane	14:43
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Alvaro Herrera	14:44
Re: pgsql: Add basic TAP tests for psql's tab-completion logic.	Robert Haas	14:45
Re: Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings	Robert Haas	14:51
Re: pgsql: Add basic TAP tests for psql's tab-completion logic.	Christoph Berg	14:59
Re: Recognizing superuser in pg_hba.conf	Tom Lane	15:06
Re: [Proposal] Global temporary tables	Konstantin Knizhnik	15:07
Re: Removing pg_pltemplate and creating "trustable" extensions	Stephen Frost	15:09
Re: Recognizing superuser in pg_hba.conf	Stephen Frost	15:17
Re: Patch to document base64 encoding 📎	Karl O. Pinc	15:23
Re: Recognizing superuser in pg_hba.conf	Robert Haas	15:24
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Tom Lane	15:25

Browse Archives

Prev | Next