pgsql-general  

Messages by Thread

• • Re: Index scan with bitmap filter - has this been explored Tomas Vondra
  • Re: Index scan with bitmap filter - has this been explored Alexandre Felipe
• Replication to standby broke with WAL file corruption Ishan joshi
  • Re: Replication to standby broke with WAL file corruption Tomas Vondra
  • Re: Replication to standby broke with WAL file corruption Ishan joshi
• correct formula for calculating distance t transaction and distance to snapshot Ishan joshi
• libq API question Igor Korot
  • Re: libq API question David G. Johnston
• (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' Martin Goodson
  • Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' Justin Swanhart
  • Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' Michael Paquier
  • Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' Tom Lane
• POprepare fails Igor Korot
  • Re: POprepare fails Laurenz Albe
  • Re: POprepare fails Igor Korot
• Question about heap_inplace_update and VACUUM behavior Shiju Sivadazz
• Guidance on PgSql Upgrade from 17.3 to 18.2 Pratibha Shende
  • Re: Guidance on PgSql Upgrade from 17.3 to 18.2 Ron Johnson
• LISTAGG à la Oracle in PostgreSQL Pierre Forstmann
  • Re: LISTAGG à la Oracle in PostgreSQL Paul A Jungwirth
  • Re: LISTAGG à la Oracle in PostgreSQL Pierre Forstmann
  • Re: LISTAGG à la Oracle in PostgreSQL Juan Rodrigo Alejandro Burgos Mella
  • Re: LISTAGG à la Oracle in PostgreSQL Isaac Morland
  • Re: LISTAGG à la Oracle in PostgreSQL pierre . forstmann
  • Re: LISTAGG à la Oracle in PostgreSQL Pavel Stehule
  • Re: LISTAGG à la Oracle in PostgreSQL Pavel Stehule
  • Re: LISTAGG à la Oracle in PostgreSQL pierre . forstmann
  • Re: LISTAGG à la Oracle in PostgreSQL Juan Rodrigo Alejandro Burgos Mella
  • Re: LISTAGG à la Oracle in PostgreSQL Peter Eisentraut
• CREATE TABLE fails Igor Korot
  • Re: CREATE TABLE fails Christoph Moench-Tegeder
  • Re: CREATE TABLE fails Ron Johnson
  • Re: CREATE TABLE fails Igor Korot
  • Re: CREATE TABLE fails Christoph Moench-Tegeder
  • Re: CREATE TABLE fails Ron Johnson
  • Re: CREATE TABLE fails Igor Korot
  • Re: CREATE TABLE fails David G. Johnston
  • Re: CREATE TABLE fails Igor Korot
  • Re: CREATE TABLE fails Ron Johnson
  • Re: CREATE TABLE fails Igor Korot
  • Re: CREATE TABLE fails Sahul Hameed
  • Re: CREATE TABLE fails Igor Korot
  • Re: CREATE TABLE fails Igor Korot
  • CREATE TABLE fails David G. Johnston
  • Re: CREATE TABLE fails Igor Korot
  • Re: CREATE TABLE fails David G. Johnston
  • Re: CREATE TABLE fails Igor Korot
  • Re: CREATE TABLE fails Adrian Klaver
  • Re: CREATE TABLE fails David G. Johnston
  • Re: CREATE TABLE fails Igor Korot
• Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Shaheed Haque
  • Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Tom Lane
  • Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() felix . quintgz
  • Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Shaheed Haque
  • Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() felix . quintgz
  • Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Greg Sabino Mullane
  • Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Shaheed Haque
  • Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Greg Sabino Mullane
  • Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Shaheed Haque
  • Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Laurenz Albe
• How to properly use TRIM()? Igor Korot
  • Re: How to properly use TRIM()? David G. Johnston
  • Re: How to properly use TRIM()? Igor Korot
  • Re: How to properly use TRIM()? David G. Johnston
  • Re: How to properly use TRIM()? Adrian Klaver
  • Re: How to properly use TRIM()? Igor Korot
  • Re: How to properly use TRIM()? Rob Sargent
  • Re: How to properly use TRIM()? Igor Korot
  • Re: How to properly use TRIM()? David G. Johnston
  • Re: How to properly use TRIM()? Igor Korot
  • Re: How to properly use TRIM()? Adrian Klaver
  • Re: How to properly use TRIM()? Igor Korot
  • Re: How to properly use TRIM()? David G. Johnston
  • Re: How to properly use TRIM()? Igor Korot
  • Re: How to properly use TRIM()? Igor Korot
  • help debugging an issue with selectivity Greg Hennessy
  • Re: help debugging an issue with selectivity Rob Sargent
  • Re: help debugging an issue with selectivity Tom Lane
  • Re: help debugging an issue with selectivity Greg Hennessy
• Sort and limit push down Adrien Nayrat
• Heavy load on DB Cluster KK CHN
  • Re: Heavy load on DB Cluster Laurenz Albe
• PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup loganathan P
  • Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup Laurenz Albe
  • Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup Ron Johnson
  • R: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup Gianfranco Cocco
  • Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup loganathan P
• Documentation weirdness Igor Korot
  • Re: Documentation weirdness Adrian Klaver
  • Re: Documentation weirdness David G. Johnston
  • Re: Documentation weirdness Igor Korot
  • Re: Documentation weirdness Peter J. Holzer
  • Re: Documentation weirdness David G. Johnston
  • Re: Documentation weirdness Tom Lane
  • Re: Documentation weirdness David G. Johnston
  • Re: Documentation weirdness David G. Johnston
  • Re: Documentation weirdness David G. Johnston
• Can "on delete cascade" dependency be used in pgdump or similar ? dfgpostgres
  • Re: Can "on delete cascade" dependency be used in pgdump or similar ? David G. Johnston
  • Re: Can "on delete cascade" dependency be used in pgdump or similar ? Adrian Klaver
  • Re: Can "on delete cascade" dependency be used in pgdump or similar ? Adrian Klaver
  • Re: Can "on delete cascade" dependency be used in pgdump or similar ? Ron Johnson
  • Re: Can "on delete cascade" dependency be used in pgdump or similar ? Justin Swanhart
• Change WAL directory via conf Thomas Butz
  • Re: Change WAL directory via conf David G. Johnston
• Timezone handling with timestamp without time zone columns Nandish Bhuva
  • Re: Timezone handling with timestamp without time zone columns Laurenz Albe
  • Re: Timezone handling with timestamp without time zone columns Peter J. Holzer
  • Re: Timezone handling with timestamp without time zone columns Nandish Bhuva
  • Re: Timezone handling with timestamp without time zone columns Laurenz Albe
  • Re: Timezone handling with timestamp without time zone columns Adrian Klaver
• Default values in the docs Igor Korot
  • Re: Default values in the docs David G. Johnston
  • Re: Default values in the docs Adrian Klaver
  • Re: Default values in the docs David G. Johnston
• Issue with refreshing materialized view from another system Michael Nolan
  • Re: Issue with refreshing materialized view from another system Adrian Klaver
  • Re: Issue with refreshing materialized view from another system Michael Nolan
  • Re: Issue with refreshing materialized view from another system Ron Johnson
  • Re: Issue with refreshing materialized view from another system Michael Nolan
  • Re: Issue with refreshing materialized view from another system Ron Johnson
  • Re: Issue with refreshing materialized view from another system Michael Nolan
  • Re: Issue with refreshing materialized view from another system Ron Johnson
  • Re: Issue with refreshing materialized view from another system Adrian Klaver
• PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query PALAYRET Jacques
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
• Postgres Patch Review Workshop: March 2026 Paul A Jungwirth
• Using COPY via pg_background extension Oleg Dushin
  • Re: Using COPY via pg_background extension Adrian Klaver
  • Re: Using COPY via pg_background extension Ron Johnson
• pgbackrest after a network outage unable to perform backup [fails always] KK CHN
  • Re: pgbackrest after a network outage unable to perform backup [fails always] Greg Sabino Mullane
  • Re: pgbackrest after a network outage unable to perform backup [fails always] KK CHN
• Recovery Verification dolan
  • Re: Recovery Verification Ron Johnson
  • Re: Recovery Verification Adrian Klaver
  • Re: Recovery Verification Ron Johnson
  • Re: Recovery Verification dmurvihill
• Clarification on PGDG Package Policies Across Platforms sreekanta reddy
  • Re: Clarification on PGDG Package Policies Across Platforms Adrian Klaver
• v17.8 rpm packages under /pub/repos/yum/17/redhat/rhel-9-x86_64/ Sung Lee
  • Re: v17.8 rpm packages under /pub/repos/yum/17/redhat/rhel-9-x86_64/ Adrian Klaver
• Re: Postgres restore sometimes restores to a point 2 days in the past Koen De Groote
• Can we get sha* function over text, that could be used in index? hubert depesz lubaczewski
  • Re: Can we get sha* function over text, that could be used in index? Ron Johnson
  • Re: Can we get sha* function over text, that could be used in index? Peter Eisentraut
  • Re: Can we get sha* function over text, that could be used in index? Peter J. Holzer
  • Re: Can we get sha* function over text, that could be used in index? Peter J. Holzer
  • Re: Can we get sha* function over text, that could be used in index? Linus Heckemann
  • Re: Can we get sha* function over text, that could be used in index? Daniel Verite
  • Re: Can we get sha* function over text, that could be used in index? Linus Heckemann
• Bug: PG 14 recovery failure Torsten Förtsch
  • Re: Bug: PG 14 recovery failure David Rowley
  • Re: Bug: PG 14 recovery failure Michael Paquier
• Where the info is stored Igor Korot
  • Re: Where the info is stored David G. Johnston
  • Re: Where the info is stored Greg Sabino Mullane
  • Re: Where the info is stored David G. Johnston
  • Re: Where the info is stored Igor Korot
  • Re: Where the info is stored David G. Johnston
  • Re: Where the info is stored Igor Korot
  • Re: Where the info is stored Igor Korot
  • Re: Where the info is stored David G. Johnston
  • Re: Where the info is stored Igor Korot
  • Re: Where the info is stored David G. Johnston
  • Re: Where the info is stored Igor Korot
  • Re: Where the info is stored Igor Korot
  • Re: Where the info is stored Laurenz Albe
  • Re: Where the info is stored David G. Johnston
• Why there is no records? Igor Korot
  • Re: Why there is no records? Christoph Moench-Tegeder
  • Re: Why there is no records? Adrian Klaver
  • Re: Why there is no records? Igor Korot
• pgbouncer transaction pool mode issue for prepared statements Durgamahesh Manne
  • Re: pgbouncer transaction pool mode issue for prepared statements Adrien Obernesser (OBA)
  • Re: pgbouncer transaction pool mode issue for prepared statements Adrian Klaver
  • Re: pgbouncer transaction pool mode issue for prepared statements Durgamahesh Manne
• Question on execution plan and suitable index yudhi s
  • Re: Question on execution plan and suitable index Adrian Klaver
  • Re: Question on execution plan and suitable index Nisarg Patel
  • Re: Question on execution plan and suitable index Laurenz Albe
  • Re: Question on execution plan and suitable index yudhi s
  • Re: Question on execution plan and suitable index Laurenz Albe
  • Re: Question on execution plan and suitable index yudhi s
  • Re: Question on execution plan and suitable index Laurenz Albe
  • Re: Question on execution plan and suitable index yudhi s
  • Re: Question on execution plan and suitable index Laurenz Albe
• PRIMARY KEY parameters Igor Korot
  • Re: PRIMARY KEY parameters David G. Johnston
• Best practice for granting folder read/write permission on Windows Anthony DeBarros
  • Re: Best practice for granting folder read/write permission on Windows Ron Johnson
• SIGBUS coredumps in AllocSetContextCreateInternal() Peter 'PMc' Much
• pg_restore failed on foreign key constraint Ron Johnson
  • Re: pg_restore failed on foreign key constraint Laurenz Albe
  • Re: pg_restore failed on foreign key constraint Ron Johnson

• Earlier messages
• Later messages