pgsql-general - September 2020

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Sept. 1, 2020

Thread Author Time
Is it possible to set end-of-data marker for COPY statement. Junfeng Yang 06:14
Re: How bad is using queries with thousands of values for operators IN or ANY? 📎 Kyotaro Horiguchi 07:22
Re: Is it possible to set end-of-data marker for COPY statement. Laurenz Albe 09:06
回复: Is it possible to set end-of-data marker for COPY statement. Junfeng Yang 09:20
Re: 回复: Is it possible to set end-of-data marker for COPY statement. Laurenz Albe 09:37
回复: 回复: Is it possible to set end-of-data marker for COPY statement. Junfeng Yang 10:03
RE: [EXTERNAL] Re: Numeric data types Godfrin, Philippe E 13:06
Re: Trigger transaction isolation Dirk Lattermann 14:07
Re: Trigger transaction isolation Adrian Klaver 14:41
Re: Trigger transaction isolation Tom Lane 15:02
Re: Is it possible to set end-of-data marker for COPY statement. Bruce Momjian 16:05
Re: Is it possible to set end-of-data marker for COPY statement. David G. Johnston 16:30
Re: How bad is using queries with thousands of values for operators IN or ANY? Michael Lewis 16:35
Re: How bad is using queries with thousands of values for operators IN or ANY? Pavel Stehule 16:46
Re: High Availability, guarantee to use sync nodes Maksim Milyutin 17:10
Re: Is it possible to set end-of-data marker for COPY statement. Bruce Momjian 17:23
Re: Is it possible to set end-of-data marker for COPY statement. Bruce Momjian 17:25
Re: Is it possible to set end-of-data marker for COPY statement. Tom Lane 18:01

Sept. 2, 2020

Thread Author Time
Re: How bad is using queries with thousands of values for operators IN or ANY? Kyotaro Horiguchi 01:50
Reconstructing transaction content after the fact Lionel Bouton 15:45
Re: Reconstructing transaction content after the fact Tom Lane 16:50
Tuchanka Олег Самойлов 17:33
Re: Reconstructing transaction content after the fact Francisco Olarte 18:44
Re: Reconstructing transaction content after the fact Alvaro Herrera 19:26
Re: Reconstructing transaction content after the fact Tom Lane 19:35

Sept. 3, 2020

Thread Author Time
Re: SSL between Primary and Seconday PostgreSQL DBs Peter Eisentraut 05:01
Re: Trigger transaction isolation Dirk Lattermann 06:20
pg_restore causing deadlocks on partitioned tables Domagoj Smoljanovic 09:46
Fix typo in Comments of HandleProcSignalBarrierInterrupt 📎 Hou, Zhijie 10:43
Re: SSL between Primary and Seconday PostgreSQL DBs Susan Joseph 10:54
Re: BUG? Slave don't reconnect to the master Jehan-Guillaume de Rorthais 11:39
Re: SSL between Primary and Seconday PostgreSQL DBs o1bigtenor 11:41
Re: SSL between Primary and Seconday PostgreSQL DBs Wim Bertels 11:44
Re: SSL between Primary and Seconday PostgreSQL DBs Susan Joseph 12:01
Re: SSL between Primary and Seconday PostgreSQL DBs Stephen Frost 12:28
Re: SSL between Primary and Seconday PostgreSQL DBs Susan Joseph 12:55
Re: SSL between Primary and Seconday PostgreSQL DBs Stephen Frost 13:07
Re: SSL between Primary and Seconday PostgreSQL DBs Susan Joseph 13:09
Re: SSL between Primary and Seconday PostgreSQL DBs Stephen Frost 13:12
How to enumerate partitions from a window function? Alban Hertroys 13:12
Default server PORT not updating in Pgadmin Rodrigo Martins 13:16
Re: ODBC Driver dsplay name Siva postgres 13:42
Re: SSL between Primary and Seconday PostgreSQL DBs Susan Joseph 13:47
Re: SSL between Primary and Seconday PostgreSQL DBs Peter Eisentraut 13:59
Re: How to enumerate partitions from a window function? Tom Lane 14:01
Re: Tuchanka Jehan-Guillaume de Rorthais 14:25
Re: How to enumerate partitions from a window function? Alban Hertroys 14:35
Dependency problem using community repo on Redhat 7 Lawrence Layhee 18:31
Re: How to enumerate partitions from a window function? Michael Lewis 18:58

Sept. 4, 2020

Thread Author Time
how to get top plan of GatherMerge in OSS10 Yang, Rong 08:20
Re: How to enumerate partitions from a window function? Alban Hertroys 08:41
Implement a new data type mohand oubelkacem makhoukhene 10:45
Aw: Implement a new data type Karsten Hilbert 10:59
Re: how to get top plan of GatherMerge in OSS10 David Rowley 10:59
Bitmap scan seem like such a strange choice when "limit 1" Klaudie Willis 11:42
Re: Bitmap scan seem like such a strange choice when "limit 1" Laurenz Albe 12:14
Re: Bitmap scan seem like such a strange choice when "limit 1" Klaudie Willis 13:01
Check for duplicates before inserting new rows Rich Shepard 13:21
Re: Check for duplicates before inserting new rows George Woodring 13:27
Re: Check for duplicates before inserting new rows Rich Shepard 14:40
Re: Bitmap scan seem like such a strange choice when "limit 1" Tom Lane 14:41
Re: Check for duplicates before inserting new rows Rich Shepard 14:46
Re: Dependency problem using community repo on Redhat 7 Adrian Klaver 14:56
Can I get some advice regarding logical replication server? Sang Gyu Kim 15:31
Re: Check for duplicates before inserting new rows Chris Sterritt 15:51
Re: Check for duplicates before inserting new rows Chris Sterritt 16:13
Re: Dependency problem using community repo on Redhat 7 Devrim Gündüz 16:17
Re: Check for duplicates before inserting new rows Rich Shepard 16:49
Re: 12.3 replicas falling over during WAL redo Ben Chobot 17:03
Re: Bitmap scan seem like such a strange choice when "limit 1" Michael Lewis 17:12

Sept. 5, 2020

Thread Author Time
Re: ODBC Driver dsplay name Peter J. Holzer 12:31

Sept. 6, 2020

Thread Author Time
Re: Fix typo in Comments of HandleProcSignalBarrierInterrupt Magnus Hagander 17:27

Sept. 7, 2020

Thread Author Time
Fw: Re: Bitmap scan seem like such a strange choice when "limit 1" Klaudie Willis 07:06
Fw: Re: Bitmap scan seem like such a strange choice when "limit 1" Klaudie Willis 07:09
compatibility matrix between client and server Matthias Apitz 09:22
Extensión pldebugger para Postgresql 12 en Centos 7, no encontrada Lucas Luengas 13:16
Re: compatibility matrix between client and server Laurenz Albe 14:06
Re: compatibility matrix between client and server Ron 16:39
Re: BUG? Slave don't reconnect to the master 📎 Олег Самойлов 20:46
Re: Tuchanka Олег Самойлов 20:51
Re: Extensión pldebugger para Postgresql 12 en Centos 7, no encontrada Diego 21:44

Sept. 8, 2020

Thread Author Time
回复: Is it possible to set end-of-data marker for COPY statement. Junfeng Yang 01:53
Autovacuum of independent tables Michael Holzman 07:32
Re: Autovacuum of independent tables Pavel Stehule 07:45
Re: Autovacuum of independent tables Michael Holzman 08:16
Re: Autovacuum of independent tables Michael Paquier 08:27
Re: Autovacuum of independent tables Michael Holzman 08:42
Re: Autovacuum of independent tables Pavel Stehule 09:27
Re: Autovacuum of independent tables Michael Holzman 10:13
Re: Autovacuum of independent tables Ravi Krishna 10:52
Re: Autovacuum of independent tables Michael Holzman 11:48
Re: Autovacuum of independent tables Ravi Krishna 12:17
Re: Autovacuum of independent tables Ravi Krishna 12:19
Re: Autovacuum of independent tables Magnus Hagander 13:25
Re: Autovacuum of independent tables Michael Holzman 14:00
Re: Autovacuum of independent tables Magnus Hagander 14:17
Re: Autovacuum of independent tables Tom Lane 14:38
Re: Autovacuum of independent tables Magnus Hagander 14:46
Re: Autovacuum of independent tables Ron 14:47
Re: Autovacuum of independent tables Michael Holzman 14:47
Re: Autovacuum of independent tables Michael Holzman 15:00
Re: Autovacuum of independent tables Tom Lane 15:15
Re: Autovacuum of independent tables Magnus Hagander 15:33
Re: Autovacuum of independent tables Michael Holzman 15:34
Re: Autovacuum of independent tables Michael Holzman 15:38

Sept. 9, 2020

Thread Author Time
Network performance optimization J . Mageshwaran 04:59
Re: Network performance optimization Fabio Pardi 09:08
Re: Network performance optimization Fabio Ugo Venchiarutti 11:05
Schema/ROLE Rename Issue Brajendra Pratap Singh 11:34
Re: Autovacuum of independent tables Stephen Frost 13:59
Re: Schema/ROLE Rename Issue Laurenz Albe 14:09
Re: Schema/ROLE Rename Issue Brajendra Pratap Singh 14:20
Re: BUG? Slave don't reconnect to the master Jehan-Guillaume de Rorthais 15:19
Unexpected results when using GROUP BY GROUPING SETS and bind variables Aner Perez 15:33
Re: Unexpected results when using GROUP BY GROUPING SETS and bind variables Tom Lane 17:13
Re: Network performance optimization Francisco Olarte 17:18
Re: Unexpected results when using GROUP BY GROUPING SETS and bind variables Aner Perez 18:37
Re: Unexpected results when using GROUP BY GROUPING SETS and bind variables Tom Lane 18:45
Re: Unexpected results when using GROUP BY GROUPING SETS and bind variables Aner Perez 18:58

Sept. 10, 2020

Thread Author Time
Oracle Associate Array conversion to PostgreSQL JAGMOHAN KAINTURA 05:09
Re: Oracle Associate Array conversion to PostgreSQL Pavel Stehule 05:25
how to check PEM version Atul Kumar 08:49
Re: how to check PEM version Ashesh Vashi 09:40
PKEY getting corrupted Abraham, Danny 10:43
Return value of CREATE TABLE Mike Martin 12:06
PG13 partitioned table logical replication Nicolas Sornin 12:13
Re: Return value of CREATE TABLE Christoph Moench-Tegeder 12:16
Re: Return value of CREATE TABLE Mike Martin 12:36
Re: PKEY getting corrupted Philip Semanchuk 13:05
Re: PKEY getting corrupted Adrian Klaver 13:28
Re: PKEY getting corrupted Alvaro Herrera 13:34
Re: PG13 partitioned table logical replication Peter Eisentraut 15:03
Re: how to check PEM version Diego 15:36

Sept. 11, 2020

Thread Author Time
RE: PG13 partitioned table logical replication Nicolas Sornin 06:41
Error During Recover Krishanu Maity 07:47
Feature Request pgadmin4 support more storage backends for servers/user data Anthony Somerset 14:25
Inserting many rows using "with" Harmen 15:33
Re: Feature Request pgadmin4 support more storage backends for servers/user data Adrian Klaver 17:20
Re: Inserting many rows using "with" Brian Dunavant 17:43

Sept. 12, 2020

Thread Author Time
How to call JSONB_INSERT with integer as the new to-be-inserted value? Alexander Farber 20:54
Re: How to call JSONB_INSERT with integer as the new to-be-inserted value? Steve Baldwin 21:20
Re: How to call JSONB_INSERT with integer as the new to-be-inserted value? Tom Lane 21:26

Sept. 13, 2020

Thread Author Time
Re: How to call JSONB_INSERT with integer as the new to-be-inserted value? Alexander Farber 07:53
Dirty buffers with suppress_redundant_updates_trigger Mike Noordermeer 11:49

Sept. 14, 2020

Thread Author Time
Re: Dirty buffers with suppress_redundant_updates_trigger Laurenz Albe 04:03
Re: Dirty buffers with suppress_redundant_updates_trigger Mike Noordermeer 04:32
Re: Dirty buffers with suppress_redundant_updates_trigger Mike Noordermeer 04:51
Reg:CHARSET_COVERSION_LATIN_TO_UTF8 nandha kumar 05:17
Re: Dirty buffers with suppress_redundant_updates_trigger Mike Noordermeer 05:53
Why SELECT COUNT(*) takes so long? Matthias Apitz 06:09
Re: Why SELECT COUNT(*) takes so long? Christophe Pettus 06:11
Re: Reg:CHARSET_COVERSION_LATIN_TO_UTF8 Magnus Hagander 08:08
Effective IO Concurrency luis.roberto 13:39
Re: Dirty buffers with suppress_redundant_updates_trigger Mike Noordermeer 15:12
Re: Dirty buffers with suppress_redundant_updates_trigger Michael Lewis 15:35
Re: Effective IO Concurrency Laurenz Albe 16:03
Re: Effective IO Concurrency Ron 16:10
Re: Dirty buffers with suppress_redundant_updates_trigger Mike Noordermeer 16:15
Re: Effective IO Concurrency luis.roberto 16:25
Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem? tutiluren 20:22
Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem? Guyren Howe 20:26
Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem? Guyren Howe 20:30
Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem? Ravi Krishna 20:31
Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem? Tom Lane 21:39

Sept. 15, 2020

Thread Author Time
Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem? raf 00:05
Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem? Tom Lane 00:26
multiple tables got corrupted Vasu Madhineni 09:00
Re: multiple tables got corrupted Magnus Hagander 09:36
Re: multiple tables got corrupted Vasu Madhineni 10:46
How to calculate shared memory size Rébeli-Szabó Tamás 14:12
How to calculate shared memory size Rébeli-Szabó Tamás 14:15
Re: How to calculate shared memory size Tom Lane 14:49
Re: multiple tables got corrupted Magnus Hagander 17:58

Sept. 16, 2020

Thread Author Time
Re: multiple tables got corrupted Vasu Madhineni 03:05
Obvious data mismatch in View2 which basically SELECT * from View1 Ben 03:40
Problems with MemoryContextSwitchTo () 📎 Yessica Brinkmann 04:42
Re: Obvious data mismatch in View2 which basically SELECT * from View1 Magnus Hagander 07:35
Re: Obvious data mismatch in View2 which basically SELECT * from View1 Ron 07:35
Re: Problems with MemoryContextSwitchTo () Yessica Brinkmann 11:31
Re: Problems with MemoryContextSwitchTo () Pavel Stehule 11:46
Re: Obvious data mismatch in View2 which basically SELECT * from View1 Ben 11:47
Re: Problems with MemoryContextSwitchTo () 📎 Yessica Brinkmann 13:03
Re: Problems with MemoryContextSwitchTo () 📎 Yessica Brinkmann 13:09
Re: Problems with MemoryContextSwitchTo () Pavel Stehule 13:15

Sept. 17, 2020

Thread Author Time
Re: Obvious data mismatch in View2 which basically SELECT * from View1 Ben 00:45
Re: Problems with MemoryContextSwitchTo () Yessica Brinkmann 01:15
Re: Problems with MemoryContextSwitchTo () Pavel Stehule 04:09
Re: Problems with MemoryContextSwitchTo () Pavel Stehule 06:03
PostgreSQL processes use large amount of private memory on Windows Øystein Kolsrud 09:19
Re: Problems with MemoryContextSwitchTo () 📎 Yessica Brinkmann 10:46
Re: PostgreSQL processes use large amount of private memory on Windows Thomas Kellerer 11:08
Re: Obvious data mismatch in View2 which basically SELECT * from View1 Ravi Krishna 12:26
Re: PostgreSQL processes use large amount of private memory on Windows Tom Lane 14:06
Re: Obvious data mismatch in View2 which basically SELECT * from View1 Jerry Sievers 14:41
Re: PostgreSQL processes use large amount of private memory on Windows Peter J. Holzer 17:26
Re: Obvious data mismatch in View2 which basically SELECT * from View1 Ben 17:38
Re: Obvious data mismatch in View2 which basically SELECT * from View1 Tom Lane 18:59
Postgres as a service for supporting common application users Shaozhong SHI 22:59
Postgres as a service for supporting common application users Shaozhong SHI 23:04

Sept. 18, 2020

Thread Author Time
Re: PostgreSQL processes use large amount of private memory on Windows raf 00:45

Browse Archives

Prev | Next