Mailing lists [pgsql-general]

1 September 2021

• 11:36   Question about creation of a new PostgreSQL Extension. A Z
• 11:55   Re: dup(0) fails on Ubuntu 20.04 and macOS 10.15 with 13.0 Mario Emmenlauer
• 13:48   oldest WAL files not removed 
• 14:44   Re: New Server for PostgreSQL sivapostgres@yahoo.com
• 15:31    obi reddy
• 15:51   Re: Igor Korot
• 15:57   Re: obi reddy
• 16:17   Re: Igor Korot
• 17:37   Re: obi reddy
• 18:08   PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent FOUTE K. Jaurès
• 18:09   Re: Igor Korot
• 18:12   Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent Rob Sargent
• 18:14   Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent FOUTE K. Jaurès
• 18:18   Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent Rob Sargent
• 18:25   Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent David G. Johnston
• 18:27   Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent Adrian Klaver
• 18:29   Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent FOUTE K. Jaurès
• 18:35   Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent FOUTE K. Jaurès
• 18:40   Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent David G. Johnston
• 18:46   Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent Tom Lane
• 19:54   Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent FOUTE K. Jaurès
• 19:59   Re: PostgreSQL 12 - ERROR: invalid attribute number 2 for ad_user_pkey - Urgent FOUTE K. Jaurès
• 23:34   datfrozenxid not dropping after vacuum Matthew Tice

2 September 2021

• 00:00   Re: datfrozenxid not dropping after vacuum Alvaro Herrera
• 01:01   Re: datfrozenxid not dropping after vacuum Matthew Tice
• 05:40   Re: oldest WAL files not removed Kyotaro Horiguchi
• 08:50   No xmin in pg_database Alexander Kass
• 09:13   calling store procedure / insert statement never complete Trang Le
• 09:21   RE: oldest WAL files not removed 
• 11:08   Re: oldest WAL files not removed Kyotaro Horiguchi
• 12:10   Re: No xmin in pg_database Alexander Kass
• 13:41   Re: No xmin in pg_database Tom Lane
• 14:09   Querying a table with jaccard similarity with 1.6 million records take 12 seconds balasubramanian c r
• 15:14   Re: No xmin in pg_database Laurenz Albe
• 15:27   Re: datfrozenxid not dropping after vacuum Matthew Tice
• 16:06   jsonpath duplication result Charles Paperman
• 16:13   Re: datfrozenxid not dropping after vacuum Alvaro Herrera
• 16:24   Re: oldest WAL files not removed Ninad Shah
• 16:28   Re: Issue with a query while running on a remote host Ninad Shah
• 16:55   Re: jsonpath duplication result David G. Johnston
• 17:35   memory consumption of memory for postgres db container M Tarkeshwar Rao
• 17:47   Re: Querying a table with jaccard similarity with 1.6 million records take 12 seconds Ninad Shah
• 17:49   Re: calling store procedure / insert statement never complete Ninad Shah
• 17:59   Re: memory consumption of memory for postgres db container Ninad Shah
• 18:11   RE: memory consumption of memory for postgres db container M Tarkeshwar Rao
• 18:27   Re: Querying a table with jaccard similarity with 1.6 million records take 12 seconds Michael Lewis
• 20:38   Upgrade 9.5 cluster on Ubuntu 16.04 Vano Beridze
• 21:00   Re: jsonpath duplication result Charles Paperman
• 21:09   Re: Querying a table with jaccard similarity with 1.6 million records take 12 seconds balasubramanian c r
• 21:13   Re: Upgrade 9.5 cluster on Ubuntu 16.04 Adrian Klaver
• 21:17   Re: Upgrade 9.5 cluster on Ubuntu 16.04 Nikolay Samokhvalov
• 21:34   Re: Upgrade 9.5 cluster on Ubuntu 16.04 Vano Beridze
• 21:41   Re: Upgrade 9.5 cluster on Ubuntu 16.04 Adrian Klaver
• 21:55   Re: Upgrade 9.5 cluster on Ubuntu 16.04 Vano Beridze
• 22:16   Re: Upgrade 9.5 cluster on Ubuntu 16.04 David G. Johnston
• 22:38   Re: memory consumption of memory for postgres db container Ninad Shah
• 22:42   Re: Querying a table with jaccard similarity with 1.6 million records take 12 seconds Ninad Shah
• 22:43   Re: Querying a table with jaccard similarity with 1.6 million records take 12 seconds Ninad Shah
• 22:44   Re: Querying a table with jaccard similarity with 1.6 million records take 12 seconds Tom Lane
• 22:51   Re: Upgrade 9.5 cluster on Ubuntu 16.04 Adrian Klaver

3 September 2021

• 00:21   Re: Upgrade 9.5 cluster on Ubuntu 16.04 Nikolay Samokhvalov
• 01:12   Re: Querying a table with jaccard similarity with 1.6 million records take 12 seconds balasubramanian c r
• 01:15   Query takes around 15 to 20 min over 20Lakh rows Shubham Mittal
• 01:27   Re: Query takes around 15 to 20 min over 20Lakh rows Michael Lewis
• 02:08   Re: Query takes around 15 to 20 min over 20Lakh rows David G. Johnston
• 02:22   Re: Query takes around 15 to 20 min over 20Lakh rows Tom Lane
• 02:25   gen_random_uuid key collision jesusthefrog
• 02:35   Re: gen_random_uuid key collision Adrian Klaver
• 02:38   Re: gen_random_uuid key collision jesusthefrog
• 02:47   Re: gen_random_uuid key collision Tom Lane
• 03:05   Re: gen_random_uuid key collision Adrian Klaver
• 03:36   Re: gen_random_uuid key collision jesusthefrog
• 03:38   Re: gen_random_uuid key collision jesusthefrog
• 03:50   Re: gen_random_uuid key collision Adrian Klaver
• 04:13   Re: gen_random_uuid key collision Peter Geoghegan
• 04:41   Re: gen_random_uuid key collision Mark Dilger
• 09:50   is there any memory leak with postgres version(12.x) - https://stackoverflow.com/questions/3849543/force-postgresql-to-release-allocated-memory M Tarkeshwar Rao
• 09:52   Re: memory consumption of memory for postgres db container Stephan Knauss
• 10:11   Re: is there any memory leak with postgres version(12.x) - https://stackoverflow.com/questions/3849543/force-postgresql-to-release-allocated-memory David G. Johnston
• 18:27   update non-indexed value is slow if some non-related index/fk are enabled Philippe Doussot

4 September 2021

• 00:35   Re: gen_random_uuid key collision jesusthefrog

5 September 2021

• 16:35   How to observe plan_cache_mode transition from custom to generic plan? Richard Michael
• 18:08   Re: update non-indexed value is slow if some non-related index/fk are enabled David G. Johnston
• 18:21   Re: update non-indexed value is slow if some non-related index/fk are enabled Tom Lane
• 20:06   Re: Query takes around 15 to 20 min over 20Lakh rows Shubham Mittal
• 20:50   Re: Query takes around 15 to 20 min over 20Lakh rows Mladen Gogala
• 21:20   Re: How to observe plan_cache_mode transition from custom to generic plan? Mladen Gogala
• 21:32   Re: How to observe plan_cache_mode transition from custom to generic plan? David G. Johnston
• 21:51   Re: Query takes around 15 to 20 min over 20Lakh rows Shubham Mittal

6 September 2021

• 09:05   RE: vacuum full Ian Dauncey
• 10:07   Re: How to observe plan_cache_mode transition from custom to generic plan? Mladen Gogala
• 10:51   pg_upgrade - fe_sendauth: no password supplied Nick Renders
• 11:21   Re: update non-indexed value is slow if some non-related index/fk are enabled rob stone
• 12:29   Re: update non-indexed value is slow if some non-related index/fk are enabled Philippe Doussot
• 12:32   Re: update non-indexed value is slow if some non-related index/fk are enabled Philippe Doussot
• 15:50   PostgreSQL : column value filtering in Logical Replication PALAYRET Jacques
• 16:38   Re: pg_upgrade - fe_sendauth: no password supplied Tom Lane
• 17:13   Re: update non-indexed value is slow if some non-related index/fk are enabled David G. Johnston
• 17:18   Behavior change in PostgreSQL 14Beta3 or bug? Daniel Westermann (DWE)
• 17:46   Re: Behavior change in PostgreSQL 14Beta3 or bug? Peter Geoghegan
• 17:52   Re: Behavior change in PostgreSQL 14Beta3 or bug? Daniel Westermann (DWE)
• 18:48   Re: Behavior change in PostgreSQL 14Beta3 or bug? Laurenz Albe
• 18:59   Re: Behavior change in PostgreSQL 14Beta3 or bug? Tom Lane
• 19:21   Re: Behavior change in PostgreSQL 14Beta3 or bug? Laurenz Albe
• 21:04   Re: Query takes around 15 to 20 min over 20Lakh rows Shubham Mittal
• 21:14   Re: Query takes around 15 to 20 min over 20Lakh rows Matthias Apitz
• 21:15   Re: Query takes around 15 to 20 min over 20Lakh rows Shubham Mittal
• 21:26   Re: Query takes around 15 to 20 min over 20Lakh rows Josef Šimánek
• 21:26   Re: Query takes around 15 to 20 min over 20Lakh rows Matthias Apitz
• 22:11   Re: Behavior change in PostgreSQL 14Beta3 or bug? Peter Geoghegan
• 22:39   Re: Behavior change in PostgreSQL 14Beta3 or bug? Peter Geoghegan

7 September 2021

• 01:09   Re: Behavior change in PostgreSQL 14Beta3 or bug? Peter Geoghegan
• 06:44   Choosing an index on partitioned tables. Tim Uckun
• 07:06   Re: Choosing an index on partitioned tables. Brent Wood
• 07:26   Re: Choosing an index on partitioned tables. Tim Uckun
• 10:14   Re: Behavior change in PostgreSQL 14Beta3 or bug? Laurenz Albe
• 10:21   Re: Choosing an index on partitioned tables. Laurenz Albe
• 10:24   Re: Choosing an index on partitioned tables. Laurenz Albe
• 10:43   How to log bind values for statements that produce errors Raul Kaubi
• 11:46   Re: Choosing an index on partitioned tables. Tim Uckun
• 11:51   Re: Choosing an index on partitioned tables. Tim Uckun
• 12:16   Re: Choosing an index on partitioned tables. Magnus Hagander
• 12:52   Re: Choosing an index on partitioned tables. Tim Uckun
• 12:59   Re: Choosing an index on partitioned tables. Magnus Hagander
• 13:15   Re: Choosing an index on partitioned tables. Tim Uckun
• 13:28   Re: Choosing an index on partitioned tables. Magnus Hagander
• 14:59   Re: update non-indexed value is slow if some non-related index/fk are enabled Philippe Doussot
• 16:48   Re: How to log bind values for statements that produce errors Tom Lane
• 17:52   Re: How to log bind values for statements that produce errors Raul Kaubi
• 18:27   Re: Query takes around 15 to 20 min over 20Lakh rows Michael Lewis

8 September 2021

• 07:07   Re: prevent WAL replication to fill filesystem Ninad Shah
• 07:59   Is there any technical reason why "alter table .. set not null" can't use index? hubert depesz lubaczewski
• 08:09   Re: Is there any technical reason why "alter table .. set not null" can't use index? Alexander Kukushkin
• 08:14   Re: Is there any technical reason why "alter table .. set not null" can't use index? hubert depesz lubaczewski
• 09:39   Re: prevent WAL replication to fill filesystem Jehan-Guillaume de Rorthais
• 16:20   Re: No xmin in pg_database Alexander Kass
• 16:45   Re: No xmin in pg_database Tom Lane
• 17:55   Logical Replication to Older Version Miles Elam
• 18:49   Re: Logical Replication to Older Version Miles Elam

9 September 2021

• 00:04   How does postgres behave if several indexes have (nearly) identical conditions? Koen De Groote
• 00:15   Re: How does postgres behave if several indexes have (nearly) identical conditions? Koen De Groote
• 00:17   Re: How does postgres behave if several indexes have (nearly) identical conditions? David G. Johnston
• 00:18   spiexceptions.UndefinedFile: could not open file "base/16482/681830": No such file or directory Celia McInnis
• 00:18   Re: How does postgres behave if several indexes have (nearly) identical conditions? David G. Johnston
• 00:41   Re: How does postgres behave if several indexes have (nearly) identical conditions? Koen De Groote
• 00:53   Re: How does postgres behave if several indexes have (nearly) identical conditions? David G. Johnston
• 03:56   Re: spiexceptions.UndefinedFile: could not open file "base/16482/681830": No such file or directory Thomas Munro
• 06:55   Re: spiexceptions.UndefinedFile: could not open file "base/16482/681830": No such file or directory Celia McInnis
• 08:52   Postgresql 11: terminating walsender process due to replication timeout Abhishek Bhola
• 08:53   Subscriber to Get Only Some of The Tables From Publisher Avi Weinberg
• 09:56   Re: Postgresql 11: terminating walsender process due to replication timeout Kyotaro Horiguchi
• 10:06   Re: Postgresql 11: terminating walsender process due to replication timeout Abhishek Bhola
• 10:52   ALTER DATABASE SET not working as expected? Tim Uckun
• 12:06   Re: ALTER DATABASE SET not working as expected? Ian Lawrence Barwick
• 12:16   Re: Subscriber to Get Only Some of The Tables From Publisher Simon Riggs
• 12:58   Re: ALTER DATABASE SET not working as expected? Tim Uckun
• 17:51   Re: How to observe plan_cache_mode transition from custom to generic plan? Richard Michael
• 17:58   Re: How to observe plan_cache_mode transition from custom to generic plan? Richard Michael
• 19:02   Re: How to observe plan_cache_mode transition from custom to generic plan? Tom Lane
• 19:09   Re: How to observe plan_cache_mode transition from custom to generic plan? Richard Michael
• 20:39   Re: How to observe plan_cache_mode transition from custom to generic plan? Tom Lane

10 September 2021

• 00:45   Re: update non-indexed value is slow if some non-related index/fk are enabled Peter J. Holzer
• 03:21   Re: Postgresql 11: terminating walsender process due to replication timeout Kyotaro Horiguchi
• 10:55   Re: Postgresql 11: terminating walsender process due to replication timeout Abhishek Bhola
• 15:35   Re: How to observe plan_cache_mode transition from custom to generic plan? Richard Michael
• 15:38   Re: How to observe plan_cache_mode transition from custom to generic plan? Richard Michael
• 20:26   Re: Is there any technical reason why "alter table .. set not null" can't use index? Gus Spier
• 20:55   Re: Is there any technical reason why "alter table .. set not null" can't use index? hubert depesz lubaczewski

11 September 2021

• 03:08   PostgreSQL starting with a corrupted database or other fatal issues Keith Christian
• 03:50   Unable to drop invalid TOAST indexes gabrielle
• 04:41   Re: PostgreSQL starting with a corrupted database or other fatal issues David G. Johnston

12 September 2021

• 21:21   Re: Unable to drop invalid TOAST indexes Laurenz Albe

13 September 2021

• 04:10   Re: Postgresql 11: terminating walsender process due to replication timeout Kyotaro Horiguchi
• 14:23   ERROR: control reached end of function without RETURN, except, it is not a function it is a procedure or a nameless block. Herwig Goemans
• 14:44   Re: ERROR: control reached end of function without RETURN, except, it is not a function it is a procedure or a nameless block. Pavel Stehule
• 19:04   Re: ERROR: control reached end of function without RETURN, except, it is not a function it is a procedure or a nameless block. Tom Lane
• 20:56   Fastest option to transfer db? Israel Brewster
• 20:59   Re: Query takes around 15 to 20 min over 20Lakh rows Shubham Mittal
• 21:10   Re: Fastest option to transfer db? Michael Lewis
• 21:49   Re: Fastest option to transfer db? Israel Brewster

14 September 2021

• 00:10   Re: Fastest option to transfer db? Israel Brewster
• 00:37   what is pg_stat_activity.query for idle connections ? David Gauthier
• 00:41   Re: what is pg_stat_activity.query for idle connections ? Tom Lane
• 01:10   To JIT (or not!) in Ubuntu packages Ben Chobot
• 08:31   The tragedy of SQL Guyren Howe
• 08:51   Re: The tragedy of SQL Guyren Howe
• 09:18   Re: The tragedy of SQL Rob Sargent
• 09:39   Re: The tragedy of SQL Raymond Brinzer
• 12:42   Re: Fastest option to transfer db? Tomas Pospisek
• 15:13   Re: The tragedy of SQL Wim Bertels
• 15:49   Re: The tragedy of SQL Rich Shepard
• 15:59   Re: The tragedy of SQL Bèrto ëd Sèra
• 16:06   Re: The tragedy of SQL Merlin Moncure
• 16:51   Re: The tragedy of SQL David Goodenough
• 17:01   Re: The tragedy of SQL Rob Sargent
• 18:24   Re: The tragedy of SQL Merlin Moncure
• 19:10   Re: The tragedy of SQL Michael Nolan
• 19:20   Re: The tragedy of SQL Rob Sargent
• 19:30   Re: The tragedy of SQL Scottix
• 19:56   Re: The tragedy of SQL Bret Stern
• 20:03   Re: Fastest option to transfer db? Israel Brewster
• 20:53   Re: The tragedy of SQL Raymond Brinzer
• 21:41   Re: The tragedy of SQL Brian Dunavant
• 22:48   Re: The tragedy of SQL Raymond Brinzer
• 22:51   Re: The tragedy of SQL Mladen Gogala
• 22:53   Re: The tragedy of SQL Mladen Gogala
• 22:57   Re: The tragedy of SQL Guyren Howe
• 22:59   Re: The tragedy of SQL Rob Sargent
• 23:00   Re: The tragedy of SQL Martin Ritchie
• 23:07   Re: The tragedy of SQL Raymond Brinzer
• 23:08   Re: The tragedy of SQL Guyren Howe
• 23:13   Roles Gambhir Singh
• 23:15   Re: The tragedy of SQL FWS Neil
• 23:33   Re: The tragedy of SQL Raymond Brinzer
• 23:51   Re: The tragedy of SQL Mladen Gogala

15 September 2021

• 00:01   Re: The tragedy of SQL Mladen Gogala
• 01:29   Re: The tragedy of SQL Peter J. Holzer
• 01:30   Re: The tragedy of SQL Peter J. Holzer
• 01:53   Re: The tragedy of SQL Gavin Flower
• 02:05   Re: The tragedy of SQL Gavin Flower
• 02:11   Re: Roles Adrian Klaver
• 02:25   Re: The tragedy of SQL Michael Nolan
• 03:31   Re: The tragedy of SQL Raymond Brinzer
• 03:32   Re: The tragedy of SQL Adrian Klaver
• 03:50   Re: To JIT (or not!) in Ubuntu packages Thomas Munro
• 04:49   Re: The tragedy of SQL Gavin Flower
• 06:25   Re: Roles Gambhir Singh
• 06:30   Re: To JIT (or not!) in Ubuntu packages Ben Chobot
• 07:05   Re: To JIT (or not!) in Ubuntu packages Thomas Munro
• 07:54   SQL queries as sets: was The tragedy of SQL Steve Litt
• 08:10   Basic Questions about PostgreSQL. A Z
• 08:31   Re: SQL queries as sets: was The tragedy of SQL Guyren Howe
• 08:32   Re: Basic Questions about PostgreSQL. David G. Johnston
• 09:04   Re: SQL queries as sets: was The tragedy of SQL Brent Wood
• 09:45   Re: The tragedy of SQL Julien Rouhaud
• 11:38   Re: Basic Questions about PostgreSQL. rob stone
• 14:56   Re: Basic Questions about PostgreSQL. Tom Lane
• 15:36   Re: Roles Simon Riggs
• 16:01   Re: SQL queries as sets: was The tragedy of SQL Rich Shepard
• 16:19   Re: Basic Questions about PostgreSQL. Simon Riggs
• 16:53   How to restore roles into new Database server? Sridhar Parepalli
• 17:10   Re: How to restore roles into new Database server? Ninad Shah
• 17:12   Re: How to restore roles into new Database server? Adrian Klaver
• 17:25   Re: Basic Questions about PostgreSQL. Adrian Klaver
• 17:55   Re: How to restore roles into new Database server? Thomas Kellerer
• 18:29   Re: SQL queries as sets: was The tragedy of SQL Raymond Brinzer
• 19:52   Alter and move corresponding: was The tragedy of SQL Steve Litt
• 20:18   RE: How to restore roles into new Database server? Sridhar Parepalli
• 20:18   RE: How to restore roles into new Database server? Sridhar Parepalli
• 20:19   RE: How to restore roles into new Database server? Sridhar Parepalli
• 20:47   Re: Alter and move corresponding: was The tragedy of SQL Michael Nolan
• 21:04   Re: Roles Gambhir Singh
• 21:07   Re: Alter and move corresponding: was The tragedy of SQL Ron
• 22:44   Re: The tragedy of SQL Merlin Moncure

16 September 2021

• 02:31   Re: Alter and move corresponding: was The tragedy of SQL Gavin Flower
• 03:30   Re: The tragedy of SQL FWS Neil
• 03:47   Re: The tragedy of SQL Michael Nolan
• 03:55   Re: The tragedy of SQL Adrian Klaver
• 06:43   Re: Alter and move corresponding: was The tragedy of SQL Gavan Schneider
• 10:36   autocommit for multi call store procedure Trang Le
• 10:38   Re: autocommit for multi call store procedure Ninad Shah
• 16:24   Re: The tragedy of SQL Edson Carlos Ericksson Richter
• 17:21   Re: autocommit for multi call store procedure Adrian Klaver
• 17:31   Re: The tragedy of SQL Merlin Moncure
• 19:26   Re: The tragedy of SQL Michael Nolan
• 19:30   Re: Alter and move corresponding: was The tragedy of SQL Michael Nolan
• 23:21   Re: The tragedy of SQL Gavin Flower

17 September 2021

• 02:01   Re: Alter and move corresponding: was The tragedy of SQL Gavin Flower
• 02:22   Re: Alter and move corresponding: was The tragedy of SQL Rob Sargent
• 02:29   Re: The tragedy of SQL Guyren Howe
• 02:31   Re: The tragedy of SQL Rob Sargent
• 02:53   Re: The tragedy of SQL Mladen Gogala
• 04:32   Fwd: autocommit for multi call store procedure Trang Le
• 05:16   Re: autocommit for multi call store procedure David G. Johnston
• 05:21   Re: Alter and move corresponding: was The tragedy of SQL Gavin Flower
• 05:28   Re: The tragedy of SQL Gavin Flower
• 06:36   Re: The tragedy of SQL Ron
• 06:39   Re: The tragedy of SQL Ron
• 06:54   pg_upgrade problem as locale difference in data centers Yi Sun
• 06:55   Re: The tragedy of SQL Arnold Morein
• 07:56   Proposed French Translation of Code of Conduct Policy Stacey Haysler
• 09:32   SELECT FOR UPDATE returns zero rows with CTE Roman Guryanov
• 12:36   Re: SELECT FOR UPDATE returns zero rows with CTE Alban Hertroys
• 13:44   Re: The tragedy of SQL Raymond Brinzer
• 14:49   Re: The tragedy of SQL Raymond Brinzer
• 15:22   Re: The tragedy of SQL Raymond Brinzer
• 15:58   Re: The tragedy of SQL Tom Browder
• 16:55   jsonb Indexing ramikvl@gmail.com
• 16:55   Re: SELECT FOR UPDATE returns zero rows with CTE Tom Lane
• 17:00   Re: jsonb Indexing Julien Rouhaud
• 17:05   Re: pg_upgrade problem as locale difference in data centers Tom Lane
• 18:29   Re: Fwd: autocommit for multi call store procedure Adrian Klaver
• 22:44   Re: The tragedy of SQL Gavin Flower
• 23:12   Re: The tragedy of SQL Benedict Holland

18 September 2021

• 17:03   Re: The tragedy of SQL Miles Elam
• 18:35   Remove duplicated row in pg_largeobject_metadata Tobias Meyer
• 20:01   Re: Remove duplicated row in pg_largeobject_metadata Tom Lane
• 20:58   Re: Remove duplicated row in pg_largeobject_metadata Tobias Meyer
• 21:28   Re: Remove duplicated row in pg_largeobject_metadata Tom Lane
• 22:00   Re: Remove duplicated row in pg_largeobject_metadata Tobias Meyer

19 September 2021

• 13:28   Possibilities for optimizing inserts across oracle_fdw foreign data wrapper Niels Jespersen

20 September 2021

• 04:52   Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper Mladen Gogala
• 09:46   Re: pg_upgrade problem as locale difference in data centers Yi Sun
• 13:52   Re: jsonb Indexing ramikvl@gmail.com
• 14:17   Re: Proposed French Translation of Code of Conduct Policy Anthony Nowocien
• 14:24   Re: jsonb Indexing Ilya Anfimov
• 14:46   Re: jsonb Indexing ramikvl@gmail.com
• 15:58   Azure Postgresql High connection establishment time Abhay Gupta
• 16:18   Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper Laurenz Albe
• 16:41   Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper Magnus Hagander
• 20:13   Re: Azure Postgresql High connection establishment time Michael Lewis
• 20:16   Re: Azure Postgresql High connection establishment time Tom Lane
• 20:37   Re: Azure Postgresql High connection establishment time Abhay Gupta
• 23:34   Re: Azure Postgresql High connection establishment time Adrian Klaver
• 23:47   Re: Azure Postgresql High connection establishment time Peter J. Holzer

21 September 2021

• 09:00   Timestamp with vs without time zone. Tim Uckun
• 10:22   SV: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper Niels Jespersen
• 10:25   Re: Timestamp with vs without time zone. Laurenz Albe
• 10:29   Synchronous logical replication asaba.takanori@fujitsu.com
• 10:35   Re: Timestamp with vs without time zone. Tim Uckun
• 10:35   Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper Laurenz Albe
• 10:39   Re: Timestamp with vs without time zone. Laurenz Albe
• 10:39   Aw: Re: Timestamp with vs without time zone. Karsten Hilbert
• 10:44   Aw: Re: Timestamp with vs without time zone. Karsten Hilbert
• 11:02   Re: Re: Timestamp with vs without time zone. Tim Uckun
• 11:09   Aw: Re: Re: Timestamp with vs without time zone. Karsten Hilbert
• 11:44   Re: Re: Timestamp with vs without time zone. Peter J. Holzer
• 11:45   Re: Re: Re: Timestamp with vs without time zone. Tim Uckun
• 11:50   Re: Re: Timestamp with vs without time zone. Tim Uckun
• 11:54   Aw: Re: Re: Timestamp with vs without time zone. Karsten Hilbert
• 13:28   Question about behavior of conditional indexes Koen De Groote
• 14:14   Re: Question about behavior of conditional indexes Gavin Flower
• 17:35   Re: Question about behavior of conditional indexes Ninad Shah
• 17:48   Re: Timestamp with vs without time zone. Adrian Klaver
• 18:41   Re: Timestamp with vs without time zone. Tom Lane
• 19:14   Re: Question about behavior of conditional indexes Michael Lewis
• 20:20   Re: Re: Timestamp with vs without time zone. Peter J. Holzer
• 20:34   Re: Re: Timestamp with vs without time zone. Dave Cramer
• 20:39   Re: Re: Timestamp with vs without time zone. Peter J. Holzer
• 20:43   Re: Re: Timestamp with vs without time zone. Dave Cramer
• 21:17   Re: Timestamp with vs without time zone. FWS Neil
• 21:45   Re: Re: Timestamp with vs without time zone. Peter J. Holzer
• 21:59   Re: Timestamp with vs without time zone. Peter J. Holzer
• 22:37   Re: Timestamp with vs without time zone. Adrian Klaver
• 22:50   Re: Timestamp with vs without time zone. Peter J. Holzer
• 22:56   Re: Timestamp with vs without time zone. Adrian Klaver
• 22:58   Re: Timestamp with vs without time zone. David G. Johnston
• 23:08   Re: Timestamp with vs without time zone. Peter J. Holzer
• 23:39   Re: Timestamp with vs without time zone. cen

22 September 2021

• 00:34   Re: Timestamp with vs without time zone. Michael Lewis
• 00:49   Re: Timestamp with vs without time zone. Tom Lane
• 02:01   Re: Timestamp with vs without time zone. Steve Crawford
• 02:20   Surprising results from tests intended to show the difference in semantics between transaction_timestamp(), statement_timestamp(), and clock_timestamp() Bryn Llewellyn
• 02:23   Surprising results from tests intended to show the difference in semantics between transaction_timestamp(), statement_timestamp(), and clock_timestamp() Bryn Llewellyn
• 03:10   Re: Surprising results from tests intended to show the difference in semantics between transaction_timestamp(), statement_timestamp(), and clock_timestamp() David G. Johnston
• 03:38   Re: Surprising results from tests intended to show the difference in semantics between transaction_timestamp(), statement_timestamp(), and clock_timestamp() Adrian Klaver
• 03:42   Thanks, David! Re: Surprising results from tests intended to show the difference in semantics between transaction_timestamp(), statement_timestamp(), and clock_timestamp() Bryn Llewellyn
• 03:46   Re: Surprising results from tests intended to show the difference in semantics between transaction_timestamp(), statement_timestamp(), and clock_timestamp() Bryn Llewellyn
• 04:25   Re: Timestamp with vs without time zone. Tim Cross
• 09:43   Re: Timestamp with vs without time zone. cen
• 11:11   Re: Timestamp with vs without time zone. Tim Uckun
• 12:11   Re: Timestamp with vs without time zone. Tim Cross
• 12:52   Re: Timestamp with vs without time zone. Gavin Flower
• 13:54   Re: Question about behavior of conditional indexes Koen De Groote
• 17:11   Re: Question about behavior of conditional indexes Michael Lewis
• 18:41   Re: Timestamp with vs without time zone. Karsten Hilbert
• 18:56   Re: Timestamp with vs without time zone. Michael Lewis
• 19:04   Re: Timestamp with vs without time zone. Rob Sargent
• 22:10   Re: Remove duplicated row in pg_largeobject_metadata Tobias Meyer
• 22:16   Re: Remove duplicated row in pg_largeobject_metadata Tom Lane
• 23:05   Faster distinct query? Israel Brewster
• 23:20   Re: Faster distinct query? David G. Johnston
• 23:20   Re: Faster distinct query? Michael Lewis
• 23:26   Re: Faster distinct query? David G. Johnston
• 23:41   Re: Faster distinct query? Israel Brewster
• 23:48   Re: Faster distinct query? Tom Lane
• 23:49   Re: Faster distinct query? Ryan Booz

23 September 2021

• 00:21   Re: Faster distinct query? Israel Brewster
• 00:35   Re: Faster distinct query? Israel Brewster
• 00:50   Re: Faster distinct query? Ryan Booz
• 00:53   Re: Faster distinct query? Israel Brewster
• 01:05   Re: Faster distinct query? Ryan Booz
• 01:22   Re: Faster distinct query? Israel Brewster
• 01:51   Re: Faster distinct query? Michael Lewis
• 02:48   Re: Faster distinct query? Tom Lane
• 03:58   Re: Faster distinct query? David Rowley
• 04:10   Re: Faster distinct query? David Rowley
• 04:21   Re: Faster distinct query? Israel Brewster
• 04:28   Re: Faster distinct query? David G. Johnston
• 04:31   Re: Faster distinct query? David Rowley
• 04:41   Re: Faster distinct query? David Rowley
• 04:49   Re: Faster distinct query? Ryan Booz
• 06:02   Re: Faster distinct query? Mladen Gogala
• 10:04   Re: Faster distinct query? hubert depesz lubaczewski
• 13:49   Re: Remove duplicated row in pg_largeobject_metadata Tobias Meyer
• 15:34   Re: Faster distinct query? Ryan Booz
• 16:37   RE: Get COUNT results from two different columns Clive Swan
• 16:47   Re: Get COUNT results from two different columns Ray O'Donnell
• 16:50   RE: Get COUNT results from two different columns SQL Padawan
• 17:20   Re: Get COUNT results from two different columns Marc Olivé
• 18:16   RE: Get COUNT results from two different columns Clive Swan
• 18:32   Currently running queries with actual arguments? rihad
• 18:58   Re: Currently running queries with actual arguments? Garfield Lewis
• 19:02   Re: Faster distinct query? Israel Brewster
• 19:16   Re: Faster distinct query? Israel Brewster
• 19:33   Re: Faster distinct query? Rob Sargent
• 19:44   Re: Get COUNT results from two different columns David G. Johnston
• 19:45   Re: Faster distinct query? Israel Brewster
• 19:51   Re: Currently running queries with actual arguments? rihad
• 20:08   Re: Faster distinct query? Rob Sargent
• 21:36   Re: Faster distinct query? Geoff Winkless
• 22:57   Postgres incremental backups per db (not per cluster) Jaime Solorzano
• 23:17   Re: Faster distinct query? Israel Brewster
• 23:37   Re: Postgres incremental backups per db (not per cluster) Ron

24 September 2021

• 00:56   Re: Postgres incremental backups per db (not per cluster) Adrian Klaver
• 01:10   Postgres incremental backups per db (not per cluster) Jaime Solorzano
• 01:10   Re: Postgres incremental backups per db (not per cluster) Jaime Solorzano
• 07:55   Re: Faster distinct query? Michael Lewis
• 13:48   RE: Get COUNT results from two different columns Clive Swan
• 21:03   Re: Faster distinct query? Israel Brewster

25 September 2021

• 00:43   Using XMLNAMESPACES with XMLEMENT Garfield Lewis
• 01:52   Re: Using XMLNAMESPACES with XMLEMENT Rob Sargent
• 01:54   Re: Using XMLNAMESPACES with XMLEMENT Garfield Lewis
• 02:37   Re: Using XMLNAMESPACES with XMLEMENT Rob Sargent
• 02:43   Re: Frequetly updated partial index leads to bloat on index for Postresql 11 Peter Geoghegan
• 06:32   Re: Using XMLNAMESPACES with XMLEMENT Pavel Stehule

26 September 2021

• 22:48   Re: Using XMLNAMESPACES with XMLEMENT Garfield Lewis

27 September 2021

• 02:06   PostgreSQL 9.2 high replication lag - Part 2 Lucas Possamai
• 06:10   Re: pg_upgrade problem as locale difference in data centers Yi Sun
• 09:46   Re: Using XMLNAMESPACES with XMLEMENT Pavel Stehule
• 16:01   change ownership of schema public? Zwettler Markus (OIZ)
• 20:42   statement_timeout vs DECLARE CURSOR Christophe Pettus
• 21:10   Re: statement_timeout vs DECLARE CURSOR Christophe Pettus
• 22:40   Re: statement_timeout vs DECLARE CURSOR Tom Lane

28 September 2021

• 16:24   Nested Schemata, in a Standard-Compliant Way? Raymond Brinzer
• 16:36   Re: Nested Schemata, in a Standard-Compliant Way? Tom Lane
• 17:14   Re: Nested Schemata, in a Standard-Compliant Way? Raymond Brinzer
• 17:18   Re: Nested Schemata, in a Standard-Compliant Way? Raymond Brinzer
• 21:38   Problem with identity column & related sequences Jeff Hoffmann
• 22:13   Re: Problem with identity column & related sequences Tom Lane
• 22:35   Re: Problem with identity column & related sequences Jeff Hoffmann
• 22:57   Re: statement_timeout vs DECLARE CURSOR Tom Lane

29 September 2021

• 12:01   postgresql11: How to use publication/subscription on primary/standby setup Abhishek B
• 12:26   Using a single sequence for all tables Peter J. Holzer
• 12:42   Re: Using a single sequence for all tables Tobias Meyer
• 12:55   Re: Using a single sequence for all tables Peter J. Holzer
• 13:18   Re: Using a single sequence for all tables Laurenz Albe
• 19:21   Re: Using a single sequence for all tables Michael Lewis
• 20:00   ERROR: unrecognized node type Amine Tengilimoglu
• 20:16   Re: ERROR: unrecognized node type Tom Lane
• 20:54   Re: ERROR: unrecognized node type Amine Tengilimoglu
• 21:10   Re: ERROR: unrecognized node type Adrian Klaver
• 21:17   Re: ERROR: unrecognized node type Tom Lane
• 21:37   Re: ERROR: unrecognized node type Tom Lane

30 September 2021

• 00:10   Re: ERROR: unrecognized node type Tomas Vondra
• 02:23   Capturing only queries with --echo-hidden option? Ken Tanzer
• 09:38   Re: ERROR: unrecognized node type Amine Tengilimoglu
• 11:14   Re: Make bloom extension trusted, but can not drop with normal user Masahiko Sawada
• 12:06   Re: ERROR: unrecognized node type Tomas Vondra
• 12:55   Re: Using a single sequence for all tables Peter J. Holzer