pgsql-general

Messages by Date

2026/03/11 Re: Guidance on PgSql Upgrade from 17.3 to 18.2 Ron Johnson
2026/03/11 Guidance on PgSql Upgrade from 17.3 to 18.2 Pratibha Shende
2026/03/10 Re: LISTAGG à la Oracle in PostgreSQL Pavel Stehule
2026/03/10 Re: LISTAGG à la Oracle in PostgreSQL Pavel Stehule
2026/03/10 Re: LISTAGG à la Oracle in PostgreSQL Isaac Morland
2026/03/10 Re: LISTAGG à la Oracle in PostgreSQL Juan Rodrigo Alejandro Burgos Mella
2026/03/10 Re: LISTAGG à la Oracle in PostgreSQL Pierre Forstmann
2026/03/10 Re: Index (primary key) corrupt? Adrian Klaver
2026/03/10 Re: Index (primary key) corrupt? Greg Sabino Mullane
2026/03/10 RE: Index (primary key) corrupt? Wim Rouquart
2026/03/10 Re: Index (primary key) corrupt? Greg Sabino Mullane
2026/03/10 Re: LISTAGG à la Oracle in PostgreSQL Juan Rodrigo Alejandro Burgos Mella
2026/03/09 Re: LISTAGG à la Oracle in PostgreSQL Paul A Jungwirth
2026/03/09 LISTAGG à la Oracle in PostgreSQL Pierre Forstmann
2026/03/09 Re: Index (primary key) corrupt? Adrian Klaver
2026/03/09 Re: Index (primary key) corrupt? Greg Sabino Mullane
2026/03/09 Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Shaheed Haque
2026/03/09 Re: Index (primary key) corrupt? Adrian Klaver
2026/03/09 Re: Index (primary key) corrupt? Greg Sabino Mullane
2026/03/09 Re: Index (primary key) corrupt? Adrian Klaver
2026/03/09 RE: Index (primary key) corrupt? Wim Rouquart
2026/03/09 Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Greg Sabino Mullane
2026/03/09 Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Shaheed Haque
2026/03/09 Re: CREATE TABLE fails Christoph Moench-Tegeder
2026/03/08 Re: CREATE TABLE fails Adrian Klaver
2026/03/08 Re: CREATE TABLE fails David G. Johnston
2026/03/08 Re: CREATE TABLE fails Igor Korot
2026/03/08 Re: CREATE TABLE fails David G. Johnston
2026/03/08 Re: CREATE TABLE fails Igor Korot
2026/03/08 Re: CREATE TABLE fails Igor Korot
2026/03/08 CREATE TABLE fails David G. Johnston
2026/03/08 Re: CREATE TABLE fails Ron Johnson
2026/03/08 Re: CREATE TABLE fails Igor Korot
2026/03/08 Re: CREATE TABLE fails Igor Korot
2026/03/08 Re: CREATE TABLE fails David G. Johnston
2026/03/08 Re: CREATE TABLE fails Igor Korot
2026/03/08 Re: CREATE TABLE fails Igor Korot
2026/03/08 Re: CREATE TABLE fails Igor Korot
2026/03/08 Re: CREATE TABLE fails Igor Korot
2026/03/08 Re: CREATE TABLE fails Sahul Hameed
2026/03/08 Re: CREATE TABLE fails Ron Johnson
2026/03/08 Re: CREATE TABLE fails Ron Johnson
2026/03/08 Re: CREATE TABLE fails Christoph Moench-Tegeder
2026/03/08 CREATE TABLE fails Igor Korot
2026/03/08 Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Greg Sabino Mullane
2026/03/08 Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() felix . quintgz
2026/03/08 Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Laurenz Albe
2026/03/08 Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Shaheed Haque
2026/03/08 Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() felix . quintgz
2026/03/07 Re: How to properly use TRIM()? Igor Korot
2026/03/07 Re: How to properly use TRIM()? David G. Johnston
2026/03/07 Re: How to properly use TRIM()? Igor Korot
2026/03/07 Re: How to properly use TRIM()? Adrian Klaver
2026/03/07 Re: How to properly use TRIM()? Igor Korot
2026/03/07 Re: How to properly use TRIM()? David G. Johnston
2026/03/07 Re: How to properly use TRIM()? Igor Korot
2026/03/07 Re: How to properly use TRIM()? Rob Sargent
2026/03/07 Re: How to properly use TRIM()? Igor Korot
2026/03/07 Re: How to properly use TRIM()? Igor Korot
2026/03/07 Re: How to properly use TRIM()? Adrian Klaver
2026/03/07 Re: How to properly use TRIM()? David G. Johnston
2026/03/07 Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Tom Lane
2026/03/07 Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Shaheed Haque
2026/03/07 Re: How to properly use TRIM()? Igor Korot
2026/03/06 Re: How to properly use TRIM()? David G. Johnston
2026/03/06 How to properly use TRIM()? Igor Korot
2026/03/06 Sort and limit push down Adrien Nayrat
2026/03/06 Re: Index (primary key) corrupt? Adrian Klaver
2026/03/06 RE: Index (primary key) corrupt? Wim Rouquart
2026/03/05 Re: Index (primary key) corrupt? Adrian Klaver
2026/03/05 RE: Index (primary key) corrupt? Wim Rouquart
2026/03/05 Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup loganathan P
2026/03/05 Re: Heavy load on DB Cluster Laurenz Albe
2026/03/04 Heavy load on DB Cluster KK CHN
2026/03/04 R: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup Gianfranco Cocco
2026/03/03 Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup Ron Johnson
2026/03/03 Re: Timezone handling with timestamp without time zone columns Adrian Klaver
2026/03/03 Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup Laurenz Albe
2026/03/03 PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup loganathan P
2026/03/03 Re: Timezone handling with timestamp without time zone columns Laurenz Albe
2026/03/03 Re: Timezone handling with timestamp without time zone columns Nandish Bhuva
2026/03/02 Re: Documentation weirdness David G. Johnston
2026/03/02 Re: Documentation weirdness David G. Johnston
2026/03/02 Re: Documentation weirdness Tom Lane
2026/03/02 Re: Documentation weirdness David G. Johnston
2026/03/02 Re: Documentation weirdness Peter J. Holzer
2026/03/01 Re: Documentation weirdness Igor Korot
2026/03/01 Re: Documentation weirdness David G. Johnston
2026/03/01 Re: Documentation weirdness Adrian Klaver
2026/03/01 Documentation weirdness Igor Korot
2026/03/01 Re: Can "on delete cascade" dependency be used in pgdump or similar ? Justin Swanhart
2026/03/01 Re: Where the info is stored Laurenz Albe
2026/02/28 Re: Where the info is stored Igor Korot
2026/02/28 Re: Where the info is stored Igor Korot
2026/02/28 Re: Where the info is stored David G. Johnston
2026/02/28 Re: Where the info is stored Igor Korot
2026/02/28 Re: Where the info is stored David G. Johnston
2026/02/28 Re: Where the info is stored David G. Johnston
2026/02/28 Re: Where the info is stored Igor Korot
2026/02/28 Re: Where the info is stored Igor Korot
2026/02/28 Re: Where the info is stored David G. Johnston
2026/02/28 Re: Where the info is stored Igor Korot
2026/02/28 Re: Can "on delete cascade" dependency be used in pgdump or similar ? Ron Johnson
2026/02/28 Re: Timezone handling with timestamp without time zone columns Peter J. Holzer
2026/02/27 Re: Can "on delete cascade" dependency be used in pgdump or similar ? Adrian Klaver
2026/02/27 Re: Can "on delete cascade" dependency be used in pgdump or similar ? Adrian Klaver
2026/02/27 Re: Can "on delete cascade" dependency be used in pgdump or similar ? David G. Johnston
2026/02/27 Can "on delete cascade" dependency be used in pgdump or similar ? dfgpostgres
2026/02/27 Re: Where the info is stored David G. Johnston
2026/02/27 Re: Default values in the docs David G. Johnston
2026/02/27 Re: Default values in the docs Adrian Klaver
2026/02/27 Re: Timezone handling with timestamp without time zone columns Laurenz Albe
2026/02/27 Re: Change WAL directory via conf David G. Johnston
2026/02/27 Re: Default values in the docs David G. Johnston
2026/02/27 Change WAL directory via conf Thomas Butz
2026/02/27 Timezone handling with timestamp without time zone columns Nandish Bhuva
2026/02/26 Default values in the docs Igor Korot
2026/02/26 Re: Issue with refreshing materialized view from another system Adrian Klaver
2026/02/26 Re: Issue with refreshing materialized view from another system Ron Johnson
2026/02/26 Re: Issue with refreshing materialized view from another system Michael Nolan
2026/02/26 Re: Issue with refreshing materialized view from another system Ron Johnson
2026/02/26 Re: Issue with refreshing materialized view from another system Michael Nolan
2026/02/26 Re: Issue with refreshing materialized view from another system Ron Johnson
2026/02/26 Re: Issue with refreshing materialized view from another system Michael Nolan
2026/02/26 Re: Issue with refreshing materialized view from another system Adrian Klaver
2026/02/26 Issue with refreshing materialized view from another system Michael Nolan
2026/02/25 Re: PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query Tom Lane
2026/02/25 Re: Recovery Verification dmurvihill
2026/02/25 Re: PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query Tom Lane
2026/02/25 Re: PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query PALAYRET Jacques
2026/02/25 Re: PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query David G. Johnston
2026/02/25 Re: PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query PALAYRET Jacques
2026/02/25 Re: PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query Adrian Klaver
2026/02/25 PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query PALAYRET Jacques
2026/02/24 Re: pgbackrest after a network outage unable to perform backup [fails always] KK CHN
2026/02/24 Re: Using COPY via pg_background extension Ron Johnson
2026/02/24 Re: Recovery Verification Ron Johnson
2026/02/24 Postgres Patch Review Workshop: March 2026 Paul A Jungwirth
2026/02/24 Re: Using COPY via pg_background extension Adrian Klaver
2026/02/24 Using COPY via pg_background extension Oleg Dushin
2026/02/24 Re: Recovery Verification Adrian Klaver
2026/02/24 Re: pgbackrest after a network outage unable to perform backup [fails always] Greg Sabino Mullane
2026/02/24 Re: Recovery Verification Ron Johnson
2026/02/24 pgbackrest after a network outage unable to perform backup [fails always] KK CHN
2026/02/23 Recovery Verification dolan
2026/02/23 Re: Can we get sha* function over text, that could be used in index? Linus Heckemann
2026/02/21 Re: Can we get sha* function over text, that could be used in index? Peter J. Holzer
2026/02/21 Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively? Pawel Kudzia
2026/02/20 Re: Can we get sha* function over text, that could be used in index? Daniel Verite
2026/02/20 Re: Clarification on PGDG Package Policies Across Platforms Adrian Klaver
2026/02/20 Clarification on PGDG Package Policies Across Platforms sreekanta reddy
2026/02/20 Re: Can we get sha* function over text, that could be used in index? Linus Heckemann
2026/02/19 Re: v17.8 rpm packages under /pub/repos/yum/17/redhat/rhel-9-x86_64/ Adrian Klaver
2026/02/19 v17.8 rpm packages under /pub/repos/yum/17/redhat/rhel-9-x86_64/ Sung Lee
2026/02/19 Re: Can we get sha* function over text, that could be used in index? Peter J. Holzer
2026/02/19 Re: Postgres restore sometimes restores to a point 2 days in the past Koen De Groote
2026/02/19 Re: Can we get sha* function over text, that could be used in index? Peter Eisentraut
2026/02/18 Re: Bug: PG 14 recovery failure Michael Paquier
2026/02/18 Re: Guarantee order of batched pg_advisory_xact_lock Nico Heller
2026/02/18 Re: Can we get sha* function over text, that could be used in index? Ron Johnson
2026/02/18 Can we get sha* function over text, that could be used in index? hubert depesz lubaczewski
2026/02/18 Re: Bug: PG 14 recovery failure David Rowley
2026/02/18 Bug: PG 14 recovery failure Torsten Förtsch
2026/02/17 Re: Where the info is stored Greg Sabino Mullane
2026/02/17 Re: Guarantee order of batched pg_advisory_xact_lock Greg Sabino Mullane
2026/02/16 Re: Where the info is stored David G. Johnston
2026/02/16 Where the info is stored Igor Korot
2026/02/16 Re: Why there is no records? Igor Korot
2026/02/16 Re: Why there is no records? Adrian Klaver
2026/02/16 Re: Why there is no records? Christoph Moench-Tegeder
2026/02/16 Why there is no records? Igor Korot
2026/02/16 Re: pgbouncer transaction pool mode issue for prepared statements Durgamahesh Manne
2026/02/16 Re: Guarantee order of batched pg_advisory_xact_lock Nico Heller
2026/02/16 Re: pgbouncer transaction pool mode issue for prepared statements Adrian Klaver
2026/02/16 Re: Question on execution plan and suitable index Laurenz Albe
2026/02/16 Re: pgbouncer transaction pool mode issue for prepared statements Adrien Obernesser (OBA)
2026/02/16 pgbouncer transaction pool mode issue for prepared statements Durgamahesh Manne
2026/02/16 Re: Question on execution plan and suitable index yudhi s
2026/02/16 Re: Question on execution plan and suitable index Laurenz Albe
2026/02/16 Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance Pierre Barre
2026/02/16 Re: Question on execution plan and suitable index yudhi s
2026/02/16 Re: Question on execution plan and suitable index Laurenz Albe
2026/02/16 Re: Question on execution plan and suitable index Laurenz Albe
2026/02/16 Re: Question on execution plan and suitable index yudhi s
2026/02/15 Re: Regarding query optimisation (select for update) Durgamahesh Manne
2026/02/15 Re: Regarding query optimisation (select for update) Durgamahesh Manne
2026/02/15 Re: Question on execution plan and suitable index Nisarg Patel
2026/02/15 Re: Question on execution plan and suitable index Adrian Klaver
2026/02/15 Question on execution plan and suitable index yudhi s
2026/02/13 Re: PRIMARY KEY parameters David G. Johnston
2026/02/13 PRIMARY KEY parameters Igor Korot
2026/02/13 Re: Fillfactor effectiveness on existing table Durgamahesh Manne
2026/02/13 Re: Best practice for granting folder read/write permission on Windows Ron Johnson
2026/02/13 Best practice for granting folder read/write permission on Windows Anthony DeBarros
2026/02/13 Re: pg_restore failed on foreign key constraint Ron Johnson
2026/02/13 Re: pg_restore failed on foreign key constraint Adrian Klaver
2026/02/13 Re: Index (primary key) corrupt? Adrian Klaver
2026/02/13 Re: pg_restore failed on foreign key constraint Ron Johnson
2026/02/13 RE: Index (primary key) corrupt? Wim Rouquart
2026/02/13 Re: pg_restore failed on foreign key constraint Adrian Klaver