Mailing lists [pgsql-general]

1 February

• 00:05   Re: Top -N Query performance issue and high CPU usage Ron Johnson
• 01:09   Help with PhD Dissertation Osmel Brito-Bigott
• 15:54   Re: Top -N Query performance issue and high CPU usage Luigi Nardi

2 February

• 00:47   Re: Top -N Query performance issue and high CPU usage Peter J. Holzer
• 00:56   Re: Top -N Query performance issue and high CPU usage Ron Johnson
• 04:06   Re: Top -N Query performance issue and high CPU usage Adrian Klaver
• 07:17   Re: Top -N Query performance issue and high CPU usage yudhi s
• 09:33   Re: Top -N Query performance issue and high CPU usage yudhi s
• 10:45   Re: Top -N Query performance issue and high CPU usage Thiemo Kellner
• 14:39   Re: Top -N Query performance issue and high CPU usage yudhi s
• 16:34   Re: Top -N Query performance issue and high CPU usage Ron Johnson
• 16:53   Re: Top -N Query performance issue and high CPU usage yudhi s
• 18:00   Re: Top -N Query performance issue and high CPU usage Ron Johnson
• 21:39   Re: Top -N Query performance issue and high CPU usage yudhi s
• 22:31   Re: Top -N Query performance issue and high CPU usage Ron Johnson
• 23:43   Re: Top -N Query performance issue and high CPU usage yudhi s

3 February

• 02:19   Re: Top -N Query performance issue and high CPU usage Ron Johnson
• 12:26   Re: Top -N Query performance issue and high CPU usage yudhi s
• 18:59   Re: Top -N Query performance issue and high CPU usage Ron Johnson
• 19:07   Re: Top -N Query performance issue and high CPU usage Adrian Klaver
• 21:50   Re: Top -N Query performance issue and high CPU usage yudhi s
• 23:51   Re: Top -N Query performance issue and high CPU usage Ron Johnson

4 February

• 00:02   Re: Top -N Query performance issue and high CPU usage Peter J. Holzer
• 18:48   Re: Top -N Query performance issue and high CPU usage felix.quintgz@yahoo.com

5 February

• 11:20   Re: Top -N Query performance issue and high CPU usage yudhi s
• 11:35   Re: Top -N Query performance issue and high CPU usage yudhi s
• 14:32   Re: Top -N Query performance issue and high CPU usage Thiemo Kellner
• 22:16   Re: Is this expected concurrency behaviour for EvalPlanQual and ctid? Sophie Alpert

6 February

• 19:55   Re: UNLOGGED table CREATEd on one connection not immediately visible to another connection Geoff Winkless
• 20:34   UNLOGGED table CREATEd on one connection not immediately visible to another connection David G. Johnston
• 22:34   Re: UNLOGGED table CREATEd on one connection not immediately visible to another connection Greg Sabino Mullane

8 February

• 07:19   Table bloat threshold limit to trigger repack Durgamahesh Manne
• 08:29   Re: Table bloat threshold limit to trigger repack Ron Johnson
• 08:43   Re: Table bloat threshold limit to trigger repack Durgamahesh Manne
• 10:45   Re: Table bloat threshold limit to trigger repack Ron Johnson
• 12:44   Re: Table bloat threshold limit to trigger repack Durgamahesh Manne
• 18:06   Re: Table bloat threshold limit to trigger repack Peter J. Holzer
• 19:26   Re: Table bloat threshold limit to trigger repack Ron Johnson
• 21:05   Re: Table bloat threshold limit to trigger repack Durgamahesh Manne
• 23:46   Re: Table bloat threshold limit to trigger repack Adrian Klaver

9 February

• 00:06   Re: Table bloat threshold limit to trigger repack Ron Johnson
• 04:17   REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table Dirk Krautschick
• 04:41   Re: REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table Adrian Klaver
• 14:11   Re: REFRESH MATERIALIZED VIEW CONCURRENTLY is blocking autovacuum on table Laurenz Albe

10 February

• 04:37   Fwd: JetBrains: Invoice JBAINV26114490 Christophe Pettus
• 04:42   Re: JetBrains: Invoice JBAINV26114490 Christophe Pettus
• 18:55   Fillfactor effectiveness on existing table Durgamahesh Manne
• 19:05   Re: Fillfactor effectiveness on existing table David G. Johnston
• 20:28   Re: Fillfactor effectiveness on existing table Ron Johnson
• 21:31   Re: Fillfactor effectiveness on existing table Laurenz Albe

11 February

• 05:28   Re: Fillfactor effectiveness on existing table Durgamahesh Manne
• 05:34   Re: Fillfactor effectiveness on existing table Durgamahesh Manne
• 05:41   Re: Table bloat threshold limit to trigger repack Durgamahesh Manne
• 06:02   Re: Fillfactor effectiveness on existing table Ron Johnson
• 06:26   Re: Fillfactor effectiveness on existing table Durgamahesh Manne
• 09:37   Re: Fillfactor effectiveness on existing table Laurenz Albe
• 11:53   Re: Fillfactor effectiveness on existing table Durgamahesh Manne
• 11:53   Access to pg_replication_origin* functions Egor Voynov
• 12:05   RE: Index (primary key) corrupt? Wim Rouquart
• 21:44   Guarantee order of batched pg_advisory_xact_lock Nico Heller

12 February

• 00:17   Re: Guarantee order of batched pg_advisory_xact_lock Tom Lane
• 00:51   Re: Guarantee order of batched pg_advisory_xact_lock Nico Heller
• 01:49   Re: Guarantee order of batched pg_advisory_xact_lock Tom Lane
• 14:18   Re: Guarantee order of batched pg_advisory_xact_lock Nico Heller
• 17:47   Re: Guarantee order of batched pg_advisory_xact_lock Greg Sabino Mullane
• 19:25   Re: Index (primary key) corrupt? Adrian Klaver
• 21:56   Re: Guarantee order of batched pg_advisory_xact_lock Nico Heller

13 February

• 00:35   pg_restore failed on foreign key constraint Ron Johnson
• 09:43   Re: pg_restore failed on foreign key constraint Laurenz Albe
• 11:08   RE: Index (primary key) corrupt? Wim Rouquart
• 15:28   SIGBUS coredumps in AllocSetContextCreateInternal() Peter 'PMc' Much
• 17:18   Re: pg_restore failed on foreign key constraint Ron Johnson
• 18:55   Re: pg_restore failed on foreign key constraint Adrian Klaver
• 19:05   Re: pg_restore failed on foreign key constraint Ron Johnson
• 19:09   Re: Index (primary key) corrupt? Adrian Klaver
• 19:14   Re: pg_restore failed on foreign key constraint Adrian Klaver
• 19:27   RE: Index (primary key) corrupt? Wim Rouquart
• 19:40   Re: pg_restore failed on foreign key constraint Ron Johnson
• 20:32   Re: Index (primary key) corrupt? Adrian Klaver
• 20:35   Re: pg_restore failed on foreign key constraint Adrian Klaver

14 February

• 00:14   Best practice for granting folder read/write permission on Windows Anthony DeBarros
• 01:23   Re: Best practice for granting folder read/write permission on Windows Ron Johnson
• 03:24   Re: Fillfactor effectiveness on existing table Durgamahesh Manne
• 05:29   PRIMARY KEY parameters Igor Korot
• 06:04   Re: PRIMARY KEY parameters David G. Johnston

15 February

• 22:04   Question on execution plan and suitable index yudhi s
• 23:51   Re: Question on execution plan and suitable index Adrian Klaver

16 February

• 00:38   Re: Question on execution plan and suitable index Nisarg Patel
• 03:26   Re: Regarding query optimisation (select for update) Durgamahesh Manne
• 03:38   Re: Regarding query optimisation (select for update) Durgamahesh Manne
• 11:59   Re: Question on execution plan and suitable index Laurenz Albe
• 12:13   Re: Question on execution plan and suitable index yudhi s
• 12:54   Re: Question on execution plan and suitable index Laurenz Albe
• 13:39   Re: Question on execution plan and suitable index yudhi s
• 14:06   Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance Pierre Barre
• 14:52   Re: Question on execution plan and suitable index Laurenz Albe
• 15:22   Re: Question on execution plan and suitable index yudhi s
• 16:24   pgbouncer transaction pool mode issue for prepared statements Durgamahesh Manne
• 16:36   Re: pgbouncer transaction pool mode issue for prepared statements Adrien Obernesser (OBA)
• 17:38   Re: Question on execution plan and suitable index Laurenz Albe
• 19:05   Re: pgbouncer transaction pool mode issue for prepared statements Adrian Klaver
• 20:45   Re: Guarantee order of batched pg_advisory_xact_lock Nico Heller
• 22:10   Re: pgbouncer transaction pool mode issue for prepared statements Durgamahesh Manne

17 February

• 02:59   Why there is no records? Igor Korot
• 03:03   Re: Why there is no records? Christoph Moench-Tegeder
• 03:03   Re: Why there is no records? Adrian Klaver
• 03:15   Re: Why there is no records? Igor Korot
• 03:38   Where the info is stored Igor Korot
• 03:49   Re: Where the info is stored David G. Johnston
• 17:55   Re: Guarantee order of batched pg_advisory_xact_lock Greg Sabino Mullane
• 17:59   Re: Where the info is stored Greg Sabino Mullane

18 February

• 11:40   Bug: PG 14 recovery failure Torsten Förtsch
• 13:27   Re: Bug: PG 14 recovery failure David Rowley
• 17:58   Can we get sha* function over text, that could be used in index? hubert depesz lubaczewski
• 18:07   Re: Can we get sha* function over text, that could be used in index? Ron Johnson
• 21:02   Re: Can we get sha* function over text, that could be used in index? Linus Heckemann

19 February

• 00:19   Re: Guarantee order of batched pg_advisory_xact_lock Nico Heller
• 07:11   Re: Bug: PG 14 recovery failure Michael Paquier
• 17:48   Re: Can we get sha* function over text, that could be used in index? Peter Eisentraut
• 22:30   Re: Postgres restore sometimes restores to a point 2 days in the past Koen De Groote

20 February

• 01:30   Re: Can we get sha* function over text, that could be used in index? Peter J. Holzer
• 01:42   v17.8 rpm packages under /pub/repos/yum/17/redhat/rhel-9-x86_64/ Sung Lee
• 03:00   Re: v17.8 rpm packages under /pub/repos/yum/17/redhat/rhel-9-x86_64/ Adrian Klaver
• 17:57   Clarification on PGDG Package Policies Across Platforms sreekanta reddy
• 21:40   Re: Clarification on PGDG Package Policies Across Platforms Adrian Klaver

21 February

• 00:40   Re: Can we get sha* function over text, that could be used in index? Daniel Verite
• 12:54   Re: Can we get sha* function over text, that could be used in index? Linus Heckemann
• 13:20   Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively? Pawel Kudzia
• 15:40   Re: Can we get sha* function over text, that could be used in index? Peter J. Holzer

24 February

• 01:07   Recovery Verification dolan@directdemocracysolutions.com
• 13:25   pgbackrest after a network outage unable to perform backup [fails always] KK CHN
• 16:40   Re: Recovery Verification Ron Johnson
• 18:49   Re: pgbackrest after a network outage unable to perform backup [fails always] Greg Sabino Mullane
• 18:50   Re: Recovery Verification Adrian Klaver
• 19:13   Using COPY via pg_background extension Oleg Dushin
• 19:28   Re: Using COPY via pg_background extension Adrian Klaver
• 19:57   Postgres Patch Review Workshop: March 2026 Paul A Jungwirth
• 22:16   Re: Recovery Verification Ron Johnson
• 22:21   Re: Using COPY via pg_background extension Ron Johnson

25 February

• 10:26   Re: pgbackrest after a network outage unable to perform backup [fails always] KK CHN
• 11:28   Timezone handling with timestamp without time zone columns Nandish Bhuva
• 14:14   PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query PALAYRET Jacques
• 19:00   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
• 19:00   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
• 19:20   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
• 19:42   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
• 20:33   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
• 21:03   Re: Recovery Verification dmurvihill@gmail.com

26 February

• 01:44   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

27 February

• 00:59   Issue with refreshing materialized view from another system Michael Nolan
• 01:11   Re: Issue with refreshing materialized view from another system Adrian Klaver
• 02:37   Re: Issue with refreshing materialized view from another system Michael Nolan
• 02:45   Re: Issue with refreshing materialized view from another system Ron Johnson
• 02:48   Re: Issue with refreshing materialized view from another system Michael Nolan
• 03:01   Re: Issue with refreshing materialized view from another system Ron Johnson
• 03:09   Re: Issue with refreshing materialized view from another system Michael Nolan
• 03:13   Re: Issue with refreshing materialized view from another system Ron Johnson
• 03:25   Re: Issue with refreshing materialized view from another system Adrian Klaver
• 09:43   Default values in the docs Igor Korot
• 16:50   Change WAL directory via conf Thomas Butz
• 17:00   Re: Default values in the docs David G. Johnston
• 17:36   Re: Change WAL directory via conf David G. Johnston
• 18:01   Re: Timezone handling with timestamp without time zone columns Laurenz Albe
• 18:47   Re: Default values in the docs Adrian Klaver
• 18:58   Re: Default values in the docs David G. Johnston
• 19:17   Re: Where the info is stored David G. Johnston

28 February

• 01:39   Can "on delete cascade" dependency be used in pgdump or similar ? dfgpostgres
• 01:57   Re: Can "on delete cascade" dependency be used in pgdump or similar ? David G. Johnston
• 02:13   Re: Can "on delete cascade" dependency be used in pgdump or similar ? Adrian Klaver
• 02:15   Re: Can "on delete cascade" dependency be used in pgdump or similar ? Adrian Klaver
• 15:00   Re: Timezone handling with timestamp without time zone columns Peter J. Holzer