Mailing lists [pgsql-general]

1 June 2021

• 13:24   Re: Query on postgres_fdw extension Bharath Rupireddy
• 14:45   RE: Framework for 0 downtime deploys Zahir Lalani
• 18:09   Re: Query on postgres_fdw extension Swathi P
• 21:00   CREATE/REFRESH MATERIALIZED VIEW planner difference? Philip Semanchuk
• 21:20   Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Vijaykumar Jain
• 21:26   Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Philip Semanchuk
• 21:51   Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Tom Lane
• 22:15   Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Vijaykumar Jain
• 22:23   Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Thomas Munro
• 22:31   Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Vijaykumar Jain
• 23:09   Internationalisation (i18n) with Postgres as backend Laura Smith
• 23:37   Re: Internationalisation (i18n) with Postgres as backend Rob Sargent

2 June 2021

• 00:10   Re: Internationalisation (i18n) with Postgres as backend Steve Baldwin
• 02:00   Re: Internationalisation (i18n) with Postgres as backend Laura Smith
• 02:08   Re: Internationalisation (i18n) with Postgres as backend Laura Smith
• 02:42   Re: Internationalisation (i18n) with Postgres as backend Rob Sargent
• 09:21   Is consistent (deterministic) ordering possible in our case? gerry gan
• 09:49   Re: Is consistent (deterministic) ordering possible in our case? Vijaykumar Jain
• 10:08   Re: Internationalisation (i18n) with Postgres as backend Laura Smith
• 11:38   Re: Internationalisation (i18n) with Postgres as backend Laurenz Albe
• 11:43   Re: Internationalisation (i18n) with Postgres as backend Laurenz Albe
• 15:39   Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Philip Semanchuk

3 June 2021

• 04:34   Re: Is consistent (deterministic) ordering possible in our case? gerry gan
• 05:51   Re: Is consistent (deterministic) ordering possible in our case? Tom Lane
• 15:53   RE: BUG #17046: Upgrade postgres 11 to 13 version Ram Pratap Maurya
• 16:41   Dropping dependent tables Tiffany Thang
• 17:18   Re: Dropping dependent tables Tom Lane
• 20:56   LZ4 missing in pg14-beta1 Windows build, OLD VS/compiler used Hans Buschmann
• 21:44   Re: max_connections Vijaykumar Jain
• 21:58   syntax question Marc Millas
• 22:01   Re: syntax question Bruce Momjian
• 22:11   Re: syntax question Adrian Klaver
• 22:21   Re: syntax question Tom Lane
• 22:21   Re: max_connections Vijaykumar Jain
• 22:34   Re: syntax question Bruce Momjian
• 22:53   Re: syntax question Marc Millas
• 23:01   Re: syntax question Marc Millas
• 23:22   Re: syntax question David G. Johnston
• 23:51   index unique Marc Millas
• 23:55   Re: syntax question Marc Millas
• 23:57   Re: index unique Paul Ramsey

4 June 2021

• 00:07   Re: syntax question Guyren Howe
• 00:11   Re: index unique Marc Millas
• 00:17   Re: syntax question Adrian Klaver
• 00:31   possible license violations tom.beacon
• 00:37   Re: BUG #17046: Upgrade postgres 11 to 13 version Adrian Klaver
• 00:40   arbitrary "interval" expression OK with "at time zone" but not with "set time zone" — Why? Bryn Llewellyn
• 00:43   Re: syntax question Marc Millas
• 00:44   Re: arbitrary "interval" expression OK with "at time zone" but not with "set time zone" — Why? Adrian Klaver
• 00:59   Re: arbitrary "interval" expression OK with "at time zone" but not with "set time zone" — Why? Tom Lane
• 01:02   Re: possible license violations Bruce Momjian
• 01:08   Re: possible license violations Tom Lane
• 01:10   Re: arbitrary "interval" expression OK with "at time zone" but not with "set time zone" — Why? Bryn Llewellyn
• 01:35   inner subprograms ... Was: syntax question Bryn Llewellyn
• 02:00   Re: possible license violations Bruce Momjian
• 04:10   Re: Dropping dependent tables Tiffany Thang
• 06:13   Noinheritance with superuser saket bansal
• 06:32   Please tell me about character code conversion. 久門　愛
• 06:59   Re: Noinheritance with superuser Tom Lane
• 07:04   Re: Please tell me about character code conversion. Tom Lane
• 13:09   strange behavior of WAL files Atul Kumar
• 13:56   Re: strange behavior of WAL files Jehan-Guillaume de Rorthais
• 13:58   EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. Pól Ua Laoínecháin
• 14:27   Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. Vijaykumar Jain
• 14:46   RE: BUG #17046: Upgrade postgres 11 to 13 version Ram Pratap Maurya
• 15:12   Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. David Rowley
• 15:54   Re: strange behavior of WAL files Atul Kumar
• 15:55   Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. Laurenz Albe
• 16:15   Re: strange behavior of WAL files Vijaykumar Jain
• 16:40   Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. David Rowley
• 16:42   Re: strange behavior of WAL files Vijaykumar Jain
• 16:43   Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. Tom Lane
• 17:11   Re: strange behavior of WAL files Tom Lane
• 17:16   Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. Pól Ua Laoínecháin
• 17:24   Re: BUG #17046: Upgrade postgres 11 to 13 version Adrian Klaver
• 17:32   EXCLUDE USING and tstzrange Laura Smith
• 17:40   autovacuum on pg_catalog tables Zwettler Markus (OIZ)
• 17:44   Re: EXCLUDE USING and tstzrange Adrian Klaver
• 17:58   Re: EXCLUDE USING and tstzrange Laura Smith
• 18:10   Re: strange behavior of WAL files Atul Kumar
• 18:20   Re: EXCLUDE USING and tstzrange Joe Conway
• 18:33   Re: EXCLUDE USING and tstzrange Laura Smith
• 18:37   Re: autovacuum on pg_catalog tables Vijaykumar Jain
• 18:43   AW: [Extern] Re: autovacuum on pg_catalog tables Zwettler Markus (OIZ)
• 18:51   Re: [Extern] Re: autovacuum on pg_catalog tables Michael Lewis
• 19:03   Re: AW: [Extern] Re: autovacuum on pg_catalog tables Tom Lane
• 19:04   Re: AW: [Extern] Re: autovacuum on pg_catalog tables Laurenz Albe
• 19:06   Re: strange behavior of WAL files Atul Kumar
• 19:34   Re: possible license violations Stephen Frost
• 19:47   Struggling with EXCLUDE USING gist Laura Smith
• 20:07   Re: Struggling with EXCLUDE USING gist Adrian Klaver
• 20:11   Re: Struggling with EXCLUDE USING gist Julien Rouhaud
• 20:32   Re: Struggling with EXCLUDE USING gist Laura Smith
• 20:37   Re: Struggling with EXCLUDE USING gist Laura Smith
• 20:45   Re: Struggling with EXCLUDE USING gist Mark Dilger
• 21:02   Re: Struggling with EXCLUDE USING gist Adrian Klaver
• 21:21   Re: Struggling with EXCLUDE USING gist Adrian Klaver
• 21:26   Re: Struggling with EXCLUDE USING gist Joe Conway
• 21:31   Re: Struggling with EXCLUDE USING gist Laura Smith
• 21:55   Re: Struggling with EXCLUDE USING gist Laura Smith
• 21:56   Re: Struggling with EXCLUDE USING gist Mark Dilger
• 21:56   Re: Struggling with EXCLUDE USING gist Adrian Klaver
• 22:11   Re: strange behavior of WAL files Vijaykumar Jain

5 June 2021

• 01:21   symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility rob stan
• 01:38   Re: symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility Bruce Momjian
• 01:39   Re: symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility Ron
• 01:44   Re: symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility Tom Lane
• 05:17   Re: symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility rob stan
• 12:49   Ideas for building a system that parses medical research publications/articles Achilleas Mantzios
• 13:52   Re: Ideas for building a system that parses medical research publications/articles Laura Smith
• 14:14   Re: Ideas for building a system that parses medical research publications/articles Achilleas Mantzios
• 14:41   Aw: Ideas for building a system that parses medical research publications/articles Karsten Hilbert
• 14:44   Re: Ideas for building a system that parses medical research publications/articles Laura Smith
• 16:45   Re: Ideas for building a system that parses medical research publications/articles Vijaykumar Jain
• 18:34   Re: Ideas for building a system that parses medical research publications/articles Adrian Klaver
• 19:56   Re: Ideas for building a system that parses medical research publications/articles Achilleas Mantzios
• 20:03   Re: Ideas for building a system that parses medical research publications/articles Achilleas Mantzios
• 20:03   Re: Ideas for building a system that parses medical research publications/articles Adrian Klaver
• 20:39   Re: Ideas for building a system that parses medical research publications/articles Achilleas Mantzios
• 22:12   Re: Ideas for building a system that parses medical research publications/articles Adrian Klaver
• 22:44   Re: strange behavior of WAL files Tom Lane
• 23:10   Re: Ideas for building a system that parses medical research publications/articles Achilleas Mantzios

6 June 2021

• 19:00   Symbolic link breaks for postgresql.auto.conf RAJAMOHAN
• 19:13   Re: Symbolic link breaks for postgresql.auto.conf Adrian Klaver
• 19:46   Re: Symbolic link breaks for postgresql.auto.conf Tom Lane
• 20:02   Re: Symbolic link breaks for postgresql.auto.conf Vijaykumar Jain
• 20:15   Re: Symbolic link breaks for postgresql.auto.conf Adrian Klaver
• 22:32   Re: Symbolic link breaks for postgresql.auto.conf Adrian Klaver

7 June 2021

• 02:30   Re: strange behavior of WAL files Ravi Krishna
• 09:55   Re: index unique Peter J. Holzer
• 13:07   AW: AW: [Extern] Re: autovacuum on pg_catalog tables Zwettler Markus (OIZ)
• 13:41   base directory size getting increased Atul Kumar
• 14:11   Re: Symbolic link breaks for postgresql.auto.conf RAJAMOHAN
• 14:22   RE: Ideas for building a system that parses medical research publications/articles [EXT] Daniel Perrett
• 15:04   Re: base directory size getting increased Laurenz Albe
• 15:05   bottom / top posting Vijaykumar Jain
• 15:18   Re: base directory size getting increased Atul Kumar
• 16:44   Re: base directory size getting increased Ravi Krishna
• 16:50   Re: base directory size getting increased Laurenz Albe
• 18:02   Database issues when adding GUI Rich Shepard
• 18:07   Re: Database issues when adding GUI Rob Sargent
• 18:09   Re: Database issues when adding GUI Rob Sargent
• 18:21   Re: Database issues when adding GUI Philip Semanchuk
• 18:31   Re: Database issues when adding GUI Rich Shepard
• 18:32   Re: Database issues when adding GUI Rich Shepard
• 18:37   Re: Database issues when adding GUI Rob Sargent
• 18:42   Re: Database issues when adding GUI Adrian Klaver
• 18:49   Re: Database issues when adding GUI Rich Shepard
• 18:52   Re: AW: AW: [Extern] Re: autovacuum on pg_catalog tables Tom Lane
• 18:56   Re: Database issues when adding GUI Rich Shepard
• 18:57   Re: Database issues when adding GUI Tom Lane
• 19:00   Re: Database issues when adding GUI Rich Shepard
• 19:00   Re: Database issues when adding GUI Tom Lane
• 19:03   Re: Database issues when adding GUI Rich Shepard
• 19:08   Re: Database issues when adding GUI Alan Hodgson
• 19:11   Re: Database issues when adding GUI Tom Lane
• 19:12   Re: Database issues when adding GUI Rich Shepard
• 19:17   Re: Database issues when adding GUI Rich Shepard
• 19:17   Re: Database issues when adding GUI Tom Lane
• 19:18   Re: Database issues when adding GUI Rich Shepard
• 19:18   Re: Database issues when adding GUI Edson Carlos Ericksson Richter
• 19:20   Re: bottom / top posting Sam Gendler
• 19:22   Re: Database issues when adding GUI Rich Shepard
• 19:22   Re: base directory size getting increased Atul Kumar
• 19:24   Re: Database issues when adding GUI Tom Lane
• 19:24   Re: Database issues when adding GUI Alan Hodgson
• 19:28   Re: base directory size getting increased Atul Kumar
• 19:31   Re: bottom / top posting Tom Lane
• 19:35   Re: Database issues when adding GUI Rich Shepard
• 19:42   Re: Database issues when adding GUI David G. Johnston
• 20:19   Re: Database issues when adding GUI Adrian Klaver
• 20:20   Re: Database issues when adding GUI Rich Shepard
• 20:20   Re: index unique David G. Johnston
• 20:21   Re: Database issues when adding GUI Rich Shepard
• 20:33   Re: Database issues when adding GUI Adrian Klaver
• 20:43   Re: Database issues when adding GUI Rich Shepard
• 20:53   Re: bottom / top posting Francisco Olarte
• 21:02   Re: bottom / top posting Francisco Olarte
• 21:53   Re: bottom / top posting Dean Gibson (DB Administrator)
• 22:12   Need to omit time during weekends from age calculations David Gauthier
• 22:17   Re: Need to omit time during weekends from age calculations Ron
• 22:34   Re: Need to omit time during weekends from age calculations Joe Conway
• 22:39   Re: Need to omit time during weekends from age calculations Tom Lane
• 22:45   Re: Need to omit time during weekends from age calculations Pavel Stehule

8 June 2021

• 00:01   Re: Need to omit time during weekends from age calculations David Gauthier
• 00:26   Re: Database issues when adding GUI Rich Shepard
• 00:29   Re: Database issues when adding GUI Adrian Klaver
• 00:32   Re: Database issues when adding GUI David G. Johnston
• 00:34   Re: Database issues when adding GUI David G. Johnston
• 00:39   Re: Database issues when adding GUI Adrian Klaver
• 00:40   Re: bottom / top posting Joshua Drake
• 01:02   Re: Database issues when adding GUI Rich Shepard
• 01:04   Re: Database issues when adding GUI Rich Shepard
• 01:06   Re: Database issues when adding GUI Adrian Klaver
• 01:08   Re: index unique Peter J. Holzer
• 01:12   Re: Database issues when adding GUI Rich Shepard
• 01:21   Re: Database issues when adding GUI Adrian Klaver
• 01:45   Re: Database issues when adding GUI Rich Shepard
• 01:50   Re: Database issues when adding GUI Adrian Klaver
• 01:58   Re: Database issues when adding GUI Rich Shepard
• 02:09   Re: Database issues when adding GUI Adrian Klaver
• 02:19   Re: Database issues when adding GUI David G. Johnston
• 02:32   Re: Database issues when adding GUI Adrian Klaver
• 02:48   Re: Database issues when adding GUI Rich Shepard
• 02:49   Re: Database issues when adding GUI Rich Shepard
• 04:05   Re: Database issues when adding GUI Sam Gendler
• 04:11   Re: Need to omit time during weekends from age calculations Sam Gendler
• 04:36   Re: Database issues when adding GUI Rich Shepard
• 04:39   Re: base directory size getting increased Laurenz Albe
• 04:47   Re: Database issues when adding GUI Rich Shepard
• 07:21   Re: Database issues when adding GUI Adrian Klaver
• 09:34   Aw: Re: Database issues when adding GUI Karsten Hilbert
• 13:11   pg 13 fatal error message mentionning "standby_mode" Phil Florent
• 14:15   Re: pg 13 fatal error message mentionning "standby_mode" Guillaume Lelarge
• 14:21   Re: pg 13 fatal error message mentionning "standby_mode" Guillaume Lelarge
• 14:27   RE: pg 13 fatal error message mentionning "standby_mode" Phil Florent
• 18:56   Re: Database issues when adding GUI Rich Shepard
• 18:58   Re: Aw: Re: Database issues when adding GUI Rich Shepard
• 19:30   Re: index unique Marc Millas
• 21:42   Re: index unique Peter J. Holzer
• 22:22   Re: index unique Marc Millas
• 22:35   Re: index unique David G. Johnston
• 23:05   Re: index unique Tom Lane
• 23:50   Re: index unique Thomas Kellerer

9 June 2021

• 00:56   Re: bottom / top posting Bruce Momjian
• 15:48   JDBC error: Unexpected packet type: 25 Ignacio Rey
• 17:32   Re: JDBC error: Unexpected packet type: 25 Vijaykumar Jain
• 18:03   Re: bottom / top posting Jan Wieck
• 22:51   How to pass a parameter in a query to postgreSQL 12 Hassan Camacho Cadre

10 June 2021

• 00:41   Re: bottom / top posting Dean Gibson (DB Administrator)
• 01:04   Re: bottom / top posting Tom Lane
• 01:10   Re: bottom / top posting Tom Browder
• 01:43   Re: bottom / top posting Dave Cramer
• 02:50   Re: bottom / top posting Adrian Klaver
• 04:16   PostgreSQL replication lag - Suggestions and questions Lucas
• 06:07   Re: bottom / top posting Adrian Ho
• 08:23   Re: bottom / top posting Steve Litt
• 10:00   Re: PostgreSQL replication lag - Suggestions and questions Vijaykumar Jain
• 11:03   order by  Luca Ferrari
• 11:15   Re: order by  Vijaykumar Jain
• 11:39   Re: order by  Luca Ferrari
• 11:58   Re: order by  Thomas Munro
• 12:00   Re: order by  Laurenz Albe
• 14:44   Questions about support function and abbreviate. Han Wang
• 16:09   Re: index unique Marc Millas
• 16:30   SELECT in VCHAR column for strings with TAB Matthias Apitz
• 16:32   Re: order by  Tom Lane
• 16:39   Re: SELECT in VCHAR column for strings with TAB Ray O'Donnell
• 16:50   Re: SELECT in VCHAR column for strings with TAB Tom Lane
• 19:06   Re: Logical Replication: SELECT pg_catalog.set_config Statement appears to be hanging Hannes Kühtreiber
• 19:06   Re: Logical Replication: SELECT pg_catalog.set_config Statement Hannes Kühtreiber
• 19:08   Re: bottom / top posting Basques, Bob (CI-StPaul)
• 19:30   Re: Logical Replication: SELECT pg_catalog.set_config Statement appears to be hanging David G. Johnston
• 19:33   Implicit table removal from logical replication publication Avi Weinberg
• 20:00   Re: How to pass a parameter in a query to postgreSQL 12 Peter J. Holzer
• 21:39   Re: Implicit table removal from logical replication publication Vijaykumar Jain
• 21:43   Re: Implicit table removal from logical replication publication Cory Nemelka
• 21:58   Re: Implicit table removal from logical replication publication Vijaykumar Jain
• 23:21   Re: bottom / top posting Peter J. Holzer
• 23:25   Re: bottom / top posting Peter J. Holzer
• 23:32   Re: index unique Alban Hertroys
• 23:35   Re: bottom / top posting Jan Wieck
• 23:52   Even more OT: Ditto machines [was: bottom / top posting] Dean Gibson (DB Administrator)

11 June 2021

• 00:19   Re: Even more OT: Ditto machines [was: bottom / top posting] Tom Browder
• 00:30   Re: Even more OT: Ditto machines [was: bottom / top posting] Rob Sargent
• 00:37   Adding table partition slow when there is default partition with data (primary key not used to check partition condition) Sasa Vilic
• 02:31   Re: bottom / top posting Steve Litt
• 02:49   Re: Even more OT: Ditto machines [was: bottom / top posting] Francisco Olarte
• 03:19   Re: bottom / top posting Francisco Olarte
• 06:30   Postgresql crashdown and recovery failure xiebin (F)
• 06:34   Postgresql crashdown and recovery failure xiebin (F)
• 06:41   Re: Postgresql crashdown and recovery failure Ron
• 06:54   Re: Even more OT: Ditto machines [was: bottom / top posting] Adrian Ho
• 10:51   Re: WAL accumulating, Logical Replication pg 13 Willy-Bas Loos
• 11:52   Re: How to pass a parameter in a query to postgreSQL 12 Jehan-Guillaume de Rorthais
• 15:37   Re: index unique Marc Millas
• 20:03   Re: bottom / top posting Bruce Momjian
• 20:44   Re: Even more OT: Ditto machines [was: bottom / top posting] Bruce Momjian
• 20:47   Re: bottom / top posting Nikolay Samokhvalov

12 June 2021

• 10:03   Re: bottom / top posting Jehan-Guillaume de Rorthais
• 11:00   Is there a way to replace select * fields in result ? Condor
• 11:13   Re: Is there a way to replace select * fields in result ? David G. Johnston
• 11:18   Re: Is there a way to replace select * fields in result ? Condor
• 12:15   Re: Is there a way to replace select * fields in result ? Alban Hertroys
• 14:35   How to generate file from postgres data Shubham Mittal
• 14:53   Re: How to generate file from postgres data Vijaykumar Jain
• 14:57   Re: How to generate file from postgres data Vijaykumar Jain

13 June 2021

• 02:24   Re: index unique Peter J. Holzer
• 11:00   Notify When Streaming Replication Failover Occurred (slave promoted to master). Avi Weinberg
• 18:51   Re: Notify When Streaming Replication Failover Occurred (slave promoted to master). Peter J. Holzer

14 June 2021

• 02:31   Notify When Streaming Replication Failover Occurred (slave promoted to master). Avi Weinberg
• 15:10   Re: Notify When Streaming Replication Failover Occurred (slave promoted to master). Dave Cramer

15 June 2021

• 12:20   immutable function querying table for partitioning Vijaykumar Jain
• 13:42   Losing data because of problematic configuration? Holtgrewe, Manuel
• 13:42   query issue Atul Kumar
• 14:07   Re: Losing data because of problematic configuration? Ron
• 14:09   Memory alloc exception 
• 14:23   Re: Memory alloc exception Ron
• 14:40   Re: [ext] Re: Losing data because of problematic configuration? Holtgrewe, Manuel
• 14:41   Re: query issue Jehan-Guillaume de Rorthais
• 15:51   Re: immutable function querying table for partitioning David G. Johnston
• 16:26   Re: immutable function querying table for partitioning Vijaykumar Jain
• 16:39   Re: Losing data because of problematic configuration? Tom Lane
• 16:43   Re: Memory alloc exception Tom Lane
• 16:46   Re: query issue Atul Kumar
• 17:05   Re: some questions regarding replication issues and timeline/history files email2ssk247@gmail.com
• 17:46   Re: query issue Jehan-Guillaume de Rorthais
• 18:53   Re: [ext] Re: Losing data because of problematic configuration? Holtgrewe, Manuel
• 21:55   CONCAT function adding extra characters AI Rumman
• 22:00   Re: CONCAT function adding extra characters Pavel Stehule
• 22:05   Re: CONCAT function adding extra characters Adrian Klaver
• 22:07   Re: CONCAT function adding extra characters Adrian Klaver
• 22:07   Re: CONCAT function adding extra characters Tom Lane
• 22:12   Re: CONCAT function adding extra characters Kenneth Marshall
• 22:18   Re: CONCAT function adding extra characters Pavel Stehule
• 23:14   Re: CONCAT function adding extra characters Ron
• 23:41   Re: some questions regarding replication issues and timeline/history files Mateusz Henicz
• 23:44   Re: some questions regarding replication issues and timeline/history files Sudhakaran Srinivasan

16 June 2021

• 00:29   Re: CONCAT function adding extra characters AI Rumman
• 03:24   hot_standby_feedback implementation Christophe Pettus
• 03:30   Re: hot_standby_feedback implementation Peter Geoghegan
• 03:41   Re: hot_standby_feedback implementation Christophe Pettus
• 07:53   pg_basebackup fails with "COPY stream ended" Dipanjan Das
• 08:12   Re: pg_basebackup fails with "COPY stream ended" Julien Rouhaud
• 09:05   Re: some questions regarding replication issues and timeline/history files Kyotaro Horiguchi
• 09:28   Re: query issue Atul Kumar
• 09:32   clear cache in postgresql Atul Kumar
• 09:39   Re: clear cache in postgresql Julien Rouhaud
• 09:56   Re: clear cache in postgresql Vijaykumar Jain
• 11:08   Re: Notify When Streaming Replication Failover Occurred (slave promoted to master). Peter J. Holzer
• 11:54   Re: [ext] Re: Losing data because of problematic configuration? Holtgrewe, Manuel
• 12:59   Re: [ext] Re: Losing data because of problematic configuration? Holtgrewe, Manuel
• 13:41   Re: query issue David Rowley
• 14:03   Re: clear cache in postgresql Peter J. Holzer
• 17:01   Establishing a local connection to PostgreSQL 9.6 takes seconds Marcin Barczynski
• 17:10   Re: Establishing a local connection to PostgreSQL 9.6 takes seconds Tom Lane
• 17:47   Re: Establishing a local connection to PostgreSQL 9.6 takes seconds Marcin Barczynski
• 17:55   Re: Establishing a local connection to PostgreSQL 9.6 takes seconds Tom Lane
• 18:02   A simple question about text fields Martin Mueller
• 18:08   Re: A simple question about text fields Tom Lane
• 18:27   Streaming replication: PANIC on tertiary when secondary promoted Alexey Bashtanov
• 19:20   Re: Streaming replication: PANIC on tertiary when secondary promoted Vijaykumar Jain
• 22:31   Re: Streaming replication: PANIC on tertiary when secondary promoted Alexey Bashtanov

17 June 2021

• 12:38   views on partitioned tables Holger Vornholt
• 14:04   Fwd: Listen and notify in psql process Sakshi Jain
• 14:45   Re: Listen and notify in psql process Ravi Krishna
• 16:34   Re: Listen and notify in psql process Torsten Förtsch
• 17:13   Treating float arrays as vectors? Celia McInnis
• 17:39   compute_query_id Vijaykumar Jain
• 17:50   Re: compute_query_id Julien Rouhaud
• 18:27   Re: compute_query_id Vijaykumar Jain
• 18:34   Re: compute_query_id Julien Rouhaud
• 18:48   Re: Streaming replication: PANIC on tertiary when secondary promoted Alexey Bashtanov
• 19:08   Re: Treating float arrays as vectors? Paul Jungwirth

18 June 2021

• 02:19   Re: A simple question about text fields Gavan Schneider
• 02:34   Re: A simple question about text fields David G. Johnston
• 03:28   Re: A simple question about text fields Gavan Schneider
• 08:40   Temporal tables as part of main release Anand Sowmithiran
• 09:10   Re: Temporal tables as part of main release David G. Johnston
• 09:49   Re: A simple question about text fields Laurenz Albe
• 10:15   short sql question goldgraeber-werbetechnik@t-online.de
• 14:31   Re: short sql question Georg H.
• 21:28   Re: Temporal tables as part of main release Paul Jungwirth

19 June 2021

• 15:58   Re: Temporal tables as part of main release Anand Sowmithiran
• 17:40   Re: Temporal tables as part of main release Tom Lane
• 19:24   Re: Temporal tables as part of main release Anand Sowmithiran

20 June 2021

• 05:10   Re: Temporal tables as part of main release Ron
• 14:48   pgTAP installation Ray O'Donnell
• 16:06   Re: pgTAP installation Vijaykumar Jain
• 16:11   Re: pgTAP installation Vijaykumar Jain
• 16:24   Re: pgTAP installation Vijaykumar Jain
• 17:52   Re: pgTAP installation Ray O'Donnell
• 19:47   pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Karsten Hilbert
• 20:19   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Vijaykumar Jain
• 20:44   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Vijaykumar Jain
• 20:47   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Karsten Hilbert
• 20:47   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Tom Lane
• 21:03   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Vijaykumar Jain
• 21:14   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Tom Lane
• 22:34   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Karsten Hilbert
• 22:58   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Karsten Hilbert
• 23:14   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Adrian Klaver
• 23:40   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Karsten Hilbert
• 23:52   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Adrian Klaver

21 June 2021

• 11:24   Is it Possible to Rename Replication Slot + Can Publisher be Paused Avi Weinberg
• 12:58   How to automatically delete idle client connections? Yu Watanabe
• 13:17   Re: How to automatically delete idle client connections? David Rowley
• 13:40   user privileges Atul Kumar
• 15:30   Re: user privileges Charles Clavadetscher
• 15:38   XX001ERROR: found xmin from before relfrozenxid for pg_authid and pg_database Brajendra Pratap Singh
• 16:27   replace inside regexp_replace Oliver Kohll
• 16:53   How to hash a large amount of data within Postgres? Thorsten Schöning
• 17:08   Re: replace inside regexp_replace Francisco Olarte
• 17:27   Re: user privileges Laurenz Albe
• 17:47   Re: replace inside regexp_replace hubert depesz lubaczewski
• 18:36   Re: replace inside regexp_replace David G. Johnston

22 June 2021

• 00:05   Re: How to automatically delete idle client connections? Ron
• 02:11   Highly Available Postgres on Kubernetes Venkat Pathi
• 03:44   Psql wants to use IP6 when connecting to self using tcp... Jerry Levan
• 04:08   Re: How to automatically delete idle client connections? Yu Watanabe
• 04:23   Re: Psql wants to use IP6 when connecting to self using tcp... Tom Lane
• 08:58   Re: Psql wants to use IP6 when connecting to self using tcp... Stephan Knauss
• 10:06   cpu-intensive immutable function and parallel scan Niels Jespersen
• 10:09   Re: cpu-intensive immutable function and parallel scan David Rowley
• 11:02   Postgres PANIC when it could not open file in pg_logical/snapshots directory Mike Yeap
• 11:20   second CTE kills perf Nicolas Seinlet
• 12:04   Re: Postgres PANIC when it could not open file in pg_logical/snapshots directory Vijaykumar Jain
• 12:19   Re: replace inside regexp_replace Oliver Kohll
• 14:17   Re: second CTE kills perf Vijaykumar Jain
• 16:29   Re: cpu-intensive immutable function and parallel scan Tom Lane
• 16:53   Re: second CTE kills perf Tom Lane
• 20:59   www.postgresql-archive.org content deleted Vijaykumar Jain
• 21:01   Re: www.postgresql-archive.org content deleted Magnus Hagander
• 21:03   Re: www.postgresql-archive.org content deleted Tom Lane
• 21:03   Re: www.postgresql-archive.org content deleted Vijaykumar Jain
• 21:06   Re: www.postgresql-archive.org content deleted Vijaykumar Jain
• 23:29   Exclusion constraint with custom operator not working as expected Rhys A.D. Stewart

23 June 2021

• 07:57   SV: cpu-intensive immutable function and parallel scan Niels Jespersen
• 12:26   Re: [postgis-users] Exclusion constraint with custom operator not working as expected Darafei "Komяpa" Praliaskouski
• 20:39   Re: How to hash a large amount of data within Postgres? Peter J. Holzer
• 20:51   Re: Psql wants to use IP6 when connecting to self using tcp... Peter J. Holzer
• 21:53   Is there something similar like flashback query from Oracle planned for PostgreSQL Dirk Krautschick
• 22:01   Re: Postgres PANIC when it could not open file in pg_logical/snapshots directory Vijaykumar Jain
• 22:06   Re: Is there something similar like flashback query from Oracle planned for PostgreSQL Vijaykumar Jain

24 June 2021

• 01:25   Re: Psql wants to use IP6 when connecting to self using tcp... Jerry LeVan
• 01:31   Partitioned Table Index Column Order Rumpi Gravenstein
• 01:55   Re: Partitioned Table Index Column Order Alvaro Herrera
• 01:56   Re: How to hash a large amount of data within Postgres? Tomas Vondra
• 02:37   Re: Is there something similar like flashback query from Oracle planned for PostgreSQL Thomas Munro
• 02:39   Re: Partitioned Table Index Column Order Tom Lane
• 02:53   Re: Partitioned Table Index Column Order David Rowley
• 02:56   Re: Partitioned Table Index Column Order Tom Lane
• 03:33   Re: Psql wants to use IP6 when connecting to self using tcp... Tom Lane
• 03:43   Re: Partitioned Table Index Column Order David Rowley
• 03:45   Re: Psql wants to use IP6 when connecting to self using tcp... Alan Hodgson
• 10:16   Re: [SPAM] Re: How to hash a large amount of data within Postgres? Thorsten Schöning
• 12:31   insert ..... returning problem Michael Ivanov
• 14:06   Re: Postgres PANIC when it could not open file in pg_logical/snapshots directory Vijaykumar Jain
• 15:33   removing "serial" from table definitions. Marc Mamin
• 15:42   Re: removing "serial" from table definitions. Johannes Paul
• 15:47   Re: removing "serial" from table definitions. Joe Conway
• 15:53   Re: second CTE kills perf Nicolas Seinlet
• 16:14   Re: insert ..... returning problem Laurenz Albe
• 16:24   How much data does server side "loread" return? Thorsten Schöning
• 16:25   Re: insert ..... returning problem Michael Ivanov
• 16:29   RE: removing "serial" from table definitions. Marc Mamin
• 16:44   OSX: migrating Postgres db from one Mac to another Carlo Poso
• 16:45   Re: insert ..... returning problem Sándor Daku
• 16:53   OSX: migrating Postgres db from one Mac to another Carlo Poso
• 16:55   Re: OSX: migrating Postgres db from one Mac to another Дмитрий Иванов
• 17:03   RE: removing "serial" from table definitions. Marc Mamin
• 17:13   Re: insert ..... returning problem Laurenz Albe
• 17:15   Re: OSX: migrating Postgres db from one Mac to another Carlo Poso
• 17:19   Re: removing "serial" from table definitions. Tom Lane
• 17:29   Re: insert ..... returning problem Michael Ivanov
• 17:31   Re: OSX: migrating Postgres db from one Mac to another Tom Lane
• 17:32   Re: OSX: migrating Postgres db from one Mac to another Adrian Klaver
• 18:42   Re: Psql wants to use IP6 when connecting to self using tcp... Peter J. Holzer
• 23:26   Re: Psql wants to use IP6 when connecting to self using tcp... Tom Lane

25 June 2021

• 00:33   Ubuntu 14.04 (trusty) Postgres 13 deb package Bhavesh Mistry
• 12:39   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Karsten Hilbert
• 12:50   Re: pg_dump/pg_restore vs default_transaction_read_only under PG 13.2 Karsten Hilbert
• 13:29   Difference between text_pattern_ops and varchar_pattern_ops David Morgenstern
• 16:38   Re: Difference between text_pattern_ops and varchar_pattern_ops Tom Lane

26 June 2021

• 07:56   What is the difference between context of "sighup", "super-backend", and "backend" in pg_settings? 周书林
• 08:01   Re: What is the difference between context of "sighup", "super-backend", and "backend" in pg_settings? Julien Rouhaud

27 June 2021

• 20:53   Re: Ubuntu 14.04 (trusty) Postgres 13 deb package Adrian Klaver
• 21:18   GIN indexed unique constraint? Allan Kamau
• 21:28   Re: GIN indexed unique constraint? David G. Johnston
• 21:41   Re: GIN indexed unique constraint? Tom Lane
• 22:39   Re: GIN indexed unique constraint? Allan Kamau

28 June 2021

• 01:41   Overlapping timestamptz ranges with priority Ray O'Donnell
• 02:52   Re: Overlapping timestamptz ranges with priority Adrian Klaver
• 10:23   Re: Overlapping timestamptz ranges with priority Alban Hertroys
• 12:57   pg_restore disable-triggers current session Dolors Segura
• 13:05   Re: Overlapping timestamptz ranges with priority Ray O'Donnell
• 13:50   schema prefixes in default values (was RE: removing "serial" from table definitions). Marc Mamin
• 14:41   Memory activities to monitor in statistics collector? Yu Watanabe
• 16:26   WARNING: skipping "pg_database" --- only superuser can analyze it Abraham, Danny
• 16:34   Re: schema prefixes in default values (was RE: removing "serial" from table definitions). Tom Lane
• 17:52   Re: WARNING: skipping "pg_database" --- only superuser can analyze it Tom Lane
• 19:28   Re: Ubuntu 14.04 (trusty) Postgres 13 deb package Joshua Drake
• 20:57   RE: Re: WARNING: skipping "pg_database" --- only superuser can analyze it Abraham, Danny
• 21:28   Use case stuck due to Partitioning Shubham Mittal
• 22:51   Re: Use case stuck due to Partitioning Michael Lewis
• 23:09   Re: Use case stuck due to Partitioning Shubham Mittal

29 June 2021

• 00:08   ALTER TABLE ... DETACH PARTITION just sitting there Ron
• 00:16   Re: ALTER TABLE ... DETACH PARTITION just sitting there Tom Lane
• 00:19   Re: ALTER TABLE ... DETACH PARTITION just sitting there Alvaro Herrera
• 00:51   Re: Use case stuck due to Partitioning Michael Lewis
• 00:52   Re: ALTER TABLE ... DETACH PARTITION just sitting there Ron
• 02:10   Re: Use case stuck due to Partitioning David G. Johnston
• 04:50   Re: ALTER TABLE ... DETACH PARTITION just sitting there Laurenz Albe
• 06:53   CREATE INDEX ONLY on a partitioned table? Ron
• 18:10   Do table-level CHECK constraints affect the query optimizer? Ron
• 18:41   Re: Do table-level CHECK constraints affect the query optimizer? Michael Lewis
• 19:13   Re: Do table-level CHECK constraints affect the query optimizer? Ron
• 19:21   Re: Do table-level CHECK constraints affect the query optimizer? Michael Lewis
• 19:42   Re: Do table-level CHECK constraints affect the query optimizer? Tom Lane
• 20:33   Re: Do table-level CHECK constraints affect the query optimizer? Ron
• 20:46   Re: Do table-level CHECK constraints affect the query optimizer? Tom Lane
• 20:46   Re: Do table-level CHECK constraints affect the query optimizer? Mark Dilger
• 21:02   Re: Do table-level CHECK constraints affect the query optimizer? Ron
• 21:03   Re: Do table-level CHECK constraints affect the query optimizer? Mark Dilger
• 22:43   Re: Overlapping timestamptz ranges with priority Adrian Klaver
• 22:49   Re: Overlapping timestamptz ranges with priority Ray O'Donnell
• 23:21   PGDLLIMPORT: patch or not to patch George Tarasov
• 23:22   Unable to isntall Natália Braz
• 23:49   Re: PGDLLIMPORT: patch or not to patch Tom Lane

30 June 2021

• 00:10   Re: Overlapping timestamptz ranges with priority Adrian Klaver
• 00:30   Re: Overlapping timestamptz ranges with priority Ray O'Donnell
• 00:49   Re: Overlapping timestamptz ranges with priority Adrian Klaver
• 09:33   postgresql version 13 repo question Yi Sun
• 10:54   Re: Connecting to Postgresql without IP address sivapostgres@yahoo.com
• 12:03   DBAs using PostgreSQL sought for paid research study Neil Turner
• 12:03   Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1 Thomas Boussekey