Postgresql General Discussion

• Thread Index

• Re: Transaction and SQL errors
  • From: David G. Johnston
• Re: Transaction and SQL errors
  • From: J. Roeleveld
• Re: Select .... where id not in (....) returns 0 incorrectly
  • From: J. Roeleveld
• Re: Select .... where id not in (....) returns 0 incorrectly
  • From: Jeremy Smith
• Re: Select .... where id not in (....) returns 0 incorrectly
  • From: Ravi Krishna
• Re: Transaction and SQL errors
  • From: Sebastien Flaesch
• Re: Transaction and SQL errors
  • From: Sebastien Flaesch
• Select .... where id not in (....) returns 0 incorrectly
  • From: J. Roeleveld
• Re: Transaction and SQL errors
  • From: David Rowley
• Re: Transaction and SQL errors
  • From: Karsten Hilbert
• Transaction and SQL errors
  • From: Sebastien Flaesch
• gist segmentation fault
  • From: Arup Nanda
• Re: PostgreSQL JSON
  • From: David G. Johnston
• PostgreSQL JSON
  • From: Dave Ekhaus
• Re: weird issue with occasional stuck queries
  • From: overland
• Re: weird issue with occasional stuck queries
  • From: Adam Scott
• Re: weird issue with occasional stuck queries
  • From: spiral
• Re: Re: How long does iteration over 4-5 million rows usually take?
  • From: Benedict Holland
• Re: Re: How long does iteration over 4-5 million rows usually take?
  • From: Shaozhong SHI
• Aw: Re: How long does iteration over 4-5 million rows usually take?
  • From: Karsten Hilbert
• Re: How long does iteration over 4-5 million rows usually take?
  • From: Rob Sargent
• Re: How long does iteration over 4-5 million rows usually take?
  • From: Ron
• Re: How long does iteration over 4-5 million rows usually take?
  • From: Adrian Klaver
• How long does iteration over 4-5 million rows usually take?
  • From: Shaozhong SHI
• Re: weird issue with occasional stuck queries
  • From: Adam Scott
• Re: Does PGDG apt repository support ARM64?
  • From: Adrian Klaver
• LISTEN - ERROR: could not access status of transaction 3021015672
  • From: Aleš Zelený
• Re: Does PGDG apt repository support ARM64?
  • From: Magnus Hagander
• Re: Does PGDG apt repository support ARM64?
  • From: Daniele Varrazzo
• Re: Does PGDG apt repository support ARM64?
  • From: Magnus Hagander
• Re: Does PGDG apt repository support ARM64?
  • From: Daniele Varrazzo
• Re: Does PGDG apt repository support ARM64?
  • From: Magnus Hagander
• weird issue with occasional stuck queries
  • From: spiral
• PostgreSQL on focal and llvm version
  • From: Christoph Berg
• Re: Locking a table read-only temporarilty
  • From: Laurenz Albe
• Re: Does PGDG apt repository support ARM64?
  • From: Daniele Varrazzo
• Re: Does PGDG apt repository support ARM64?
  • From: Daniele Varrazzo
• Re: Does PGDG apt repository support ARM64?
  • From: Adrian Klaver
• Does PGDG apt repository support ARM64?
  • From: Daniele Varrazzo
• Locking a table read-only temporarilty
  • From: Digimer
• Re: PG12: Any drawback of increasing wal_keep_segments
  • From: Stephen Frost
• Re: PG12: Any drawback of increasing wal_keep_segments
  • From: Marc
• Re: Reg: User creation script/List of privileges
  • From: Tomas Pospisek
• Reg: User creation script/List of privileges
  • From: Sai Ch
• Re: psql -f and PAGER
  • From: Peter J. Holzer
• Re: psql -f and PAGER
  • From: David G. Johnston
• psql -f and PAGER
  • From: Paul Jungwirth
• Re: Why is my function inlined only when STABLE?
  • From: Philip Semanchuk
• Re: Why is my function inlined only when STABLE?
  • From: Tom Lane
• Why is my function inlined only when STABLE?
  • From: Philip Semanchuk
• Re: PG12: Any drawback of increasing wal_keep_segments
  • From: Stephen Frost
• Re: Indexes in JSONB
  • From: Saurav Sarkar
• Re: Indexes in JSONB
  • From: Michael Lewis
• Re: Indexes in JSONB
  • From: Magnus Hagander
• Indexes in JSONB
  • From: Saurav Sarkar
• Re: Performance issues on FK Triggers after replacing a primary column
  • From: Adrian Klaver
• Re: Performance issues on FK Triggers after replacing a primary column
  • From: Per Kaminsky
• Re: Leading comments and client applications
  • From: Philip Semanchuk
• Re: Performance issues on FK Triggers after replacing a primary column
  • From: Adrian Klaver
• Re: Performance issues on FK Triggers after replacing a primary column
  • From: Adrian Klaver
• Re: Performance issues on FK Triggers after replacing a primary column
  • From: Per Kaminsky
• Re: Performance issues on FK Triggers after replacing a primary column
  • From: Adrian Klaver
• Re: Performance issues on FK Triggers after replacing a primary column
  • From: Per Kaminsky
• Re: Performance issues on FK Triggers after replacing a primary column
  • From: Adrian Klaver
• Re: Will using subtransactions will come back to bite me?
  • From: Laurenz Albe
• Re: Performance issues on FK Triggers after replacing a primary column
  • From: Tom Lane
• Re: Leading comments and client applications
  • From: Philippe Doussot
• Will using subtransactions will come back to bite me?
  • From: Kannan Goundan
• Re: support for DIN SPEC 91379 encoding
  • From: Alvaro Herrera
• Re: Performance issues on FK Triggers after replacing a primary column
  • From: Per Kaminsky
• Re: Performance issues on FK Triggers after replacing a primary column
  • From: Per Kaminsky
• Re: support for DIN SPEC 91379 encoding
  • From: Peter J. Holzer
• Re: Performance issues on FK Triggers after replacing a primary column
  • From: Adrian Klaver
• Performance issues on FK Triggers after replacing a primary column
  • From: Per Kaminsky
• Re: support for DIN SPEC 91379 encoding
  • From: Bzm@g
• Re: support for DIN SPEC 91379 encoding
  • From: Tom Lane
• Re: support for DIN SPEC 91379 encoding
  • From: Alvaro Herrera
• Re: support for DIN SPEC 91379 encoding
  • From: Ralf Schuchardt
• support for DIN SPEC 91379 encoding
  • From: Marco Lechner
• Re: dynamically generate path to output file
  • From: Osvaldo Kussama
• In what situation, a line feature could not be visible in PgAdmin?
  • From: Shaozhong SHI
• dynamically generate path to output file
  • From: robert@xxxxxxxxxx
• Re: Leading comments and client applications
  • From: Laurenz Albe
• Re: Leading comments and client applications
  • From: Rob Sargent
• Re: Leading comments and client applications
  • From: Tom Lane
• Re: Leading comments and client applications
  • From: Philip Semanchuk
• Re: Leading comments and client applications
  • From: Peter J. Holzer
• Re: Leading comments and client applications
  • From: Rob Sargent
• Re: Leading comments and client applications
  • From: Tom Lane
• Re: Leading comments and client applications
  • From: David G. Johnston
• Leading comments and client applications
  • From: Philip Semanchuk
• Re: Get primary key of a table through SPI
  • From: Tom Lane
• Get primary key of a table through SPI
  • From: Oskar Stenberg
• Re: PG12: Any drawback of increasing wal_keep_segments
  • From: Alvaro Herrera
• PG12: Any drawback of increasing wal_keep_segments
  • From: Shukla, Pranjal
• Re: Unexpected zero results
  • From: Tom Lane
• Re: Unexpected zero results
  • From: David G. Johnston
• Re: Unexpected zero results
  • From: Viliam Ďurina
• Re: Unexpected zero results
  • From: Thomas Kellerer
• Unexpected zero results
  • From: Viliam Ďurina
• Re: Open SSL Version Query
  • From: Laura Smith
• Open SSL Version Query
  • From: Sahaj Diwan
• Re: Can you install/run postgresql on a FIPS enabled host?
  • From: Michael Paquier
• Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause
  • From: David Rowley
• Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause
  • From: PALAYRET Jacques
• Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause
  • From: David G. Johnston
• Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause
  • From: PALAYRET Jacques
• Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause
  • From: David G. Johnston
• Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause
  • From: Guillaume Lelarge
• Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause
  • From: Torsten Förtsch
• PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause
  • From: PALAYRET Jacques
• RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host?
  • From: McDermott, Becky
• Re: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host?
  • From: Rob Sargent
• RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host?
  • From: McDermott, Becky
• Re: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host?
  • From: Tom Lane
• Re: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host?
  • From: Rob Sargent
• RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host?
  • From: McDermott, Becky
• RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host?
  • From: McDermott, Becky
• RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host?
  • From: McDermott, Becky
• Re: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host?
  • From: Adrian Klaver
• RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host?
  • From: McDermott, Becky
• Re: Can you install/run postgresql on a FIPS enabled host?
  • From: Tom Lane
• Re: Can you install/run postgresql on a FIPS enabled host?
  • From: Adrian Klaver
• Can you install/run postgresql on a FIPS enabled host?
  • From: McDermott, Becky
• Re: How to explicitly lock and unlock tables in pgsql?
  • From: Laurenz Albe
• Re: How to explicitly lock and unlock tables in pgsql?
  • From: Merlin Moncure
• Re: PSQL bug?
  • From: Kyotaro Horiguchi
• Re[5]: LISTEN/NOTIFY ultra slow speed
  • From: Арсен Арутюнян
• Re: Query on WAL Optimization and Streaming Replication
  • From: Shukla, Pranjal
• Re: Query on WAL Optimization and Streaming Replication
  • From: Shukla, Pranjal
• Re: Query on WAL Optimization and Streaming Replication
  • From: Laurenz Albe
• Re: Query on WAL Optimization and Streaming Replication
  • From: Laurenz Albe
• Query on WAL Optimization and Streaming Replication
  • From: Shukla, Pranjal
• High Postgres postmaster CPU when My Background Worker is loaded.
  • From: GoLang Developere
• Re: PSQL bug?
  • From: Josef Šimánek
• Re: PSQL bug?
  • From: Dominique Devienne
• Re: PSQL bug?
  • From: Pavel Stehule
• PSQL bug?
  • From: Dominique Devienne
• Re: How to explicitly lock and unlock tables in pgsql?
  • From: Laurenz Albe
• Re: How to explicitly lock and unlock tables in pgsql?
  • From: Fabrízio de Royes Mello
• How to explicitly lock and unlock tables in pgsql?
  • From: Shaozhong SHI
• Re: Apparently table locks are the key issue to see red flags
  • From: Adrian Klaver
• Re: Apparently table locks are the key issue to see red flags
  • From: Ron
• Apparently table locks are the key issue to see red flags
  • From: Shaozhong SHI
• Re[4]: LISTEN/NOTIFY ultra slow speed
  • From: Арсен Арутюнян
• Re: [External]Re: Postgres Crash Issue
  • From: Adrian Klaver
• RE: [External]Re: Postgres Crash Issue
  • From: Menon, Deepak (Deepak)
• RE: [External]Re: Postgres Crash Issue
  • From: Menon, Deepak (Deepak)
• Re: Corrupt Index
  • From: Tom Lane
• Corrupt Index
  • From: Jorel Casal
• Re: Restoring using PG_DUMP in PG12 results in
  • From: Adrian Klaver
• Re: Re[2]: LISTEN/NOTIFY ultra slow speed
  • From: Tom Lane
• Re: [External]Re: Postgres Crash Issue
  • From: Tom Lane
• Re: [External]Re: Postgres Crash Issue
  • From: hubert depesz lubaczewski
• Re: [External]Re: Postgres Crash Issue
  • From: hubert depesz lubaczewski
• Re: Postgres Crash Issue
  • From: hubert depesz lubaczewski
• Re[2]: LISTEN/NOTIFY ultra slow speed
  • From: Арсен Арутюнян
• Re: LISTEN/NOTIFY ultra slow speed
  • From: Арсен Арутюнян
• Postgres Crash Issue
  • From: Sankar, Uma (Uma)
• Re: Restoring using PG_DUMP in PG12 results in
  • From: Shukla, Pranjal
• Re: Indexes that would span partitions.
  • From: Tim Uckun
• Re: Indexes that would span partitions.
  • From: Michael Lewis
• Re: foreign key on delete cascade order?
  • From: George Woodring
• Re: LISTEN/NOTIFY ultra slow speed
  • From: Tom Lane
• Re: Restoring using PG_DUMP in PG12 results in
  • From: Adrian Klaver
• Restoring using PG_DUMP in PG12 results in
  • From: Shukla, Pranjal
• LISTEN/NOTIFY ultra slow speed
  • From: Арсен Арутюнян
• Indexes that would span partitions.
  • From: Tim Uckun
• Re: delete query using CTE
  • From: benj . dev
• Re: delete query using CTE
  • From: Roger Bos
• Re: delete query using CTE
  • From: David G. Johnston
• Re: delete query using CTE
  • From: Michael Lewis
• delete query using CTE
  • From: Roger Bos
• Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines
  • From: Francisco Olarte
• Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines
  • From: Francisco Olarte
• Re: Am I in the same transaction block in complex PLPGSQL?
  • From: David G. Johnston
• Re: foreign key on delete cascade order?
  • From: Michael Lewis
• Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines
  • From: Dominique Devienne
• Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines
  • From: Daniel Verite
• Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines
  • From: Dominique Devienne
• Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines
  • From: Daniel Verite
• Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines
  • From: David G. Johnston
• COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines
  • From: Dominique Devienne
• Re: Am I in the same transaction block in complex PLPGSQL?
  • From: Durumdara
• Re: Am I in the same transaction block in complex PLPGSQL?
  • From: Tom Lane
• Re: foreign key on delete cascade order?
  • From: George Woodring
• Re: Postgres query
  • From: hubert depesz lubaczewski
• Postgres query
  • From: Ian Dauncey
• Am I in the same transaction block in complex PLPGSQL?
  • From: Durumdara
• Re: foreign key on delete cascade order?
  • From: Tom Lane
• Re: foreign key on delete cascade order?
  • From: George Woodring
• [pgpool] invalid read kind
  • From: Peter Juhasz
• Re: foreign key on delete cascade order?
  • From: Tom Lane
• foreign key on delete cascade order?
  • From: George Woodring
• Re: PQresultMemorySize of ResultSet larger than expected
  • From: Tom Lane
• Re: primary_conninfo and restore_command ?
  • From: Bharath Rupireddy
• PQresultMemorySize of ResultSet larger than expected
  • From: Dominique Devienne
• Re: primary_conninfo and restore_command ?
  • From: Julien Rouhaud
• primary_conninfo and restore_command ?
  • From: Luca Ferrari
• Re: Simple Query Doesn't Even with Data
  • From: Ken Tanzer
• Re: Simple Query Doesn't Even with Data
  • From: Julien Rouhaud
• Simple Query Doesn't Even with Data
  • From: Scott Macri
• Could not read certificate file from while upgrading to PostgreSQLClient 12.9
  • From: M Tarkeshwar Rao
• Postgres migration from 9.2 to 14
  • From: Lucas
• Re: Serializable read only deferrable- implications
  • From: David G. Johnston
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: hubert depesz lubaczewski
• Re: Serializable read only deferrable- implications
  • From: Adrian Klaver
• Re: Serializable read only deferrable- implications
  • From: Michael Lewis
• Re: Serializable read only deferrable- implications
  • From: Adrian Klaver
• Re: Serializable read only deferrable- implications
  • From: Tom Lane
• Re: Serializable read only deferrable- implications
  • From: Michael Lewis
• Re: Serializable read only deferrable- implications
  • From: Laurenz Albe
• Re: A simple question: Why 'pg_ctl: command not found...' ?
  • From: Adrian Klaver
• Serializable read only deferrable- implications
  • From: Michael Lewis
• Re: A simple question: Why 'pg_ctl: command not found...' ?
  • From: Laurenz Albe
• A simple question: Why 'pg_ctl: command not found...' ?
  • From: BeginnerC
• Re: ERROR: extra data after last expected column
  • From: Ron
• Re: ERROR: extra data after last expected column
  • From: Rob Sargent
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: hubert depesz lubaczewski
• Re: Getting more detail in plpython error messages
  • From: Jeff Ross
• Re: Getting more detail in plpython error messages
  • From: Tom Lane
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: Andres Freund
• Getting more detail in plpython error messages
  • From: Jeff Ross
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: Tom Lane
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: hubert depesz lubaczewski
• Re: FDW to postGIS Database
  • From: Susan Hurst
• Re: FDW to postGIS Database
  • From: Brent Wood
• Re: Do you know a json_populate_record alternative method to create a ROW with a named field notation?
  • From: Tom Lane
• Do you know a json_populate_record alternative method to create a ROW with a named field notation?
  • From: Stéphane Klein
• FDW to postGIS Database
  • From: Susan Hurst
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: Tom Lane
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: hubert depesz lubaczewski
• Re: Couldn't cast to record[]
  • From: Tom Lane
• REG:DR DRILL
  • From: obi reddy
• Re: Couldn't cast to record[]
  • From: Suresh Kumar R
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: Tom Lane
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: Mladen Gogala
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: Tom Lane
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: hubert depesz lubaczewski
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: Tom Lane
• Re: Couldn't cast to record[]
  • From: Merlin Moncure
• Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
  • From: Bruce Momjian
• Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
  • From: Atri Sharma
• Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
  • From: Bruce Momjian
• Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
  • From: Bruce Momjian
• Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
  • From: Tom Lane
• Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
  • From: Bayer, Samuel
• Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
  • From: Tom Lane
• Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
  • From: Bruce Momjian
• Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
  • From: Bayer, Samuel
• Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
  • From: Atri Sharma
• Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres
  • From: Bayer, Samuel
• Re: Looking for tips on improving full-text search quality in Postgres
  • From: Bruce Momjian
• Looking for tips on improving full-text search quality in Postgres
  • From: Bayer, Samuel
• Re: Postgres Wal Full
  • From: Andreas Kretschmer
• Re: Power loss test
  • From: Bruce Momjian
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: hubert depesz lubaczewski
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: hubert depesz lubaczewski
• Re: Couldn't cast to record[]
  • From: Tom Lane
• Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: hubert depesz lubaczewski
• Interesting fail when migrating Pg from Ubuntu Bionic to Focal
  • From: hubert depesz lubaczewski
• oid2name: Why table and not relation?
  • From: Daniel Westermann (DWE)
• Re: Couldn't cast to record[]
  • From: Pavel Stehule
• Couldn't cast to record[]
  • From: Suresh Kumar R
• Re: Postgres Wal Full
  • From: Bharath Rupireddy
• Ynt: Postgres Wal Full
  • From: pgdba pgdba
• Re: Postgres Wal Full
  • From: Kyotaro Horiguchi
• Postgres Wal Full
  • From: pgdba pgdba
• Power loss test
  • From: Levente Birta
• Re: PostgreSQL Upgrade with Replication managed via repmgr
  • From: Ian Lawrence Barwick
• PostgreSQL Upgrade with Replication managed via repmgr
  • From: DAN LU
• How to log to client (port native code to stored procedure)?
  • From: Durumdara
• Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database.
  • From: Sonai muthu raja M
• Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database.
  • From: Laurenz Albe
• Require details that can we set characters length of a password to a User account in PostgreSQL Database.
  • From: Sonai muthu raja M
• Re: \set \e and newline
  • From: Laurenz Albe
• Re: \set \e and newline
  • From: Wim Bertels
• Re: PG 14 Create Rule ERROR - RETURNING list has too few entries
  • From: Lucas
• Re: PG 14 Create Rule ERROR - RETURNING list has too few entries
  • From: Tom Lane
• Re: PG 14 Create Rule ERROR - RETURNING list has too few entries
  • From: Lucas
• PG 14 Create Rule ERROR - RETURNING list has too few entries
  • From: Lucas
• Re: 20220226-Clarification regarding delay time of PostgeSQL starting up
  • From: Mladen Gogala
• Re: 20220226-Clarification regarding delay time of PostgeSQL starting up
  • From: Mladen Gogala
• Re: 20220226-Clarification regarding delay time of PostgeSQL starting up
  • From: Julien Rouhaud
• Re: 20220226-Clarification regarding delay time of PostgeSQL starting up
  • From: David G. Johnston
• RE: 20220226-Clarification regarding delay time of PostgeSQL starting up
  • From: Techsupport
• Re: 20220226-Clarification regarding delay time of PostgeSQL starting up
  • From: Laurenz Albe
• Re: 20220226-Clarification regarding delay time of PostgeSQL starting up
  • From: Julien Rouhaud
• 20220226-Clarification regarding delay time of PostgeSQL starting up
  • From: Techsupport
• What IR model the PostgreSQL FTS implementation is based on?
  • From: Timo Myyrä
• Transactions starting with Cursor with Hold are not closing in database.
  • From: Kumar, Mukesh
• Re: alter table to multi partitions
  • From: Laurenz Albe
• Re: \set \e and newline
  • From: Laurenz Albe
• After upgrade pg12 -> pg14 import time increased
  • From: Hu Bert
• \set \e and newline
  • From: Wim Bertels
• Re: tsvector string representation and parsing
  • From: Tom Lane
• alter table to multi partitions
  • From: Catalin Maftei
• Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
  • From: Peter J. Holzer
• Re: tsvector string representation and parsing
  • From: Johannes Graën
• Re: tsvector string representation and parsing
  • From: Tom Lane
• tsvector string representation and parsing
  • From: Johannes Graën
• Plan regression from 12 to 13
  • From: Radu Radutiu
• Re: AWS vs GCP storage
  • From: Nikolay Samokhvalov
• Re: AWS vs GCP storage
  • From: Adrian Klaver
• AWS vs GCP storage
  • From: Torsten Förtsch
• Re: Full text search - wildcard and a stop word
  • From: Tom Lane
• Full text search - wildcard and a stop word
  • From: Allan Jardine
• Re: varchar::bytea fails when varchar contains backslash
  • From: Daniel Verite
• Re: Detecting schema changes via WAL logs
  • From: Tomas Pospisek
• Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
  • From: liam saffioti
• varchar::bytea fails when varchar contains backslash
  • From: Matthias Apitz
• Re: 20220221-Clarification regarding PostgeSQL DB backup
  • From: Daevor The Devoted
• RE: 20220221-Clarification regarding PostgeSQL DB backup
  • From: Techsupport
• Re: 20220221-Clarification regarding PostgeSQL DB backup
  • From: Ron
• Re: 20220221-Clarification regarding PostgeSQL DB backup
  • From: Daevor The Devoted
• 20220221-Clarification regarding PostgeSQL DB backup
  • From: Techsupport
• Re: Strange results when casting string to double
  • From: Tom Lane
• Re: Additional accessors via the Extension API ?
  • From: Tom Lane
• Re: Strange results when casting string to double
  • From: Carsten Klein
• Re: Additional accessors via the Extension API ?
  • From: Markur Sens
• Re: Additional accessors via the Extension API ?
  • From: Julien Rouhaud
• Re: Additional accessors via the Extension API ?
  • From: Markur Sens
• Re: Additional accessors via the Extension API ?
  • From: Julien Rouhaud
• Aw: Additional accessors via the Extension API ?
  • From: Karsten Hilbert
• Additional accessors via the Extension API ?
  • From: Markur Sens
• Re: Strange results when casting string to double
  • From: Tom Lane
• Re: Strange results when casting string to double
  • From: Carsten Klein
• Detecting schema changes via WAL logs
  • From: Cal Mitchell
• Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
  • From: Yoong S. Chow
• Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
  • From: Yoong S. Chow
• Re: Strange results when casting string to double
  • From: Merlin Moncure
• Re: Strange results when casting string to double
  • From: Tomas Pospisek
• Re: alter function/procedure depends on extension
  • From: David G. Johnston
• Re: alter function/procedure depends on extension
  • From: Bryn Llewellyn
• Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
  • From: Jeff Janes
• Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
  • From: Laurenz Albe
• Re: Strange results when casting string to double
  • From: Tom Lane
• Re: Strange results when casting string to double
  • From: Peter J. Holzer
• Re: Strange results when casting string to double
  • From: Tom Lane
• Re: Strange results when casting string to double
  • From: Carsten Klein
• Re: 2 phase commit with FDW
  • From: Pavel Stehule
• Re: Strange results when casting string to double
  • From: Tom Lane
• Re: UUID type question
  • From: Laura Smith
• Re: UUID type question
  • From: Dominique Devienne
• Re: UUID type question
  • From: Dominique Devienne
• UUID type question
  • From: Laura Smith
• Re: Strange results when casting string to double
  • From: Carsten Klein
• pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
  • From: Yoong S. Chow
• Re: 2 phase commit with FDW
  • From: Mladen Gogala
• Re: Max_connection
  • From: Daulat
• Re: Strange results when casting string to double
  • From: Peter Eisentraut
• Re: PostgreSQL's Max Identifier Length in Amazon RDS
  • From: Michael Lewis
• Re: PostgreSQL's Max Identifier Length in Amazon RDS
  • From: Michael Lewis
• PostgreSQL's Max Identifier Length in Amazon RDS
  • From: Atul Kumar
• Re: Question on Open PostgreSQL Monitoring
  • From: Julien Rouhaud
• Re: alter function/procedure depends on extension
  • From: David G. Johnston
• Re: alter function/procedure depends on extension
  • From: Tom Lane
• Re: alter function/procedure depends on extension
  • From: David G. Johnston
• Re: alter function/procedure depends on extension
  • From: David G. Johnston
• Re: alter function/procedure depends on extension
  • From: Tom Lane
• Re: alter function/procedure depends on extension
  • From: David G. Johnston
• Re: alter function/procedure depends on extension
  • From: Bryn Llewellyn
• Re: frequency of positive and negative numbers, sizes of numbers and frequency of alteration of polarity
  • From: Thomas Munro
• Re: frequency of positive and negative numbers, sizes of numbers and frequency of alteration of polarity
  • From: Shaozhong SHI
• Re: frequency of positive and negative numbers, sizes of numbers and frequency of alteration of polarity
  • From: Shaozhong SHI
• Re: frequency of positive and negative numbers, sizes of numbers and frequency of alteration of polarity
  • From: Thomas Munro
• Re: Give default privileges to another SuperUser ?
  • From: David G. Johnston
• Give default privileges to another SuperUser ?
  • From: celati Laurent
• Question on Open PostgreSQL Monitoring
  • From: Lu, Dan
• frequency of positive and negative numbers, sizes of numbers and frequency of alteration of polarity
  • From: Shaozhong SHI
• Re: alter function/procedure depends on extension
  • From: David G. Johnston
• Re: alter function/procedure depends on extension
  • From: David G. Johnston
• 2 phase commit with FDW
  • From: Mladen Gogala
• Re: alter function/procedure depends on extension
  • From: Alvaro Herrera
• Re: alter function/procedure depends on extension
  • From: Adrian Klaver
• alter function/procedure depends on extension
  • From: Bryn Llewellyn
• Re: Strange results when casting string to double
  • From: Carsten Klein
• pgbouncer: Warning xbuf_connect failed: no such or file directory
  • From: Vikas Sharma
• Re: Strange results when casting string to double
  • From: Peter J. Holzer
• Re: Strange results when casting string to double
  • From: Carsten Klein
• Re: Strange results when casting string to double
  • From: Thomas Kellerer
• Re: Strange results when casting string to double
  • From: Carsten Klein
• Re: Strange results when casting string to double
  • From: Gavan Schneider
• Re: Strange results when casting string to double
  • From: Carsten Klein
• Re: Strange results when casting string to double
  • From: David G. Johnston
• Re: Strange results when casting string to double
  • From: Carsten Klein
• Re: if not exists (SELECT 1... UNION SELECT 1...)
  • From: Laurenz Albe
• Re: How to disable read-only mode on a table? (superUser)
  • From: Adrian Klaver
• How to disable read-only mode on a table? (superUser)
  • From: celati Laurent
• Re: Strange results when casting string to double
  • From: Adrian Klaver
• Re: if not exists (SELECT 1... UNION SELECT 1...)
  • From: Alexander Farber
• Re: if not exists (SELECT 1... UNION SELECT 1...)
  • From: Alexander Farber
• Re: if not exists (SELECT 1... UNION SELECT 1...)
  • From: Ralf Schuchardt
• Re: if not exists (SELECT 1... UNION SELECT 1...)
  • From: Alexander Farber
• Re: if not exists (SELECT 1... UNION SELECT 1...)
  • From: Alexander Farber
• Strange results when casting string to double
  • From: Carsten Klein
• Re: Table/Parition Level Compression in Postgres
  • From: Jagmohan Kaintura
• Re: Table/Parition Level Compression in Postgres
  • From: Laurenz Albe
• Table/Parition Level Compression in Postgres
  • From: Jagmohan Kaintura
• Re: if not exists (SELECT 1... UNION SELECT 1...)
  • From: Laurenz Albe
• if not exists (SELECT 1... UNION SELECT 1...)
  • From: Alexander Farber
• Re: Is there a way to automatically scan a table and determine the format of data
  • From: Karsten Hilbert
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Bryn Llewellyn
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Alvaro Herrera
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Bruce Momjian
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Merlin Moncure
• Re: Moving the master to a new server
  • From: Glen Eustace
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: Tomas Vondra
• Re: Moving the master to a new server
  • From: Marc Millas
• Re: Operator % and its meaning and use
  • From: Laurenz Albe
• Aw: Operator % and its meaning and use
  • From: Karsten Hilbert
• Operator % and its meaning and use
  • From: Shaozhong SHI
• Re: Turn a json column into a table
  • From: Thomas Kellerer
• Turn a json column into a table
  • From: Shaozhong SHI
• Re: Rows From but with Subqueries (or a cleaner non-array-using alternative)?
  • From: Michael Lewis
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: Michael Lewis
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: A Shaposhnikov
• Rows From but with Subqueries (or a cleaner non-array-using alternative)?
  • From: David G. Johnston
• Re: Moving the master to a new server
  • From: Alan Hodgson
• Re: table not found on publisher
  • From: Tom Lane
• Does the postgres jdbc driver (rev 42.3) cache prepared statements
  • From: Rob Sargent
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Bruce Momjian
• Re: Moving the master to a new server
  • From: Glen Eustace
• Re: Moving the master to a new server
  • From: Alan Hodgson
• Moving the master to a new server
  • From: Glen Eustace
• npgsql versus dotConnect data provider
  • From: JORGE MALDONADO
• Re: pgAdmin
  • From: David G. Johnston
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Bryn Llewellyn
• Re: How to split normal and overtime hours
  • From: Andrus
• pgAdmin
  • From: Grzegorz Zając
• Re: How to split normal and overtime hours
  • From: Andrus
• Re: Invalid operation order while producing DB dump
  • From: Sergey Belyashov
• Re: Babelfish for PostgreSQL
  • From: Emanuel Calvo
• Re: table not found on publisher
  • From: Radoslav Nedyalkov
• Re: PostgreSQL extensions during switchover
  • From: Julien Rouhaud
• PostgreSQL extensions during switchover
  • From: Marian Pompura
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Dominique Devienne
• Re: FDW error on remote view
  • From: Tom Lane
• FDW error on remote view
  • From: Michael Mauger
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Mladen Gogala
• Re: How to split normal and overtime hours
  • From: Torsten Förtsch
• Re: How to split normal and overtime hours
  • From: Torsten Förtsch
• How to split normal and overtime hours
  • From: Andrus
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Pavel Stehule
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Guyren Howe
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Pavel Stehule
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Peter J. Holzer
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Peter J. Holzer
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Mladen Gogala
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Andreas 'ads' Scherbaum
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Peter J. Holzer
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Peter J. Holzer
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Adrian Klaver
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Peter J. Holzer
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Andreas 'ads' Scherbaum
• Babelfish for PostgreSQL
  • From: Mladen Gogala
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Peter J. Holzer
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Bryn Llewellyn
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Julien Rouhaud
• Re: Microsoft Report Builder
  • From: Дмитрий Иванов
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Adrian Klaver
• Re: Microsoft Report Builder
  • From: Mladen Gogala
• Microsoft Report Builder
  • From: Kim Foltz
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Bryn Llewellyn
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Andreas 'ads' Scherbaum
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Adrian Klaver
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Adrian Klaver
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Bryn Llewellyn
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: David G. Johnston
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: David G. Johnston
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Tom Lane
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Bryn Llewellyn
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: David G. Johnston
• Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Tom Lane
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Peter J. Holzer
• "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
  • From: Bryn Llewellyn
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Raymond Brinzer
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Rob Sargent
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Mladen Gogala
• table not found on publisher
  • From: Radoslav Nedyalkov
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Benedict Holland
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Mladen Gogala
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Imre Samu
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Daniel Verite
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Ron
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Guyren Howe
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Tom Lane
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Raymond Brinzer
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: David G. Johnston
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Guyren Howe
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Raymond Brinzer
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Guyren Howe
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Raymond Brinzer
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Ron
• Re: How to determine whether I'm running on a standby?
  • From: Ron
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Mladen Gogala
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: David G. Johnston
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Guyren Howe
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Benedict Holland
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Bruce Momjian
• Re: How to determine whether I'm running on a standby?
  • From: David G. Johnston
• How to determine whether I'm running on a standby?
  • From: Mladen Gogala
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Guyren Howe
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Merlin Moncure
• Re: [EXT] Re: Passing XML column in an array
  • From: Garfield Lewis
• Re: Passing XML column in an array
  • From: Tom Lane
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Peter J. Holzer
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Peter J. Holzer
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Peter J. Holzer
• Passing XML column in an array
  • From: Garfield Lewis
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Merlin Moncure
• Re: Network Card Not Listening at Startup
  • From: Ludwig Isaac Lim
• Invalid operation order while producing DB dump
  • From: Sergey Belyashov
• Re: Proposed German Translation of Code of Conduct Policy
  • From: Karsten Hilbert
• Re: Proposed German Translation of Code of Conduct Policy
  • From: Umair Shahid
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: Karsten Hilbert
• Re: DELETING then INSERTING record with same PK in the same TRANSACTION
  • From: Andrew Hardy
• Re: Undetected Deadlock
  • From: Simon Riggs
• Re: Can we go beyond the standard to make Postgres radically better?
  • From: David G. Johnston
• Can we go beyond the standard to make Postgres radically better?
  • From: Guyren Howe
• Re: Compile 14.1 in EL5.8
  • From: Thomas Munro
• Re: Compile 14.1 in EL5.8
  • From: Tom Lane
• Re: Compile 14.1 in EL5.8
  • From: Thomas Munro
• Re: Performance issue questions
  • From: Bruce Momjian
• Re: Undetected Deadlock
  • From: Tom Lane
• Re: Undetected Deadlock
  • From: Michael Harris
• Performance issue questions
  • From: Rama Krishnan
• Re: DELETING then INSERTING record with same PK in the same TRANSACTION
  • From: David G. Johnston
• Re: DELETING then INSERTING record with same PK in the same TRANSACTION
  • From: Thomas Kellerer
• Re: DELETING then INSERTING record with same PK in the same TRANSACTION
  • From: Bryn Llewellyn
• Re: DELETING then INSERTING record with same PK in the same TRANSACTION
  • From: David G. Johnston
• Re: DELETING then INSERTING record with same PK in the same TRANSACTION
  • From: Adrian Klaver
• Re: DELETING then INSERTING record with same PK in the same TRANSACTION
  • From: Andrew Hardy
• Re: DELETING then INSERTING record with same PK in the same TRANSACTION
  • From: Brent Wood
• Re: DELETING then INSERTING record with same PK in the same TRANSACTION
  • From: David G. Johnston
• Re: DELETING then INSERTING record with same PK in the same TRANSACTION
  • From: Adrian Klaver
• DELETING then INSERTING record with same PK in the same TRANSACTION
  • From: Andrew Hardy
• Re: Network Card Not Listening at Startup
  • From: Tom Lane
• Network Card Not Listening at Startup
  • From: Ludwig Isaac Lim
• Re: Why are data files getting modified?
  • From: Laurenz Albe
• Re: Why are data files getting modified?
  • From: Abhishek Bhola
• Re: Why are data files getting modified?
  • From: Laurenz Albe
• Re: Compile 14.1 in EL5.8
  • From: Tom Lane
• Re: Locks on FK Tables From Partitioning
  • From: Simon Riggs
• Compile 14.1 in EL5.8
  • From: Gabriela Serventi
• Why are data files getting modified?
  • From: Abhishek Bhola
• Re: Locks on FK Tables From Partitioning
  • From: Tom Lane
• Re: Question on tablefunc extension
  • From: Adrian Klaver
• Question on tablefunc extension
  • From: Lu, Dan
• Locks on FK Tables From Partitioning
  • From: Aaron Sipser
• Re: Undetected Deadlock
  • From: Tom Lane
• Re: Re. Backup of postgresql database
  • From: Ron
• Re: Re. Backup of postgresql database
  • From: sivapostgres@xxxxxxxxx
• Re: Re. Backup of postgresql database
  • From: sivapostgres@xxxxxxxxx
• Re: Re. Backup of postgresql database
  • From: Benedict Holland
• Re: Re. Backup of postgresql database
  • From: Ron
• Re. Backup of postgresql database
  • From: sivapostgres@xxxxxxxxx
• Re: Postgres Version Upgrade to 14.1 error
  • From: Adrian Klaver
• Re: Postgres Version Upgrade to 14.1 error
  • From: rob stan
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: Tomas Vondra
• Re: sort order for UTF-8 char column with Japanese UTF-8
  • From: Tom Lane
• Re: sort order for UTF-8 char column with Japanese UTF-8
  • From: Matthias Apitz
• Re: Postgres Version Upgrade to 14.1 error
  • From: Pavel Stehule
• Postgres Version Upgrade to 14.1 error
  • From: rob stan
• Re: Can Postgres beat Oracle for regexp_count?
  • From: Merlin Moncure
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: A Shaposhnikov
• Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
  • From: aditya desai
• Re: Increase fetch fize of oracl_fdw(ALTER SERVER)
  • From: David G. Johnston
• Fwd: Increase fetch fize of oracl_fdw(ALTER SERVER)
  • From: aditya desai
• Re: Undetected Deadlock
  • From: Michael Harris
• Re: Subscription stuck at initialize state
  • From: Abhishek Bhola
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: Michael Lewis
• Re: pg_cron for vacuum - dynamic table set
  • From: Ron
• Re: pg_cron for vacuum - dynamic table set
  • From: Michael Lewis
• Re: sort order for UTF-8 char column with Japanese UTF-8
  • From: Thomas Munro
• Re: pg_cron for vacuum - dynamic table set
  • From: David G. Johnston
• Re: pg_cron for vacuum - dynamic table set
  • From: Adrian Klaver
• pg_cron for vacuum - dynamic table set
  • From: saket bansal
• Re: Regular Expression For Duplicate Words
  • From: Shaozhong SHI
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: A Shaposhnikov
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: Vijaykumar Jain
• Re: Regular Expression For Duplicate Words
  • From: Peter J. Holzer
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: A Shaposhnikov
• Re: Using the indexing and sampling APIs to realize progressive features
  • From: Vijaykumar Jain
• Re: sort order for UTF-8 char column with Japanese UTF-8
  • From: Matthias Apitz
• Re: Subscription stuck at initialize state
  • From: Vijaykumar Jain
• Re: Undetected Deadlock
  • From: Tom Lane
• Re: Can Postgres beat Oracle for regexp_count?
  • From: Shaozhong SHI
• Using the indexing and sampling APIs to realize progressive features
  • From: hohenstein
• Re: Oracle to postgresql migration
  • From: Laurenz Albe
• Re: sort order for UTF-8 char column with Japanese UTF-8
  • From: Tom Lane
• Re: max_connections different between primary and standby: is it possible?
  • From: Tom Lane
• Oracle to postgresql migration
  • From: Rama Krishnan
• Re: max_connections different between primary and standby: is it possible?
  • From: Julien Rouhaud
• Re: Can Postgres beat Oracle for regexp_count?
  • From: David G. Johnston
• Re: max_connections different between primary and standby: is it possible?
  • From: Bharath Rupireddy
• Re: sort order for UTF-8 char column with Japanese UTF-8
  • From: Matthias Apitz
• sort order for UTF-8 char column with Japanese UTF-8
  • From: Matthias Apitz
• Re: max_connections different between primary and standby: is it possible?
  • From: Julien Rouhaud
• Re: Subscription stuck at initialize state
  • From: Abhishek Bhola
• Re: max_connections different between primary and standby: is it possible?
  • From: Vijaykumar Jain
• max_connections different between primary and standby: is it possible?
  • From: Luca Ferrari
• Re: Can Postgres beat Oracle for regexp_count?
  • From: Shaozhong SHI
• Re: Undetected Deadlock
  • From: Simon Riggs
• Re: Subscription stuck at initialize state
  • From: Vijaykumar Jain
• Re: Subscription stuck at initialize state
  • From: Abhishek Bhola
• Re: Subscription stuck at initialize state
  • From: Vijaykumar Jain
• Re: Undetected Deadlock
  • From: Michael Harris
• Re: Can Postgres beat Oracle for regexp_count?
  • From: Tom Lane
• Re: Can Postgres beat Oracle for regexp_count?
  • From: David G. Johnston
• Re: Can Postgres beat Oracle for regexp_count?
  • From: Shaozhong SHI
• Re: Subscription stuck at initialize state
  • From: Abhishek Bhola
• Re: Subscription stuck at initialize state
  • From: Abhishek Bhola
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: Tomas Vondra
• Re: Can Postgres beat Oracle for regexp_count?
  • From: Tom Lane
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: Imre Samu
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: Artyom Shaposhnikov
• Re: Can Postgres beat Oracle for regexp_count?
  • From: David G. Johnston
• Can Postgres beat Oracle for regexp_count?
  • From: Shaozhong SHI
• Re: increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: Michael Lewis
• increasing effective_cache_size slows down join queries by a factor of 4000x
  • From: Artyom Shaposhnikov
• Re: pg_basebackup with hostssl ?
  • From: Laura Smith
• Re: Regular Expression For Duplicate Words
  • From: Jian He
• Re: pg_basebackup with hostssl ?
  • From: Adrian Klaver
• Re: pg_basebackup with hostssl ?
  • From: Laura Smith
• Re: pg_basebackup with hostssl ?
  • From: David G. Johnston
• Re: pg_basebackup with hostssl ?
  • From: Adrian Klaver
• Re: pg_basebackup with hostssl ?
  • From: Laura Smith
• Re: pg_basebackup with hostssl ?
  • From: Laura Smith
• Re: pg_basebackup with hostssl ?
  • From: Adrian Klaver
• pg_basebackup with hostssl ?
  • From: Laura Smith
• Re: Regular Expression For Duplicate Words
  • From: David G. Johnston
• Regular Expression For Duplicate Words
  • From: Shaozhong SHI
• Re: Counting the number of repeated phrases in a column
  • From: Karsten Hilbert
• Re: Two academic questions
  • From: Дмитрий Иванов
• Re: Two academic questions
  • From: David G. Johnston
• Re: Two academic questions
  • From: Дмитрий Иванов
• Re: Two academic questions
  • From: David G. Johnston
• Re: Two academic questions
  • From: Дмитрий Иванов
• Re: Subscription stuck at initialize state
  • From: Abhishek Bhola
• Re: Two academic questions
  • From: David G. Johnston
• Two academic questions
  • From: Дмитрий Иванов
• Re: Subscription stuck at initialize state
  • From: Steve Baldwin
• Subscription stuck at initialize state
  • From: Abhishek Bhola
• Re: Counting the number of repeated phrases in a column
  • From: Shaozhong SHI
• Re: Counting the number of repeated phrases in a column
  • From: Shaozhong SHI
• Re: Extension has owner
  • From: Tom Lane
• Extension has owner
  • From: Färber, Franz-Josef (StMUK)
• Re: Undetected Deadlock
  • From: Michael Harris
• Re: what is the solution like oracle DB's datafile
  • From: Yudianto Prasetyo
• Re: pg_try_advisory_lock is waiting?
  • From: Merlin Moncure
• Re: what is the solution like oracle DB's datafile
  • From: Yudianto Prasetyo
• Can one call pg_total_relation_size over foreign data wrapper?
  • From: Ketan Popat
• Re: what is the solution like oracle DB's datafile
  • From: Laurenz Albe
• Re: what is the solution like oracle DB's datafile
  • From: Josef Šimánek
• Re: what is the solution like oracle DB's datafile
  • From: Yudianto Prasetyo
• Re: what is the solution like oracle DB's datafile
  • From: Yudianto Prasetyo
• Re: what is the solution like oracle DB's datafile
  • From: Mladen Gogala
• Re: what is the solution like oracle DB's datafile
  • From: Julien Rouhaud
• Re: what is the solution like oracle DB's datafile
  • From: Julien Rouhaud
• Re: what is the solution like oracle DB's datafile
  • From: Julien Rouhaud
• Re: what is the solution like oracle DB's datafile
  • From: Julien Rouhaud
• Regarding PGperffarm_server Setup
  • From: Sourav Prasad Das
• what is the solution like oracle DB's datafile
  • From: Yudianto Prasetyo
• Re: pg_try_advisory_lock is waiting?
  • From: Mladen Gogala
• Re: pg_try_advisory_lock is waiting?
  • From: Michael Lewis
• Re: pg_try_advisory_lock is waiting?
  • From: Mladen Gogala
• Re: pg_try_advisory_lock is waiting?
  • From: Tom Lane
• Re: pg_try_advisory_lock is waiting?
  • From: Michael Lewis
• pg_try_advisory_lock is waiting?
  • From: Mladen Gogala
• Will Barman support restore of single database?
  • From: Andreas Joseph Krogh
• Re: PostgreSQL Management and monitoring tool
  • From: Umair Shahid
• Re: Undetected Deadlock
  • From: Michael Harris
• Re: Counting the number of repeated phrases in a column
  • From: Merlin Moncure
• Re: could not open relation with OID
  • From: Ben Chobot
• Re: Counting the number of repeated phrases in a column
  • From: benj . dev
• Re: Counting the number of repeated phrases in a column
  • From: Merlin Moncure
• Re: Counting the number of repeated phrases in a column
  • From: Rob Sargent
• Re: Counting the number of repeated phrases in a column
  • From: Merlin Moncure
• Re: Broken logical replication
  • From: Игорь Выскорко
• Re: could not open relation with OID
  • From: Michael Paquier
• Re: PostgreSQL Management and monitoring tool
  • From: Mladen Gogala
• Re: PostgreSQL Management and monitoring tool
  • From: Lucas
• Re: PostgreSQL Management and monitoring tool
  • From: Rob Sargent
• Re: PostgreSQL Management and monitoring tool
  • From: Lucas
• Re: Undetected Deadlock
  • From: Michael Lewis
• Re: Undetected Deadlock
  • From: Michael Harris
• Re: PostgreSQL Management and monitoring tool
  • From: Bruce Momjian
• Re: Packages and inner subprograms for PL/pgSQL
  • From: Bryn Llewellyn
• could not open relation with OID
  • From: Ben Chobot
• PostgreSQL Management and monitoring tool
  • From: Lucas
• Re: Undetected Deadlock
  • From: Michael Lewis
• Re: Undetected Deadlock
  • From: Michael Harris
• Re: Counting the number of repeated phrases in a column
  • From: Merlin Moncure
• Re: Counting the number of repeated phrases in a column
  • From: Karsten Hilbert
• Re: Counting the number of repeated phrases in a column
  • From: Rob Sargent
• Counting the number of repeated phrases in a column
  • From: David G. Johnston
• Re: Counting the number of repeated phrases in a column
  • From: Shaozhong SHI
• Could not serialize access due to concurrent update
  • From: Mladen Gogala
• Re: SELECT with LIKE clause makes full table scan
  • From: Matthias Apitz
• Re: SELECT with LIKE clause makes full table scan
  • From: Julien Rouhaud
• Re: SELECT with LIKE clause makes full table scan
  • From: Matthias Apitz
• Re: SELECT with LIKE clause makes full table scan
  • From: Tom Lane
• Re: SELECT with LIKE clause makes full table scan
  • From: Imre Samu
• Re: SELECT with LIKE clause makes full table scan
  • From: Julien Rouhaud
• Re: SELECT with LIKE clause makes full table scan
  • From: Dominique Devienne
• Re: SELECT with LIKE clause makes full table scan
  • From: Julien Rouhaud
• Re: SELECT with LIKE clause makes full table scan
  • From: Matthias Apitz
• Re: SELECT with LIKE clause makes full table scan
  • From: Dominique Devienne
• Re: SELECT with LIKE clause makes full table scan
  • From: Josef Šimánek
• SELECT with LIKE clause makes full table scan
  • From: Matthias Apitz
• Re: Counting the number of repeated phrases in a column
  • From: Ivan E. Panchenko
• Re: Counting the number of repeated phrases in a column
  • From: benj . dev
• Re: Counting the number of repeated phrases in a column
  • From: Shaozhong SHI
• Re: Counting the number of repeated phrases in a column
  • From: Jian He
• Re: Undetected Deadlock
  • From: Alvaro Herrera
• Re: Counting the number of repeated phrases in a column
  • From: Ivan Panchenko
• Re: Counting the number of repeated phrases in a column
  • From: benj . dev
• NIST 800-53v4 scanning?
  • From: Ben Chobot
• Re: Counting the number of repeated phrases in a column
  • From: Laura Smith
• Re: Counting the number of repeated phrases in a column
  • From: David G. Johnston
• Aw: Re: Counting the number of repeated phrases in a column
  • From: Karsten Hilbert
• Re: Counting the number of repeated phrases in a column
  • From: Shaozhong SHI
• Aw: Counting the number of repeated phrases in a column
  • From: Karsten Hilbert
• Counting the number of repeated phrases in a column
  • From: Shaozhong SHI
• Re: Robust ways for checking allowed values in a column
  • From: Rob Sargent
• Re: Robust ways for checking allowed values in a column
  • From: Shaozhong SHI
• Re: tstzrange on large table gives poor estimate of expected rows
  • From: Tom Dearman
• Re: GIN index
  • From: Julien Rouhaud
• Re: Robust ways for checking allowed values in a column
  • From: Ray O'Donnell
• Re: Robust ways for checking allowed values in a column
  • From: David G. Johnston
• Re: Robust ways for checking allowed values in a column
  • From: Guillaume Lelarge
• Robust ways for checking allowed values in a column
  • From: Shaozhong SHI
• GIN index
  • From: huangning290@xxxxxxxxx
• Re: Undetected Deadlock
  • From: Rob Sargent
• Re: Undetected Deadlock
  • From: Michael Harris
• Undetected Deadlock
  • From: Michael Harris
• Re: Proposed German Translation of Code of Conduct Policy
  • From: Karsten Hilbert
• Re: Big variance in execution times of simple queries
  • From: Tom Lane
• Big variance in execution times of simple queries
  • From: Hannes Erven
• Re: Cannot find hstore operator
  • From: David G. Johnston
• Re: tstzrange on large table gives poor estimate of expected rows
  • From: Michael Lewis
• Re: Cannot find hstore operator
  • From: Adrian Klaver
• Re: Cannot find hstore operator
  • From: Dominique Devienne
• tstzrange on large table gives poor estimate of expected rows
  • From: Tom Dearman
• Re: Cannot find hstore operator
  • From: David G. Johnston
• Proposed German Translation of Code of Conduct Policy
  • From: Umair Shahid
• Re: Cannot find hstore operator
  • From: Dominique Devienne
• Re: Cannot find hstore operator
  • From: Ganesh Korde
• Re: Cannot find hstore operator
  • From: Dominique Devienne
• Re: Cannot find hstore operator
  • From: Paul van der Linden
• Broken logical replication
  • From: Игорь Выскорко
• Re: Cannot find hstore operator
  • From: Tom Lane
• Re: Cannot find hstore operator
  • From: David G. Johnston
• Re: Cannot find hstore operator
  • From: Paul van der Linden
• Re: [EXT] Re: Can we get the CTID value
  • From: Garfield Lewis
• Re: recording of INDEX creation in tables
  • From: Matthias Apitz
• Re: recording of INDEX creation in tables
  • From: David G. Johnston
• Re: How are md5.h: pg_md5_hash() function and below functions working?
  • From: Michael Paquier
• Re: recording of INDEX creation in tables
  • From: Michael Paquier
• Re: psql and Postgres 7.2
  • From: Adrian Klaver
• Re: psql and Postgres 7.2
  • From: Tom Lane
• Re: Using a different column name in a foreign table
  • From: David G. Johnston
• Re: Using a different column name in a foreign table
  • From: Adrian Klaver
• Re: Using a different column name in a foreign table
  • From: Tom Lane
• psql and Postgres 7.2
  • From: Adrian Klaver
• RE: Using a different column name in a foreign table
  • From: Alanoly Andrews
• Re: Using a different column name in a foreign table
  • From: Adrian Klaver
• Re: Can commands be typed in to view geometry in PgAdmin?
  • From: Ron
• RE: Using a different column name in a foreign table
  • From: Alanoly Andrews
• Re: Does PostgreSQL do bind-peeking? Is `col like '%'` optimized-away by the planner?
  • From: Tom Lane
• Re: Does PostgreSQL do bind-peeking? Is `col like '%'` optimized-away by the planner?
  • From: Dominique Devienne
• RE: Using a different column name in a foreign table
  • From: Alanoly Andrews
• Re: Using a different column name in a foreign table
  • From: Tom Lane
• Re: Can commands be typed in to view geometry in PgAdmin?
  • From: David G. Johnston
• Re: Does PostgreSQL do bind-peeking? Is `col like '%'` optimized-away by the planner?
  • From: Tom Lane
• Re: Using a different column name in a foreign table
  • From: Guillaume Lelarge