Postgresql General Discussion

• Thread Index

• Re: Oracle vs. PostgreSQL - a comment
  • From: Karsten Hilbert
• Pglogical 2.3.0 in AWS RDS 12.2
  • From: Igor Polishchuk
• Re: psql12.3 + jdbc_fdw - return wrong query results by using OR
  • From: Ying Lu
• Re: Suggestion to Monitoring Tool
  • From: Keith Fiske
• Re: Vanishing unique constraint
  • From: Julien Rouhaud
• Re: Trigger not firing
  • From: Adrian Klaver
• Re: pg_ctl can't start db server
  • From: Adrian Klaver
• Re: Oracle vs. PostgreSQL - a comment
  • From: Ravi Krishna
• Re: Vanishing unique constraint
  • From: Bernhard Beroun
• Re: Vanishing unique constraint
  • From: Julien Rouhaud
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Paul Förster
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Andrus
• Re: Trigger not firing
  • From: Hans
• Re: Trigger not firing
  • From: Pavel Stehule
• Re: Trigger not firing
  • From: Hans
• Re: Oracle vs. PostgreSQL - a comment
  • From: Peter J. Holzer
• Vanishing unique constraint
  • From: Bernhard Beroun
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Magnus Hagander
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Paul Förster
• Re: Postgresql 9.6 -> AWS RDS Postgresql 12.2 with pg_logical
  • From: Peter Eisentraut
• Re: pg_stat_sql_plans ALPHA released
  • From: legrand legrand
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Andrus
• Re: problem with self built postgres 9.0.9
  • From: Gabriele Bulfon
• Re: Oracle vs. PostgreSQL - a comment
  • From: Thomas Kellerer
• Re: Oracle vs. PostgreSQL - a comment
  • From: Paul Förster
• Re: Oracle vs. PostgreSQL - a comment
  • From: Jayadevan M
• Re: pg_ctl can't start db server
  • From: Paul Förster
• Re: Oracle vs. PostgreSQL - a comment
  • From: Paul Förster
• RE: pg_ctl can't start db server
  • From: Tanja Savic
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Andrus
• Re: Oracle vs. PostgreSQL - a comment
  • From: Stefan Knecht
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Adrian Klaver
• Re: Suggestion to Monitoring Tool
  • From: Rene Romero Benavides
• Re: Oracle vs. PostgreSQL - a comment
  • From: Stefan Keller
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Andrus
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Andrus
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Paul Förster
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Adrian Klaver
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Adrian Klaver
• Re: PG server process can keep some info of backend
  • From: Michel Pelletier
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Andrus
• Re: pg_dump of database with numerous objects
  • From: Adrian Klaver
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Andrus
• Re: pg_dump of database with numerous objects
  • From: Christophe Pettus
• Re: pg_dump of database with numerous objects
  • From: Adrian Klaver
• Re: pg_dump of database with numerous objects
  • From: Christophe Pettus
• Re: pg_dump of database with numerous objects
  • From: tony
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Paul Förster
• Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Adrian Klaver
• How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
  • From: Andrus
• Re: pg_dump of database with numerous objects
  • From: Christophe Pettus
• Re: pg_dump of database with numerous objects
  • From: tony
• Re: pg_dump of database with numerous objects
  • From: Adrian Klaver
• Re: Trigger not firing
  • From: Adrian Klaver
• Re: Oracle vs. PostgreSQL - a comment
  • From: Paul Förster
• pg_dump of database with numerous objects
  • From: tony
• Re: Postgresql 9.6 -> AWS RDS Postgresql 12.2 with pg_logical
  • From: Ben Chobot
• Re: Oracle vs. PostgreSQL - a comment
  • From: Tim Cross
• Trigger not firing
  • From: Hans
• Re: Oracle vs. PostgreSQL - a comment
  • From: Paul Förster
• Postgresql 9.6 -> AWS RDS Postgresql 12.2 with pg_logical
  • From: Igor Polishchuk
• Re: lib/libecpg.so.6.11 && valgrind
  • From: Michael Paquier
• Re: Oracle vs. PostgreSQL - a comment
  • From: Tim Cross
• Oracle vs. PostgreSQL - a comment
  • From: Paul Förster
• Re: Audit Role Connections
  • From: Chris Morris
• Re: Audit Role Connections
  • From: Peter J. Holzer
• Re: pg_ctl can't start db server
  • From: Adrian Klaver
• Audit Role Connections
  • From: Chris Morris
• Re: pg_ctl can't start db server
  • From: Tom Lane
• pg_ctl can't start db server
  • From: Tanja Savic
• Re: problem with self built postgres 9.0.9
  • From: Tom Lane
• Re: problem with self built postgres 9.0.9
  • From: David G. Johnston
• Re: problem with self built postgres 9.0.9
  • From: Gabriele Bulfon
• Re: problem with self built postgres 9.0.9
  • From: Adrian Klaver
• problem with self built postgres 9.0.9
  • From: Gabriele Bulfon
• lib/libecpg.so.6.11 && valgrind
  • From: Matthias Apitz
• Re: Slow SELECT
  • From: Frank Millman
• Re: Linux Update Experience
  • From: Christoph Moench-Tegeder
• PG server process can keep some info of backend
  • From: brajmohan saxena
• Re: Linux Update Experience
  • From: Peter J. Holzer
• Re: psql12.3 + jdbc_fdw - return wrong query results by using OR
  • From: Laurenz Albe
• Re: GPG signing
  • From: Michel Pelletier
• Re: GPG signing
  • From: Marc Munro
• Re: AW: Linux Update Experience
  • From: Tim Cross
• Re: psql12.3 + jdbc_fdw - return wrong query results by using OR
  • From: Tom Lane
• Re: psql12.3 + jdbc_fdw - return wrong query results by using OR
  • From: Ying Lu
• Re: psql12.3 + jdbc_fdw - return wrong query results by using OR
  • From: Adrian Klaver
• Re: psql12.3 + jdbc_fdw - return wrong query results by using OR
  • From: Adrian Klaver
• psql12.3 + jdbc_fdw - return wrong query results by using OR
  • From: emilu
• Re: Linux Update Experience
  • From: Karsten Hilbert
• Re: AW: Linux Update Experience
  • From: Adrian Klaver
• AW: Linux Update Experience
  • From: Zwettler Markus (OIZ)
• Re: Linux Update Experience
  • From: Adrian Klaver
• Re: Order by lower(column-alias) doesn't work...
  • From: Andreas Joseph Krogh
• Re: Order by lower(column-alias) doesn't work...
  • From: Tom Lane
• Re: Order by lower(column-alias) doesn't work...
  • From: Andreas Joseph Krogh
• Re: Order by lower(column-alias) doesn't work...
  • From: Geoff Winkless
• AW: Linux Update Experience
  • From: Marco Lechner
• Order by lower(column-alias) doesn't work...
  • From: Andreas Joseph Krogh
• AW: Linux Update Experience
  • From: Zwettler Markus (OIZ)
• Re: AW: Linux Update Experience
  • From: Alan Hodgson
• Re: Suggestion to Monitoring Tool
  • From: Stéphane KANSCHINE
• AW: Linux Update Experience
  • From: Marco Lechner
• Re: Linux Update Experience
  • From: Jiří Fejfar
• Linux Update Experience
  • From: Zwettler Markus (OIZ)
• Re: Can't remove default permissions entry
  • From: Laurenz Albe
• Re: SELECT query results are different depending on whether table statistics are available.
  • From: James Brauman
• Re: SELECT query results are different depending on whether table statistics are available.
  • From: David G. Johnston
• SELECT query results are different depending on whether table statistics are available.
  • From: James Brauman
• Re: GPG signing
  • From: Michel Pelletier
• Re: GPG signing
  • From: Michel Pelletier
• Re: Suggest the Schedular for activities
  • From: Adrian Klaver
• Re: Can't remove default permissions entry
  • From: Adrian Klaver
• Changing wal segment size on existing database cluster
  • From: James Lucas
• Re: Suggestion to Monitoring Tool
  • From: zurich
• Re: suggestion the process to sync the data from PROD DB to Staging environment
  • From: soumitra bhandary
• Re: Suggestion to Monitoring Tool
  • From: soumitra bhandary
• Re: suggestion the process to sync the data from PROD DB to Staging environment
  • From: David G. Johnston
• Can't remove default permissions entry
  • From: Christophe Pettus
• Re: Suggestion to Monitoring Tool
  • From: Karsten Hilbert
• Suggestion to Monitoring Tool
  • From: postgann2020 s
• Re: suggestion the process to sync the data from PROD DB to Staging environment
  • From: postgann2020 s
• Re: suggestion the process to sync the data from PROD DB to Staging environment
  • From: David G. Johnston
• Re: Install PostgreSQL on windows 10 home 64-bit machine
  • From: Prashanth Talla
• Re: suggestion the process to sync the data from PROD DB to Staging environment
  • From: postgann2020 s
• Suggest the Schedular for activities
  • From: postgann2020 s
• Re: suggestion the process to sync the data from PROD DB to Staging environment
  • From: Luan Huynh
• suggestion the process to sync the data from PROD DB to Staging environment
  • From: postgann2020 s
• Re: Install PostgreSQL on windows 10 home 64-bit machine
  • From: Olivier Gautherot
• Re: pg_basebackup + delta base backups
  • From: Christopher Pereira
• Install PostgreSQL on windows 10 home 64-bit machine
  • From: Prashanth Talla
• Re: GPG signing
  • From: Tim Cross
• Re: GPG signing
  • From: raf
• Re: GPG signing
  • From: Marc Munro
• Re: GPG signing
  • From: David G. Johnston
• Re: GPG signing
  • From: Adrian Klaver
• GPG signing
  • From: Marc Munro
• Re: Advise on how to install pl/perl on existing DB.
  • From: Adrian Klaver
• Re: Advise on how to install pl/perl on existing DB.
  • From: Alan Hodgson
• Advise on how to install pl/perl on existing DB.
  • From: David Gauthier
• Re: Help understanding SIReadLock growing without bound on completed transaction
  • From: Mike Klaas
• Re: Help understanding SIReadLock growing without bound on completed transaction
  • From: Mike Klaas
• Re: pg_basebackup + incremental base backups
  • From: Stephen Frost
• Re: Slow SELECT
  • From: Frank Millman
• Re: Slow SELECT
  • From: David Rowley
• Re: Slow SELECT
  • From: David Rowley
• Re: Slow SELECT
  • From: Vik Fearing
• Re: Slow SELECT
  • From: Frank Millman
• Re: Slow SELECT
  • From: Frank Millman
• Re: Slow SELECT
  • From: Frank Millman
• Re: Slow SELECT
  • From: David Rowley
• Re: Slow SELECT
  • From: Christian Ramseyer
• Re: Slow SELECT
  • From: Frank Millman
• Re: Slow SELECT
  • From: Charles Clavadetscher
• Re: Slow SELECT
  • From: Charles Clavadetscher
• Re: Slow SELECT
  • From: Frank Millman
• Re: Slow SELECT
  • From: Olivier Gautherot
• Slow SELECT
  • From: Frank Millman
• Re: pg_basebackup + incremental base backups
  • From: Christopher Pereira
• Re: FDW and RLS
  • From: Charles Clavadetscher
• Re: pg_dump crashes
  • From: Adrian Klaver
• Re: FDW and RLS
  • From: Laurenz Albe
• Re: Logical replication troubles
  • From: Peter Eisentraut
• Re: Logical replication troubles
  • From: Anders Bøgh Bruun
• Re: Query returns no rows in pg_basebackup cluster
  • From: Andrus
• Re: Request to help on Query improvement suggestion.
  • From: Laurenz Albe
• Re: Query returns no rows in pg_basebackup cluster
  • From: David G. Johnston
• Re: Query returns no rows in pg_basebackup cluster
  • From: Michael Paquier
• Re: Query returns no rows in pg_basebackup cluster
  • From: Andrus
• Re: Query returns no rows in pg_basebackup cluster
  • From: Andrus
• Re: pg_dump crashes
  • From: Nico De Ranter
• Re: Query returns no rows in pg_basebackup cluster
  • From: Tom Lane
• Re: Query returns no rows in pg_basebackup cluster
  • From: David G. Johnston
• Re: Query returns no rows in pg_basebackup cluster
  • From: Michael Paquier
• Re: pg_basebackup + incremental base backups
  • From: Stephen Frost
• Re: pg_basebackup + incremental base backups
  • From: Christopher Pereira
• Help with streaming replication protocol
  • From: Christopher Bottaro
• Re: query, probably needs window functions
  • From: Scott Ribe
• Re: libgeotiff missing
  • From: Richard Suematsu
• Re: libgeotiff missing
  • From: Adrian Klaver
• Re: Table partitioning for cloud service?
  • From: Edson Richter
• Re: Regarding creation of gin index on column that has varchar datatype
  • From: Durgamahesh Manne
• Re: Regarding creation of gin index on column that has varchar datatype
  • From: Andreas Kretschmer
• Regarding creation of gin index on column that has varchar datatype
  • From: Durgamahesh Manne
• libgeotiff missing
  • From: Richard Suematsu
• Re: Help understanding SIReadLock growing without bound on completed transaction
  • From: Thomas Munro
• Re: query, probably needs window functions
  • From: David G. Johnston
• Re: query, probably needs window functions
  • From: Michael Lewis
• Re: Query returns no rows in pg_basebackup cluster
  • From: Andrus
• Re: query, probably needs window functions
  • From: David G. Johnston
• query, probably needs window functions
  • From: Scott Ribe
• Re: How to get the OID of a view
  • From: David G. Johnston
• Re: How to get the OID of a view
  • From: Charles Clavadetscher
• Re: How to get the OID of a view
  • From: Adrian Klaver
• Re: How to get the OID of a view
  • From: Tom Lane
• How to get the OID of a view
  • From: stan
• Re: pg_dump crashes
  • From: Adrian Klaver
• Re: pg_dump crashes
  • From: Adrian Klaver
• Re: pg_dump crashes
  • From: Adrian Klaver
• Re: Query returns no rows in pg_basebackup cluster
  • From: Tom Lane
• Re: pg_dump crashes
  • From: Nico De Ranter
• Re: Query returns no rows in pg_basebackup cluster
  • From: Andrus
• Re: btree_gist extension - gbt_cash_union return type
  • From: Tim Kane
• Re: Query to get name a data type of a view
  • From: David G. Johnston
• Re: pg_dump crashes
  • From: Adrian Klaver
• Re: pg_dump crashes
  • From: Nico De Ranter
• Query to get name a data type of a view
  • From: stan
• Re: pg_dump crashes
  • From: Nico De Ranter
• Re: pg_dump crashes
  • From: Adrian Klaver
• Re: pg_dump crashes
  • From: Adrian Klaver
• Re: pg_dump crashes
  • From: Nico De Ranter
• Re: pg_dump crashes
  • From: Adrian Klaver
• Re: pg_dump crashes
  • From: Nico De Ranter
• Re: pg_dump crashes
  • From: Nico De Ranter
• Re: pg_dump crashes
  • From: Adrian Klaver
• Re: btree_gist extension - gbt_cash_union return type
  • From: Tom Lane
• Re: Inaccurate (sometimes wildly so) row estimates for simple join
  • From: Greg Nolle
• Re: Inaccurate (sometimes wildly so) row estimates for simple join
  • From: Michael Lewis
• Re: Suggestion to improve query performance of data validation in proc.
  • From: Michael Lewis
• Re: Query returns no rows in pg_basebackup cluster
  • From: Tom Lane
• Re: pg_dump crashes
  • From: Ron
• Re: Request to help on GIS Query improvement suggestion.
  • From: Michael Lewis
• Re: pg_dump crashes
  • From: Andreas Kretschmer
• Re: pg_dump crashes
  • From: Nico De Ranter
• Re: pg_dump crashes
  • From: Nico De Ranter
• Re: pg_dump crashes
  • From: Adrian Klaver
• Re: pg_dump crashes
  • From: Adrian Klaver
• Re: Failed rpm package signature checks with reposync
  • From: mkruk
• Request to help on Query improvement suggestion.
  • From: devchef2020 d
• Re: pg_basebackup + incremental base backups
  • From: Christopher Pereira
• Inaccurate (sometimes wildly so) row estimates for simple join
  • From: Greg Nolle
• FDW and RLS
  • From: Ted Toth
• pg_dump crashes
  • From: Nico De Ranter
• Request to help on GIS Query improvement suggestion.
  • From: postggen2020 s
• Re: Logical replication troubles
  • From: Peter Eisentraut
• btree_gist extension - gbt_cash_union return type
  • From: Tim Kane
• Re: Suggestion to improve query performance of data validation in proc.
  • From: David G. Johnston
• Re: Suggestion to improve query performance of data validation in proc.
  • From: postgann2020 s
• Re: Suggestion to improve query performance of data validation in proc.
  • From: David G. Johnston
• Re: Query returns no rows in pg_basebackup cluster
  • From: Andrus
• Suggestion to improve query performance of data validation in proc.
  • From: postgann2020 s
• Re: Query returns no rows in pg_basebackup cluster
  • From: Andrus
• Re: Query returns no rows in pg_basebackup cluster
  • From: David G. Johnston
• Re: Query returns no rows in pg_basebackup cluster
  • From: Andrus
• Re: Query returns no rows in pg_basebackup cluster
  • From: Andrus
• Re: Query returns no rows in pg_basebackup cluster
  • From: Andrus
• Re: Help understanding SIReadLock growing without bound on completed transaction
  • From: Mike Klaas
• Re: Help understanding SIReadLock growing without bound on completed transaction
  • From: Thomas Munro
• Re: Should I use JSON?
  • From: Tim Cross
• Re: Query returns no rows in pg_basebackup cluster
  • From: Tom Lane
• Re: Query returns no rows in pg_basebackup cluster
  • From: Adrian Klaver
• Re: Query returns no rows in pg_basebackup cluster
  • From: David G. Johnston
• Re: Query returns no rows in pg_basebackup cluster
  • From: Adrian Klaver
• Re: Query returns no rows in pg_basebackup cluster
  • From: Tom Lane
• Re: Query returns no rows in pg_basebackup cluster
  • From: Adrian Klaver
• Re: Table partitioning for cloud service?
  • From: Adrian Klaver
• Re: pg_basebackup + incremental base backups
  • From: Stephen Frost
• Re: Table partitioning for cloud service?
  • From: Ravi Krishna
• Re: Strategy for materialisation and centralisation of data
  • From: Rory Campbell-Lange
• Re: Strategy for materialisation and centralisation of data
  • From: Michael Stephenson
• RE: Should I use JSON?
  • From: Zahir Lalani
• Re: Strategy for materialisation and centralisation of data
  • From: Karsten Hilbert
• Re: Strategy for materialisation and centralisation of data
  • From: Rory Campbell-Lange
• Re: Table partitioning for cloud service?
  • From: Israel Brewster
• Query returns no rows in pg_basebackup cluster
  • From: Andrus
• Re: Table partitioning for cloud service?
  • From: Sándor Daku
• Help understanding SIReadLock growing without bound on completed transaction
  • From: Mike Klaas
• Re: Strategy for materialisation and centralisation of data
  • From: Karsten Hilbert
• Re: Should I use JSON?
  • From: pabloa98
• Re: Table partitioning for cloud service?
  • From: Michael Lewis
• Re: Table partitioning for cloud service?
  • From: Adam Brusselback
• Re: Table partitioning for cloud service?
  • From: Israel Brewster
• Re: Table partitioning for cloud service?
  • From: Christopher Browne
• Re: Table partitioning for cloud service?
  • From: Adrian Klaver
• Re: Should I use JSON?
  • From: David G. Johnston
• Re: Table partitioning for cloud service?
  • From: Israel Brewster
• Re: Should I use JSON?
  • From: Adrian Klaver
• Should I use JSON?
  • From: stan
• Re: Table partitioning for cloud service?
  • From: Adrian Klaver
• Table partitioning for cloud service?
  • From: Israel Brewster
• Re: Suggestion on index creation for TEXT data field
  • From: postgann2020 s
• Re: Suggestion on index creation for TEXT data field
  • From: David G. Johnston
• Re: Suggestion on table analyze
  • From: postgann2020 s
• Re: Suggestion on index creation for TEXT data field
  • From: Adrian Klaver
• Re: Suggestion on index creation for TEXT data field
  • From: postgann2020 s
• Re: Suggestion on table analyze
  • From: Adrian Klaver
• Re: Suggestion on index creation for TEXT data field
  • From: David G. Johnston
• Strategy for materialisation and centralisation of data
  • From: Rory Campbell-Lange
• Re: Behaviour of failed Primary
  • From: Amit Kapila
• Suggestion on index creation for TEXT data field
  • From: postgann2020 s
• Suggestion on table analyze
  • From: postgann2020 s
• Re: pg_basebackup + incremental base backups
  • From: Stephen Frost
• Behaviour of failed Primary
  • From: Santhosh Kumar
• Re: pg_basebackup + incremental base backups
  • From: Christopher Pereira
• Re: How to recover from compressed wal archieve in windows
  • From: Andrus
• Re: How to recover from compressed wal archieve in windows
  • From: Michael Paquier
• Re: How to recover from compressed wal archieve in windows
  • From: Kyotaro Horiguchi
• Re: How to recover from compressed wal archieve in windows
  • From: Paul Förster
• Re: How to recover from compressed wal archieve in windows
  • From: Kyotaro Horiguchi
• Re: How to recover from compressed wal archieve in windows
  • From: Adrian Klaver
• Re: How to recover from compressed wal archieve in windows
  • From: Michael Paquier
• Re: How to recover from compressed wal archieve in windows
  • From: Adrian Klaver
• Re: How to recover from compressed wal archieve in windows
  • From: Adrian Klaver
• Re: SET ROLE and search_path
  • From: Stephen Frost
• Re: SET ROLE and search_path
  • From: Tom Lane
• Re: SET ROLE and search_path
  • From: Patrick FICHE
• Question on removing primary replication node using repmgr?
  • From: Lu, Dan
• Re: SET ROLE and search_path
  • From: Rob Sargent
• Re: SET ROLE and search_path
  • From: Adam Brusselback
• Re: How to recover from compressed wal archieve in windows
  • From: Andrus
• Re: How to recover from compressed wal archieve in windows
  • From: Paul Förster
• Re: How to recover from compressed wal archieve in windows
  • From: Adrian Klaver
• Suggestion to improve query performance.
  • From: postgann2020 s
• Re: SET ROLE and search_path
  • From: Rob Sargent
• Re: Huge tables, trying to delete OID's taking 6+hours per table
  • From: Ron
• SET ROLE and search_path
  • From: Patrick FICHE
• Re: Huge tables, trying to delete OID's taking 6+hours per table
  • From: Tory M Blue
• Re: PostgreSQLBook
  • From: edavis
• Re: PostgreSQLBook
  • From: Paul Förster
• PostgreSQLBook
  • From: edavis
• Re: Logical replication troubles
  • From: Anders Bøgh Bruun
• How to recover from compressed wal archieve in windows
  • From: Andrus
• Re: Logical replication troubles
  • From: Peter Eisentraut
• Re: A limit clause can cause a poor index choice
  • From: Nick Cleaton
• Re: A limit clause can cause a poor index choice
  • From: Nick Cleaton
• Re: Q: Comparing PostgreSQL and Oracle
  • From: pabloa98
• Re: Q: Comparing PostgreSQL and Oracle
  • From: Steve Baldwin
• RE: Q: Comparing PostgreSQL and Oracle
  • From: Ahmed, Nawaz (Fuji Xerox Australia)
• Re: Q: Comparing PostgreSQL and Oracle
  • From: Pavel Stehule
• Q: Comparing PostgreSQL and Oracle
  • From: Alfonso
• Re: Removing Last field from CSV string
  • From: Samuel Roseman
• Re: Configuring more than one hot standby server
  • From: Kyotaro Horiguchi
• Re: A limit clause can cause a poor index choice
  • From: Mohamed Wael Khobalatte
• Re: A limit clause can cause a poor index choice
  • From: Michael Lewis
• Clarification relation logical replication
  • From: Santhosh Kumar
• Configuring more than one hot standby server
  • From: Santhosh Kumar
• A limit clause can cause a poor index choice
  • From: Nick Cleaton
• Re: Unique index on hash of jsonb value - correct solution?
  • From: Albrecht Dreß
• Re: idle_in_transaction_session_timeout not getting log in PG v12.2
  • From: Adrian Klaver
• Re: Huge tables, trying to delete OID's taking 6+hours per table
  • From: Ron
• Re: Huge tables, trying to delete OID's taking 6+hours per table
  • From: Tory M Blue
• Re: idle_in_transaction_session_timeout not getting log in PG v12.2
  • From: Adrian Klaver
• RE: idle_in_transaction_session_timeout not getting log in PG v12.2
  • From: Ishan Joshi
• Re: idle_in_transaction_session_timeout not getting log in PG v12.2
  • From: Adrian Klaver
• RE: idle_in_transaction_session_timeout not getting log in PG v12.2
  • From: Ishan Joshi
• Re: idle_in_transaction_session_timeout not getting log in PG v12.2
  • From: Adrian Klaver
• Re: Unique index on hash of jsonb value - correct solution?
  • From: Stephen Frost
• RE: idle_in_transaction_session_timeout not getting log in PG v12.2
  • From: Ishan Joshi
• Re: idle_in_transaction_session_timeout not getting log in PG v12.2
  • From: Adrian Klaver
• Re: Huge tables, trying to delete OID's taking 6+hours per table
  • From: Tom Lane
• idle_in_transaction_session_timeout not getting log in PG v12.2
  • From: Ishan Joshi
• Re: Hot and PITR backups in same server
  • From: Andrus
• Re: Huge tables, trying to delete OID's taking 6+hours per table
  • From: Tory M Blue
• Logical replication troubles
  • From: Anders Bøgh Bruun
• Huge tables, trying to delete OID's taking 6+hours per table
  • From: Tory M Blue
• Re: Hot and PITR backups in same server
  • From: Kyotaro Horiguchi
• Re: Unique index on hash of jsonb value - correct solution?
  • From: Laurenz Albe
• Re: template0 needing vacuum freeze?
  • From: Adrian Klaver
• Re: template0 needing vacuum freeze?
  • From: Don Seiler
• Re: template0 needing vacuum freeze?
  • From: Tom Lane
• Re: template0 needing vacuum freeze?
  • From: Don Seiler
• Unique index on hash of jsonb value - correct solution?
  • From: Albrecht Dreß
• Re: Hot and PITR backups in same server
  • From: Andrus
• pg_basebackup: child process exited with error 1
  • From: Ram Pratap Maurya
• Re: Bug on version 12 ?
  • From: Laurenz Albe
• Re: template0 needing vacuum freeze?
  • From: Laurenz Albe
• Re: Hot and PITR backups in same server
  • From: Laurenz Albe
• Re: Inherited an 18TB DB & need to backup
  • From: Suhail Bamzena
• Re: Removing Last field from CSV string
  • From: Steve Litt
• Re: Inherited an 18TB DB & need to backup
  • From: Steve Litt
• Re: Inherited an 18TB DB & need to backup
  • From: James Sewell
• Re: Using b-tree index for >= condition when joining
  • From: Łukasz Dąbek
• NFS version for replication
  • From: Weatherby,Gerard
• Hot and PITR backups in same server
  • From: Andrus
• Re: Password reset
  • From: Peter J. Holzer
• Password reset
  • From: Jessie Nava
• Re: Inherited an 18TB DB & need to backup
  • From: Ron
• Re: Using b-tree index for >= condition when joining
  • From: Tom Lane
• Re: Ubuntu 20.04: apt.postgresql.org/pub/repos/apt focal-pgdg InRelease' doesn't support architecture 'i386'
  • From: Tim Cross
• Re: Ubuntu 20.04: apt.postgresql.org/pub/repos/apt focal-pgdg InRelease' doesn't support architecture 'i386'
  • From: Thomas Munro
• Re: Ubuntu 20.04: apt.postgresql.org/pub/repos/apt focal-pgdg InRelease' doesn't support architecture 'i386'
  • From: Adrian Klaver
• Ubuntu 20.04: apt.postgresql.org/pub/repos/apt focal-pgdg InRelease' doesn't support architecture 'i386'
  • From: Hugh
• Re: Inherited an 18TB DB & need to backup
  • From: Gavin Flower
• Re: Inherited an 18TB DB & need to backup
  • From: Ron
• Re: Removing Last field from CSV string
  • From: Christian Ramseyer
• Using b-tree index for >= condition when joining
  • From: Łukasz Dąbek
• Re: template0 needing vacuum freeze?
  • From: Don Seiler
• Re: template0 needing vacuum freeze?
  • From: Tom Lane
• Re: Removing Last field from CSV string
  • From: Michael Nolan
• template0 needing vacuum freeze?
  • From: Don Seiler
• Re: Removing Last field from CSV string
  • From: Adrian Klaver
• Re: Removing Last field from CSV string
  • From: PALAYRET Jacques
• Re: schema agnostic functions in language sql
  • From: Rob Sargent
• Removing Last field from CSV string
  • From: Alex Magnum
• Re: schema agnostic functions in language sql
  • From: David G. Johnston
• Re: Inherited an 18TB DB & need to backup
  • From: Suhail Bamzena
• Re: Inherited an 18TB DB & need to backup
  • From: Peter J. Holzer
• Re: Circles with circle() vs ST_Buffer() Equality equalities
  • From: PALAYRET Jacques
• Re: Inherited an 18TB DB & need to backup
  • From: Rob Sargent
• Re: schema agnostic functions in language sql
  • From: Rob Sargent
• Re: Pgpool is crashing when terminating user session
  • From: Tatsuo Ishii
• Re: schema agnostic functions in language sql
  • From: Rob Sargent
• Pgpool is crashing when terminating user session
  • From: RAJAMOHAN
• Re: Column reset all values
  • From: Peter J. Holzer
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: Peter J. Holzer
• Re: Inherited an 18TB DB & need to backup
  • From: Ron
• Re: Inherited an 18TB DB & need to backup
  • From: Suhail Bamzena
• Re: schema agnostic functions in language sql
  • From: Tom Lane
• Re: schema agnostic functions in language sql
  • From: Adrian Klaver
• Re: schema agnostic functions in language sql
  • From: Rob Sargent
• Re: schema agnostic functions in language sql
  • From: Tom Lane
• Re: schema agnostic functions in language sql
  • From: Rob Sargent
• Re: schema agnostic functions in language sql
  • From: David G. Johnston
• Re: schema agnostic functions in language sql
  • From: Rob Sargent
• Re: Inherited an 18TB DB & need to backup
  • From: Michael Nolan
• Re: schema agnostic functions in language sql
  • From: Adrian Klaver
• Re: schema agnostic functions in language sql
  • From: Rob Sargent
• Re: schema agnostic functions in language sql
  • From: Adrian Klaver
• schema agnostic functions in language sql
  • From: Rob Sargent
• Re: Inherited an 18TB DB & need to backup
  • From: Ron
• Re: Inherited an 18TB DB & need to backup
  • From: Christophe Pettus
• Unexplained Access Exclusive Locks on Follower from PID7
  • From: Andy Cooper
• Re: Inherited an 18TB DB & need to backup
  • From: Scottix
• Re: Bug on version 12 ?
  • From: Adrian Klaver
• Re: Bug on version 12 ?
  • From: PegoraroF10
• Re: Inherited an 18TB DB & need to backup
  • From: Andreas 'ads' Scherbaum
• Re: Bug on version 12 ?
  • From: Tom Lane
• Re: Bug on version 12 ?
  • From: Adrian Klaver
• Re: Inherited an 18TB DB & need to backup
  • From: Ravi Krishna
• Re: Inherited an 18TB DB & need to backup
  • From: Andreas 'ads' Scherbaum
• Re: Bug on version 12 ?
  • From: John W Higgins
• Re: Bug on version 12 ?
  • From: PegoraroF10
• Re: Bug on version 12 ?
  • From: David G. Johnston
• Re: Bug on version 12 ?
  • From: Tom Lane
• Re: Bug on version 12 ?
  • From: PegoraroF10
• Re: Bug on version 12 ?
  • From: David G. Johnston
• Re: Inherited an 18TB DB & need to backup
  • From: Suhail Bamzena
• Re: Bug on version 12 ?
  • From: Michael Lewis
• Bug on version 12 ?
  • From: PegoraroF10
• Re: surprisingly slow creation of gist index used in exclude constraint
  • From: Chris Withers
• Re: Inherited an 18TB DB & need to backup
  • From: Gabriele Bartolini
• Re: Inherited an 18TB DB & need to backup
  • From: Ravi Krishna
• Re: PG12.2 Configure cannot enalble SSL
  • From: Gavan Schneider
• Re: PG12.2 Configure cannot enalble SSL
  • From: Gavan Schneider
• Re: Inherited an 18TB DB & need to backup
  • From: Suhail Bamzena
• Re: Inherited an 18TB DB & need to backup
  • From: Rory Campbell-Lange
• Re: Inherited an 18TB DB & need to backup
  • From: Suhail Bamzena
• Re: Inherited an 18TB DB & need to backup
  • From: Suhail Bamzena
• Re: Inherited an 18TB DB & need to backup
  • From: Jan Karremans
• Re: Inherited an 18TB DB & need to backup
  • From: Suhail Bamzena
• Re: Inherited an 18TB DB & need to backup
  • From: Suhail Bamzena
• Re: Inherited an 18TB DB & need to backup
  • From: Wolff, Ken L
• Re: Inherited an 18TB DB & need to backup
  • From: Jan Karremans
• Re: PG12.2 Configure cannot enalble SSL
  • From: Tom Lane
• Re: Inherited an 18TB DB & need to backup
  • From: Suhail Bamzena
• Re: surprisingly slow creation of gist index used in exclude constraint
  • From: Kenneth Marshall
• Re: Inherited an 18TB DB & need to backup
  • From: Christoph Berg
• Re: Inherited an 18TB DB & need to backup
  • From: Rory Campbell-Lange
• Re: Seamless Logical Replication during Fail-over
  • From: Peter Eisentraut
• Re: PG12.2 Configure cannot enalble SSL
  • From: Peter Eisentraut
• Re: PG12.2 Configure cannot enalble SSL
  • From: Gavan Schneider
• Seamless Logical Replication during Fail-over
  • From: Moor Ali
• Circles with circle() vs ST_Buffer() Equality equalities
  • From: PALAYRET Jacques
• Inherited an 18TB DB & need to backup
  • From: Suhail Bamzena
• Re: Check what has been done for a uncommitted prepared transaction
  • From: Laurenz Albe
• Re: surprisingly slow creation of gist index used in exclude constraint
  • From: Chris Withers
• Logical replication for async service communication?
  • From: Sean Huber
• Re: view selection during query rewrite
  • From: Tom Lane
• view selection during query rewrite
  • From: Vamsi Meduri
• Re: Check what has been done for a uncommitted prepared transaction
  • From: Andy Fan
• Re: vacuumdb --jobs deadlock: how to avoid pg_catalog ?
  • From: Michael Lewis
• Re: vacuumdb --jobs deadlock: how to avoid pg_catalog ?
  • From: Virendra Kumar
• Re: surprisingly slow creation of gist index used in exclude constraint
  • From: Tom Lane
• Re: vacuumdb --jobs deadlock: how to avoid pg_catalog ?
  • From: Eduard Rozenberg
• Re: vacuumdb --jobs deadlock: how to avoid pg_catalog ?
  • From: Eduard Rozenberg
• Re: surprisingly slow creation of gist index used in exclude constraint
  • From: ktm
• surprisingly slow creation of gist index used in exclude constraint
  • From: Chris Withers
• Re: vacuumdb --jobs deadlock: how to avoid pg_catalog ?
  • From: Adrian Klaver
• Re: vacuumdb --jobs deadlock: how to avoid pg_catalog ?
  • From: Adrian Klaver
• Re: Practical usage of large objects.
  • From: Thomas Markus
• Re: vacuumdb --jobs deadlock: how to avoid pg_catalog ?
  • From: Adrian Klaver
• vacuumdb --jobs deadlock: how to avoid pg_catalog ?
  • From: Eduard Rozenberg
• Re: Reuse an existing slot with a new initdb
  • From: Support
• Re: Practical usage of large objects.
  • From: Laurenz Albe
• Re: Reuse an existing slot with a new initdb
  • From: Tom Lane
• Re: Check what has been done for a uncommitted prepared transaction
  • From: Laurenz Albe
• Re: PG12.2 Configure cannot enalble SSL
  • From: Tom Lane
• Re: Column reset all values
  • From: otar shavadze
• Re: Clarification related to BDR
  • From: Ravi Krishna
• Re: Reuse an existing slot with a new initdb
  • From: Support
• Re: Clarification related to BDR
  • From: Simon Riggs
• Re: pg_upgrade too slow on vacuum phase
  • From: Kouber Saparev
• Re: Check what has been done for a uncommitted prepared transaction
  • From: Andy Fan
• Re: Clarification related to BDR
  • From: Andreas Kretschmer
• Re: Clarification related to BDR
  • From: Magnus Hagander
• Re: Check what has been done for a uncommitted prepared transaction
  • From: Michael Paquier
• Re: Check what has been done for a uncommitted prepared transaction
  • From: Andy Fan
• PG12.2 Configure cannot enalble SSL
  • From: Gavan Schneider
• Sv: Practical usage of large objects.
  • From: Andreas Joseph Krogh
• Check what has been done for a uncommitted prepared transaction
  • From: Andy Fan
• Clarification related to BDR
  • From: Santhosh Kumar
• Reuse an existing slot with a new initdb
  • From: David G. Johnston
• Re: Practical usage of large objects.
  • From: Michael Paquier
• Re: Reuse an existing slot with a new initdb
  • From: Michael Paquier
• Re: Practical usage of large objects.
  • From: Ron
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Adrian Klaver
• Re: Reuse an existing slot with a new initdb
  • From: Support
• Re: Reuse an existing slot with a new initdb
  • From: Support
• Re: Reuse an existing slot with a new initdb
  • From: live-school support
• Re: Reuse an existing slot with a new initdb
  • From: Laurenz Albe
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Matthias Apitz
• Re: Practical usage of large objects.
  • From: Tom Lane
• Practical usage of large objects.
  • From: Dmitry Igrishin
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Adrian Klaver
• Re: Why is it that “aggregate functions are not allowed in FROM clause of their own query level”?
  • From: Tom Lane
• Re: Create user mapping for role
  • From: Tom Lane
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: David Goodenough
• Create user mapping for role
  • From: Gerard Weatherby
• RE: Enforcing uniqueness on [real estate/postal] addresses
  • From: Basques, Bob (CI-StPaul)
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Tom Lane
• RE: Enforcing uniqueness on [real estate/postal] addresses
  • From: Rich Shepard
• Re: Why is it that “aggregate functions are not allowed in FROM clause of their own query level”?
  • From: David G. Johnston
• RE: Enforcing uniqueness on [real estate/postal] addresses
  • From: Basques, Bob (CI-StPaul)
• Re: Reuse an existing slot with a new initdb
  • From: Support
• Re: what is the best way to access cold data on another server?
  • From: Laurenz Albe
• Why is it that “aggregate functions are not allowed in FROM clause of their own query level”?
  • From: Tom Ellis
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Ravi Krishna
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Matthias Apitz
• Re: Column reset all values
  • From: Olivier Gautherot
• Re: Column reset all values
  • From: Peter J. Holzer
• Column reset all values
  • From: otar shavadze
• Re: [EXTERNAL] Re: PostgreSQL-12 replication failover, pg_rewind fails
  • From: Michael Paquier
• what is the best way to access cold data on another server?
  • From: Amine Tengilimoglu
• Re: [EXTERNAL] Re: PostgreSQL-12 replication failover, pg_rewind fails
  • From: Mariya Rampurawala
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Matthias Apitz
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Matthias Apitz
• Re: [EXTERNAL] Re: PostgreSQL-12 replication failover, pg_rewind fails
  • From: Kyotaro Horiguchi
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Adrian Klaver
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Tom Lane
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Matthias Apitz
• Re: Upgrade Process Says "The database server was not shut down cleanly" but it was
  • From: Adrian Klaver
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: Adrian Klaver
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: Rich Shepard
• Re: Upgrade Process Says "The database server was not shut down cleanly" but it was
  • From: TalGloz
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: Karsten Hilbert
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: Peter Devoy
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Adrian Klaver
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Matthias Apitz
• Re: System column xmin makes anonymity hard
  • From: Francisco Olarte
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Tory M Blue
• System column xmin makes anonymity hard
  • From: Johannes Linke
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: Peter J. Holzer
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Tory M Blue
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Tom Lane
• Re: Hash partitioning, what function is used to compute the hash?
  • From: Michael Lewis
• Re: AutoVacuum and growing transaction XID's
  • From: github kran
• Re: [EXTERNAL] Re: PostgreSQL-12 replication failover, pg_rewind fails
  • From: Laurenz Albe
• Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Adrian Klaver
• Re: pg_upgrade too slow on vacuum phase
  • From: Adrian Klaver
• ESQL/C: a ROLLBACK rolls back a COMMITED transaction
  • From: Matthias Apitz
• Re: [EXTERNAL] Re: PostgreSQL-12 replication failover, pg_rewind fails
  • From: Mariya Rampurawala
• pg_upgrade too slow on vacuum phase
  • From: Kouber Saparev
• Re: PostgreSQL-12 replication failover, pg_rewind fails
  • From: Kyotaro Horiguchi
• Re: create index insist on 2 workers only
  • From: Radoslav Nedyalkov
• Re: PostgreSQL-12 replication failover, pg_rewind fails
  • From: Mariya Rampurawala
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: David G. Johnston
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: David G. Johnston
• Re: Is there a significant difference in Memory settings between 9.5 and 12.
  • From: David G. Johnston
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Tory M Blue
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Tory M Blue
• Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
  • From: Matthias Apitz
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Tom Lane
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Tory M Blue
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Thomas Munro
• Re: Firing an event trigger for ADD COLUMN?
  • From: Michel Pelletier
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: David G. Johnston
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Tory M Blue
• Re: Upgrade Process Says "The database server was not shut down cleanly" but it was
  • From: Adrian Klaver
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: Tim Cross
• Re: Firing an event trigger for ADD COLUMN?
  • From: Alvaro Herrera
• Re: Firing an event trigger for ADD COLUMN?
  • From: Alvaro Herrera
• Re: Firing an event trigger for ADD COLUMN?
  • From: Tanveer Munavar
• Firing an event trigger for ADD COLUMN?
  • From: Michel Pelletier
• Re: Upgrade Process Says "The database server was not shut down cleanly" but it was
  • From: Adrian Klaver
• Re: Upgrade Process Says "The database server was not shut down cleanly" but it was
  • From: TalGloz
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Tom Lane
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Adrian Klaver
• Re: Hash partitioning, what function is used to compute the hash?
  • From: Alvaro Herrera
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Tory M Blue
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Tory M Blue
• Re: Is there a significant difference in Memory settings between 9.5 and 12
  • From: Tom Lane
• Is there a significant difference in Memory settings between 9.5 and 12
  • From: Tory M Blue
• Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
  • From: Matthias Apitz
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: Peter Devoy
• Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
  • From: Tom Lane
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: Paul Jungwirth
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: David G. Johnston
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: Adrian Klaver
• Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
  • From: Matthias Apitz
• Re: Enforcing uniqueness on [real estate/postal] addresses
  • From: Philip Semanchuk
• Enforcing uniqueness on [real estate/postal] addresses
  • From: Peter Devoy
• Re: Hash partitioning, what function is used to compute the hash?
  • From: Laurenz Albe
• Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
  • From: Matthias Apitz
• Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
  • From: Tom Lane
• Re: Hash partitioning, what function is used to compute the hash?
  • From: Michael Lewis
• Hash partitioning, what function is used to compute the hash?
  • From: Dennis Ryan
• Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
  • From: Matthias Apitz
• SV: what to log in csvlogs
  • From: Niels Jespersen
• Re: How to restore database to previous state
  • From: David G. Johnston
• RE: How to restore database to previous state
  • From: Ahmed, Nawaz (Fuji Xerox Australia)
• How to restore database to previous state
  • From: Andrus
• Re: Best way to use trigger to email a report ?
  • From: Rory Campbell-Lange
• Re: what to log in csvlogs
  • From: Adrian Klaver
• what to log in csvlogs
  • From: Mary Johnson
• Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
  • From: Tom Lane
• Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
  • From: Matthias Apitz
• PostgreSQL-12 replication failover, pg_rewind fails
  • From: Mariya Rampurawala
• Re: Best way to use trigger to email a report ?
  • From: AC Gomez
• Re: Best way to use trigger to email a report ?
  • From: Tim Clarke
• Re: pg_basebackup cannot compress to STDOUNT
  • From: Support
• Re: import .sql file into PostgreSQL database
  • From: Michael Paquier
• Re: pg_basebackup cannot compress to STDOUNT
  • From: Paul Förster
• Re: Best way to use trigger to email a report ?
  • From: Tim Cross
• Re: Best way to use trigger to email a report ?
  • From: Magnus Hagander
• Re: Thoughts on how to avoid a massive integer update.
  • From: Rob Sargent
• Re: Thoughts on how to avoid a massive integer update.
  • From: Fehrle, Brian
• Re: pg_basebackup cannot compress to STDOUNT
  • From: Adrian Klaver
• Re: AutoVacuum and growing transaction XID's
  • From: Michael Lewis
• Re: Thoughts on how to avoid a massive integer update.
  • From: Rob Sargent
• Re: Thoughts on how to avoid a massive integer update.
  • From: David G. Johnston
• Reuse an existing slot with a new initdb
  • From: Support
• Re: Thoughts on how to avoid a massive integer update.
  • From: Rob Sargent
• Re: Thoughts on how to avoid a massive integer update.
  • From: David G. Johnston
• Re: pg_basebackup cannot compress to STDOUNT
  • From: Support
• Re: Thoughts on how to avoid a massive integer update.
  • From: Rob Sargent
• Re: Thoughts on how to avoid a massive integer update.
  • From: David G. Johnston
• Re: pg_basebackup cannot compress to STDOUNT
  • From: Adrian Klaver
• Re: Memory footprint diff between 9.5 and 12
  • From: Tory M Blue
• Re: Thoughts on how to avoid a massive integer update.
  • From: Rob Sargent
• Re: Thoughts on how to avoid a massive integer update.
  • From: Fehrle, Brian
• Re: Thoughts on how to avoid a massive integer update.
  • From: Fehrle, Brian
• Re: Odd postgres12 upgrade is changing or munging a password?
  • From: Adrian Klaver
• Re: pg_basebackup cannot compress to STDOUNT
  • From: Support
• Re: Odd postgres12 upgrade is changing or munging a password?
  • From: Adrian Klaver
• Re: pg_restore V12 fails consistently against piped pg_dumps
  • From: Mohamed Wael Khobalatte
• Re: pg_basebackup cannot compress to STDOUNT
  • From: Adrian Klaver
• Re: Odd postgres12 upgrade is changing or munging a password?
  • From: Adrian Klaver
• pg_basebackup cannot compress to STDOUNT
  • From: Support
• Re: Odd postgres12 upgrade is changing or munging a password?
  • From: Adrian Klaver
• Re: Odd postgres12 upgrade is changing or munging a password?
  • From: Tory M Blue
• Re: Odd postgres12 upgrade is changing or munging a password?
  • From: Tory M Blue
• Re: Best way to use trigger to email a report ?
  • From: David Gauthier
• Re: Best way to use trigger to email a report ?
  • From: David G. Johnston
• Re: Thoughts on how to avoid a massive integer update.
  • From: David G. Johnston
• Re: Best way to use trigger to email a report ?
  • From: David G. Johnston
• Re: Best way to use trigger to email a report ?
  • From: Christophe Pettus
• Re: Best way to use trigger to email a report ?
  • From: Alan Hodgson
• Re: Thoughts on how to avoid a massive integer update.
  • From: Rob Sargent
• Re: Thoughts on how to avoid a massive integer update.
  • From: Fehrle, Brian
• Best way to use trigger to email a report ?
  • From: David Gauthier
• Re: pg_restore V12 fails consistently against piped pg_dumps
  • From: Adrian Klaver
• Re: pg_temp schema created while using DB Link
  • From: Adrian Klaver
• Re: pg_temp schema created while using DB Link
  • From: Thomas Kellerer
• Re: pg_temp schema created while using DB Link
  • From: Jill Jade
• Re: import .sql file into PostgreSQL database
  • From: Gaurav
• Re: pg_restore V12 fails consistently against piped pg_dumps
  • From: Laurenz Albe
• Re: Odd postgres12 upgrade is changing or munging a password?
  • From: Laurenz Albe
• Re: Memory footprint diff between 9.5 and 12
  • From: Laurenz Albe
• Re: pg_temp schema created while using DB Link
  • From: Laurenz Albe
• Re: AutoVacuum and growing transaction XID's
  • From: github kran
• pg_temp schema created while using DB Link
  • From: Jill Jade
• Re: AutoVacuum and growing transaction XID's
  • From: github kran
• Question correct Way to switch Slave to master
  • From: Hauke Homburg
• Re: AutoVacuum and growing transaction XID's
  • From: David Rowley
• Re: AutoVacuum and growing transaction XID's
  • From: David Rowley
• Re: AutoVacuum and growing transaction XID's
  • From: github kran
• Re: walreceiver termination
  • From: Kyotaro Horiguchi
• Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: David Rowley
• Re: Memory footprint diff between 9.5 and 12
  • From: Alan Hodgson
• Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: David G. Johnston
• Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: Tom Lane
• Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: David G. Johnston
• Re: AutoVacuum and growing transaction XID's
  • From: github kran
• Memory footprint diff between 9.5 and 12
  • From: Tory M Blue
• Re: pg_dump negation regex
  • From: Eudald Valcàrcel Lacasa
• Re: Odd postgres12 upgrade is changing or munging a password?
  • From: Adrian Klaver
• Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: Virendra Kumar
• Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: Adrian Klaver
• Re: Odd postgres12 upgrade is changing or munging a password?
  • From: Tory M Blue
• Re: pg_dump negation regex
  • From: Rob Sargent
• Re: Odd postgres12 upgrade is changing or munging a password?
  • From: Adrian Klaver
• Re: pg_dump negation regex
  • From: Eudald Valcàrcel Lacasa
• Odd postgres12 upgrade is changing or munging a password?
  • From: Tory M Blue
• Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: Amarendra Konda
• Re: AutoVacuum and growing transaction XID's
  • From: Michael Lewis
• AutoVacuum and growing transaction XID's
  • From: github kran
• Re: increase of xact_commit vs txid_current
  • From: Julien Rouhaud
• Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: Amarendra Konda
• Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: Amarendra Konda
• Re: pg_dump negation regex
  • From: Adrian Klaver
• Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: Amarendra Konda
• Re: Lock Postgres account after X number of failed logins?
  • From: Christian Ramseyer
• increase of xact_commit vs txid_current
  • From: reg_pg_stefanz
• pg_dump negation regex
  • From: Eudald Valcàrcel Lacasa
• Re: Abnormal Growth of Index Size - Index Size 3x large than table size.
  • From: Adrian Klaver
• Re: wal_sender_timeout default
  • From: Adrian Klaver
• Re: Abnormal Growth of Index Size - Index Size 3x large than table size.
  • From: Michael Lewis
• Re: wal_sender_timeout default
  • From: David G. Johnston
• Re: wal_sender_timeout default
  • From: Adrian Klaver
• Re: wal_sender_timeout default
  • From: Michael Lewis
• Re: Postgres 11.6-2 to 11.7 worth the upgrade?
  • From: David G. Johnston
• Re: Postgres 11.6-2 to 11.7 worth the upgrade?
  • From: Michael Lewis
• Postgres 11.6-2 to 11.7 worth the upgrade?
  • From: Jasen Lentz
• wal_sender_timeout default
  • From: Jasen Lentz
• Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: David G. Johnston
• Re: New Role drop with Grant/Revokes stop working after subsequent runs
  • From: Stephen Frost
• Re: Lock Postgres account after X number of failed logins?
  • From: Stephen Frost
• Re: pg_restore V12 fails consistently against piped pg_dumps
  • From: Mohamed Wael Khobalatte
• RE: Abnormal Growth of Index Size - Index Size 3x large than table size.
  • From: Ashish Chugh
• Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: Adrian Klaver
• RE: pg_basebackup inconsistent performance
  • From: Jasen Lentz
• Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
  • From: Amarendra Konda
• Could not launch new process for connection: Could not allocate memory
  • From: Lisandro Rostagno
• Re: pg_restore V12 fails consistently against piped pg_dumps
  • From: Tom Lane
• pg_restore V12 fails consistently against piped pg_dumps
  • From: Mohamed Wael Khobalatte
• Re: New Role drop with Grant/Revokes stop working after subsequent runs
  • From: David G. Johnston
• New Role drop with Grant/Revokes stop working after subsequent runs
  • From: AC Gomez
• Re: Lock Postgres account after X number of failed logins?
  • From: Geoff Winkless
• previous replication slot and new initdb
  • From: Support
• Re: White space affecting parsing of range values
  • From: Thom Brown
• Re: White space affecting parsing of range values
  • From: Thom Brown
• Re: White space affecting parsing of range values
  • From: Tom Lane
• Re: White space affecting parsing of range values
  • From: Adrian Klaver
• Re: pg_basebackup inconsistent performance
  • From: Stephen Frost
• Re: White space affecting parsing of range values
  • From: Thom Brown
• Re: White space affecting parsing of range values
  • From: Adrian Klaver
• RE: pg_basebackup inconsistent performance
  • From: Jasen Lentz
• White space affecting parsing of range values
  • From: Thom Brown
• Re: Lock Postgres account after X number of failed logins?
  • From: Stephen Frost
• Re: Abnormal Growth of Index Size - Index Size 3x large than table size.
  • From: Ravi Krishna
• Re: Lock Postgres account after X number of failed logins?
  • From: Magnus Hagander
• Re: Lock Postgres account after X number of failed logins?
  • From: Peter J. Holzer
• Re: Abnormal Growth of Index Size - Index Size 3x large than table size.
  • From: Ravi Krishna
• Re: pg_basebackup inconsistent performance
  • From: Adrian Klaver
• Re: pg_basebackup inconsistent performance
  • From: Adrian Klaver
• RE: Abnormal Growth of Index Size - Index Size 3x large than table size.
  • From: Ram Pratap Maurya
• Re: EXTERNAL: Re: Lock Postgres account after X number of failed logins?
  • From: Stephen Frost
• RE: EXTERNAL: Re: Lock Postgres account after X number of failed logins?
  • From: Wolff, Ken L
• Re: Abnormal Growth of Index Size - Index Size 3x large than table size.
  • From: Michael Lewis
• Re: Encoding conversion: Use replacement character instead of failing query with "ERROR: character with byte sequence 0xd0 0xad in encoding "UTF8" has no equivalent in encoding LATIN1" ?
  • From: Christian Ramseyer
• Re: Lock Postgres account after X number of failed logins?
  • From: Stephen Frost
• pg_basebackup inconsistent performance
  • From: Jasen Lentz
• Re: Abnormal Growth of Index Size - Index Size 3x large than table size.
  • From: Christian Ramseyer
• Re: Lock Postgres account after X number of failed logins?
  • From: Tim Cross
• Re: Lock Postgres account after X number of failed logins?
  • From: Guillaume Lelarge
• Re: Abnormal Growth of Index Size - Index Size 3x large than table size.
  • From: Ravi Krishna
• Abnormal Growth of Index Size - Index Size 3x large than table size.
  • From: Ram Pratap Maurya
• Re: Lock Postgres account after X number of failed logins?
  • From: Paul Förster
• Re: Lock Postgres account after X number of failed logins?
  • From: Geoff Winkless
• Re: Lock Postgres account after X number of failed logins?
  • From: Christian Ramseyer
• Re: Wrong PostgreSQL Plan
  • From: Virendra Kumar
• Re: Temporary table has become problematically persistent
  • From: Ricky Ramirez
• Re: Wrong PostgreSQL Plan
  • From: David G. Johnston
• Wrong PostgreSQL Plan
  • From: Virendra Kumar
• Re: Encoding conversion: Use replacement character instead of failing query with "ERROR: character with byte sequence 0xd0 0xad in encoding "UTF8" has no equivalent in encoding LATIN1" ?
  • From: Tom Lane
• Re: Lock Postgres account after X number of failed logins?
  • From: Tim Cross
• Encoding conversion: Use replacement character instead of failing query with "ERROR: character with byte sequence 0xd0 0xad in encoding "UTF8" has no equivalent in encoding LATIN1" ?
  • From: Christian Ramseyer
• Re: Lock Postgres account after X number of failed logins?
  • From: Wolff, Ken L
• Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
  • From: Matthias Apitz
• Re: Lock Postgres account after X number of failed logins?
  • From: Stephen Frost
• Re: RETURNING to_jsonb(...)
  • From: Adrian Klaver
• Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
  • From: Tom Lane
• RETURNING to_jsonb(...)
  • From: Miles Elam
• Re: Thoughts on how to avoid a massive integer update.
  • From: Peter J. Holzer
• Re: Lock Postgres account after X number of failed logins?
  • From: Tom Lane
• Re: 12.2: Howto check memory-leak in worker?
  • From: Peter
• Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
  • From: Matthias Apitz