Mailing lists [pgsql-general]

1 December 2023

• 01:03   Re: replication strange behavior Ron Johnson
• 01:10   Re: Two started cluster on the same data directory and port Adrian Klaver
• 02:42   Re: replication strange behavior Atul Kumar
• 04:26   Re: libpq crashing on macOS during connection startup John DeSoi
• 04:53   Re: libpq crashing on macOS during connection startup Tom Lane
• 05:08   Feature request for INITCAP() function Jeff Gerbracht
• 05:57   Query related to pg_dump write to a pipe on a windows client and with compressed format Meera Nair
• 07:43   Re: Two started cluster on the same data directory and port Matthias Apitz
• 08:19   Re: Two started cluster on the same data directory and port Adrian Klaver
• 10:22   Re: Feature request for INITCAP() function Laurenz Albe
• 11:07   Re: PAF with Pacemaker Jehan-Guillaume de Rorthais
• 12:17   Re: Two started cluster on the same data directory and port Loles
• 14:52   Re: Feature request for INITCAP() function Daniel Verite
• 17:13   Re: libpq crashing on macOS during connection startup John DeSoi
• 18:04   Re: Query related to pg_dump write to a pipe on a windows client and with compressed format Ron Johnson
• 19:17   Re: Two started cluster on the same data directory and port Adrian Klaver
• 19:30   Re: Query related to pg_dump write to a pipe on a windows client and with compressed format Adrian Klaver
• 20:02   Re: libpq crashing on macOS during connection startup Tom Lane
• 20:24   Re: libpq crashing on macOS during connection startup John DeSoi
• 20:47   Help understand why DELETE is so slow Ping Yao
• 20:50   Re: Help understand why DELETE is so slow Christophe Pettus
• 21:19   Re: Query related to pg_dump write to a pipe on a windows client and with compressed format Tom Lane
• 22:08   Re: Understanding partial index selection Owen Nelson

4 December 2023

• 05:08   vacuum visibility relevance senor
• 05:15   Re: vacuum visibility relevance Ron Johnson
• 05:56   Re: vacuum visibility relevance Laurenz Albe
• 05:57   Re: vacuum visibility relevance David Rowley
• 18:40   Re: libpq crashing on macOS during connection startup John DeSoi
• 19:07   vacuumdb seems not to like option -j when run from crontab Ron Johnson
• 19:13   Re: vacuumdb seems not to like option -j when run from crontab Alan Hodgson
• 19:19   Re: vacuumdb seems not to like option -j when run from crontab kaido vaikla
• 19:22   Re: vacuumdb seems not to like option -j when run from crontab Ron Johnson

5 December 2023

• 00:40   Re: Help understand why DELETE is so slow Merlin Moncure
• 00:42   Re: Help understand why DELETE is so slow Ping Yao
• 00:51   Re: Help understand why DELETE is so slow Merlin Moncure
• 03:43   Re: Help understand why DELETE is so slow Tom Lane
• 20:19   Trainning and Certification roger popa
• 20:56   Re: vacuumdb seems not to like option -j when run from crontab Joshua Drake

6 December 2023

• 13:45   Delete Account Estevan Rech
• 14:27   Store PDF files in PostgreDB Priyadharshini Vellaisamy
• 15:04   Re: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function Roman Šindelář
• 15:21   PostgreSQL 12 error unrecognized configuration parameter zbx_tmp.wal_json_res Arne Henrik Segtnan
• 16:44   RE: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function Patrick FICHE
• 17:32   GIN INdex is not used with && operator for a text array index balasubramanian c r
• 17:43   Re: Store PDF files in PostgreDB Ron Johnson
• 17:55   Max effective number of CPUs that Postgresql can handle? Ron Johnson
• 17:58   Re: GIN INdex is not used with && operator for a text array index Tom Lane
• 18:09   Re: Trainning and Certification Daniel Gustafsson
• 18:15   Re: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function Tom Lane
• 19:00   Re: Delete Account Adrian Klaver
• 19:16   Re: Delete Account Estevan Rech
• 19:21   Re: PostgreSQL 12 error unrecognized configuration parameter zbx_tmp.wal_json_res Adrian Klaver
• 19:25   Re: Delete Account Adrian Klaver

7 December 2023

• 00:58   Re: Max effective number of CPUs that Postgresql can handle? Christoph Moench-Tegeder
• 01:04   Re: Trainning and Certification Hans Schou
• 01:22   Re: Trainning and Certification Daniel Gustafsson
• 02:24   Re: Trainning and Certification Adrian Klaver
• 02:25   Re: Trainning and Certification roger popa
• 06:45   Fwd: Disable autocommit inside dbeaver arun chirappurath
• 06:49   Re: Fwd: Disable autocommit inside dbeaver Rob Sargent
• 09:12   Postgresql : pg_temp & pg_toast_temp Vishwanath Kummera
• 11:00   Syntax arun chirappurath
• 11:09   Re: PostgreSQL 12 error unrecognized configuration parameter zbx_tmp.wal_json_res Arne Henrik Segtnan
• 14:14   Re: Syntax Ron Johnson
• 16:04   Re: Trainning and Certification Daniel Gustafsson
• 17:09   Re: Postgresql : pg_temp & pg_toast_temp Tom Lane
• 22:37   write a sql block which will commit if both updates are successful else it will have to be rolled back arun chirappurath
• 22:52   Re: write a sql block which will commit if both updates are successful else it will have to be rolled back David G. Johnston

8 December 2023

• 01:38   Invalid Parent Index Issue Will Not Resolve Despite Multiple Attempts To Fix Noel Jones
• 07:26   Re: Invalid Parent Index Issue Will Not Resolve Despite Multiple Attempts To Fix Laurenz Albe
• 09:16   Disable script execution in server level when updating via grids arun chirappurath
• 11:07   Re: Disable script execution in server level when updating via grids Filip Sedlak
• 18:00   Re: Invalid Parent Index Issue Will Not Resolve Despite Multiple Attempts To Fix Noel Jones
• 18:45   running \copy through perl dbi ? David Gauthier
• 18:56   Re: running \copy through perl dbi ? David G. Johnston
• 19:01   Re: running \copy through perl dbi ? Adrian Klaver
• 19:05   Re: running \copy through perl dbi ? David G. Johnston
• 21:03   Inserting into foreign table with sequences and default values peter.borissow@kartographia.com
• 21:12   Re: running \copy through perl dbi ? Vincent Veyron
• 21:31   Re: Inserting into foreign table with sequences and default values Tom Lane

9 December 2023

• 01:31   Re: Store PDF files in PostgreDB Peter J. Holzer
• 02:44   Re: Inserting into foreign table with sequences and default values peter.borissow@kartographia.com
• 04:17   Re: Inserting into foreign table with sequences and default values peter.borissow@kartographia.com
• 07:58   how can I fix my accent issues? Igniris Valdivia Baez
• 09:01   Re: how can I fix my accent issues? Laurenz Albe
• 14:13   Question on overall design veem v
• 18:41   Re: how can I fix my accent issues? Igniris Valdivia Baez
• 18:50   Re: how can I fix my accent issues? Adrian Klaver
• 18:54   Re: how can I fix my accent issues? Igniris Valdivia Baez
• 19:10   Re: Question on overall design Ron Johnson
• 19:21   Re: how can I fix my accent issues? Adrian Klaver
• 22:13   Re: Question on overall design veem v
• 22:58   Re: Question on overall design Ron Johnson
• 23:35   Re: Question on overall design veem v
• 23:57   Re: Question on overall design Ron Johnson

10 December 2023

• 16:16   Assistance Needed: Error during PostgreSQL Configuration Ayush Vatsa
• 16:45   Re: Question on overall design veem v
• 19:55   Re: Question on overall design Ron Johnson
• 20:39   Re: running \copy through perl dbi ? Vincent Veyron
• 20:41   Re: running \copy through perl dbi ? Vincent Veyron
• 21:34   Re: [EXT]Re: running \copy through perl dbi ? Johnson, Bruce E - (bjohnson)
• 23:02   Re: [EXT]Re: running \copy through perl dbi ? Adrian Klaver

11 December 2023

• 11:59   Re: Question on overall design veem v
• 12:41   Re: Question on overall design Dominique Devienne
• 13:00   Re: running \copy through perl dbi ? Chris Travers
• 14:57   Re: Assistance Needed: Error during PostgreSQL Configuration Ian Lawrence Barwick
• 17:08   Re: Question on overall design Ron Johnson
• 17:50   Re: Assistance Needed: Error during PostgreSQL Configuration Tom Lane
• 20:17   Re: Assistance Needed: Error during PostgreSQL Configuration Ayush Vatsa
• 21:54   Re: how can I fix my accent issues? Igniris Valdivia Baez
• 22:11   Re: how can I fix my accent issues? Adrian Klaver

12 December 2023

• 06:33   Re: Question on overall design Chris Travers
• 07:53   Re: Question on overall design Ron Johnson
• 12:50   Re: how can I fix my accent issues? Laurenz Albe
• 19:38   Re: Assistance Needed: Error during PostgreSQL Configuration Ron Johnson
• 19:40   Re: Assistance Needed: Error during PostgreSQL Configuration Tom Lane
• 20:55   Re: Assistance Needed: Error during PostgreSQL Configuration Ayush Vatsa
• 22:42   Re: how can I fix my accent issues? Daniel Verite
• 23:44   Re: how can I fix my accent issues? Igniris Valdivia Baez

13 December 2023

• 01:13   Check column result size in functions Marcos Pegoraro
• 01:29   Re: Check column result size in functions David G. Johnston
• 01:56   Re: how can I fix my accent issues? Laurenz Albe
• 02:04   Re: how can I fix my accent issues? Adrian Klaver
• 02:14   Re: how can I fix my accent issues? Adrian Klaver
• 03:00   Re: how can I fix my accent issues? Adrian Klaver
• 03:09   Re: how can I fix my accent issues? Igniris Valdivia Baez
• 08:19   Re: how can I fix my accent issues? Adrian Klaver
• 15:25   How to Straming replication chatch up from archive marco.ptz@tiscali.it
• 17:42   Re: how can I fix my accent issues? Igniris Valdivia Baez
• 19:11   Re: how can I fix my accent issues? Daniel Verite
• 20:29   Re: how can I fix my accent issues? Adrian Klaver

14 December 2023

• 01:07   Increased storage size of jsonb in pg15 Sean Flaherty
• 01:21   Re: Increased storage size of jsonb in pg15 Adrian Klaver
• 02:49   Re: Increased storage size of jsonb in pg15 Sean Flaherty
• 02:56   Re: Increased storage size of jsonb in pg15 Adrian Klaver
• 05:38   vacuumdb did not analyze all tables?= Ron Johnson
• 10:53   Re: How to Straming replication chatch up from archive Filip Sedlák
• 17:48   Re: Increased storage size of jsonb in pg15 Sean Flaherty
• 18:19   Re: how can I fix my accent issues? Igniris Valdivia Baez
• 19:16   Re: Increased storage size of jsonb in pg15 Adrian Klaver
• 19:46   Re: Increased storage size of jsonb in pg15 David G. Johnston
• 20:19   Re: vacuumdb did not analyze all tables?= Francisco Olarte
• 21:10   Re: vacuumdb did not analyze all tables?= Ron Johnson

15 December 2023

• 03:46   Re: vacuumdb did not analyze all tables?= pf@pfortin.com
• 03:50   Re: vacuumdb did not analyze all tables?= David G. Johnston
• 04:56   Re: vacuumdb did not analyze all tables?= Ron Johnson
• 23:43   Re: Increased storage size of jsonb in pg15 Sean Flaherty
• 23:56   Re: Increased storage size of jsonb in pg15 Adrian Klaver

18 December 2023

• 01:13   Postgresql 15 client arm64 and Qt 5.15 Piergiorgio Valli
• 01:30   Re: Postgresql 15 client arm64 and Qt 5.15 Tom Lane
• 03:02   Re: Postgresql 15 client arm64 and Qt 5.15 Ron Johnson
• 03:17   Re: Postgresql 15 client arm64 and Qt 5.15 Tom Lane
• 04:04   Re: Postgresql 15 client arm64 and Qt 5.15 Adrian Klaver
• 19:36   Re: Postgresql 15 client arm64 and Qt 5.15 Piergiorgio Valli

19 December 2023

• 09:36   Read write performance check veem v
• 10:27   Re: Read write performance check Ilya Kosmodemiansky
• 15:39   psql crash with custom build on RedHat 7 Dominique Devienne
• 16:01   Re: psql crash with custom build on RedHat 7 Thomas Munro
• 18:00   Re: psql crash with custom build on RedHat 7 Tom Lane
• 18:41   Re: psql crash with custom build on RedHat 7 Dominique Devienne
• 21:58   Re: psql crash with custom build on RedHat 7 Thomas Munro
• 22:14   Re: Read write performance check veem v
• 23:35   Re: Read write performance check Rob Sargent

20 December 2023

• 00:12   Re: Read write performance check Peter J. Holzer
• 07:49   Re: Read write performance check veem v
• 08:03   Re: Read write performance check Lok P
• 08:09   Re: Read write performance check veem v
• 08:30   Re: pgBackRest for a 50 TB database Abhishek Bhola
• 13:49   Re: psql crash with custom build on RedHat 7 Dominique Devienne

21 December 2023

• 09:06   How to generate random bigint Phillip Diffley
• 09:20   Re: How to generate random bigint Tom Lane
• 09:50   Re: How to generate random bigint Thomas Munro
• 11:28   Building Extension on Linux fails with relocation error Binaek Sarkar
• 13:36   Re: "invalid contrecord" error on replica Adrien Nayrat
• 14:05   Help understanding server-side logging (and more...) Dominique Devienne
• 14:55   Re: Help understanding server-side logging (and more...) Julien Rouhaud
• 15:14   Re: How to generate random bigint Peter J. Holzer
• 15:25   Re: Help understanding server-side logging (and more...) Peter J. Holzer
• 15:32   PostgreSQL 15.5 stops processing user queries Andrey Zhidenkov
• 16:30   Re: Read write performance check veem v
• 16:47   Changing a schema's name with function1 calling function2 Wilma Wantren
• 18:32   Re: PostgreSQL 15.5 stops processing user queries Tom Lane
• 19:00   Unlogged partitionned tables and hot standbys Phil Florent
• 19:13   Re: Help understanding server-side logging (and more...) Adrian Klaver
• 19:30   Re: Changing a schema's name with function1 calling function2 Adrian Klaver

22 December 2023

• 02:53   what do you do after pg_walreset ? Johnathan Tiamoh
• 11:55   Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304" Kouber Saparev
• 15:10   Re: what do you do after pg_walreset ? Laurenz Albe
• 16:44   Re: Read write performance check Lok P
• 18:15   Re: what do you do after pg_walreset ? Johnathan Tiamoh
• 18:31   Re: Building Extension on Linux fails with relocation error Tom Lane
• 19:52   Re: Building Extension on Linux fails with relocation error Peter J. Holzer
• 20:29   Re: Building Extension on Linux fails with relocation error Tom Lane

23 December 2023

• 02:09   Re: Re: Changing a schema's name with function1 calling function2 Wilma Wantren
• 03:09   Re: Changing a schema's name with function1 calling function2 Adrian Klaver
• 03:36   Re: How to generate random bigint Phillip Diffley
• 05:19   Re: How to generate random bigint Junwang Zhao
• 09:48   Unable to start postgresql-14 Johnathan Tiamoh
• 17:52   Version 16.x search_path behavior change? Dennis
• 19:12   Re: Re: Changing a schema's name with function1 calling function2 Wilma Wantren
• 19:31   Re: Changing a schema's name with function1 calling function2 Adrian Klaver
• 19:35   Re: Unable to start postgresql-14 Adrian Klaver
• 21:05   Re: Unable to start postgresql-14 Johnathan Tiamoh

24 December 2023

• 01:35   Re: Unable to start postgresql-14 Adrian Klaver
• 04:36   Re: Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304" Michael Paquier
• 18:43   Re: Version 16.x search_path behavior change? Tom Lane
• 19:03   Re: Unable to start postgresql-14 Johnathan Tiamoh
• 19:27   Re: Unable to start postgresql-14 Adrian Klaver
• 19:28   Re: Unable to start postgresql-14 Ron Johnson

25 December 2023

• 00:43   Re: Changing a schema's name with function1 calling function2 Peter J. Holzer
• 01:27   Re: Changing a schema's name with function1 calling function2 Adrian Klaver
• 17:37   Re: Changing a schema's name with function1 calling function2 Peter J. Holzer
• 20:29   Re: Re: Changing a schema's name with function1 calling function2 Wilma Wantren
• 21:44   Re: Changing a schema's name with function1 calling function2 Adrian Klaver
• 21:46   Re: Changing a schema's name with function1 calling function2 Christophe Pettus

26 December 2023

• 00:01   Query crash with 15.5 on debian bookworm/armv8 Clemens Eisserer
• 00:06   Re: Query crash with 15.5 on debian bookworm/armv8 Adrian Klaver
• 00:51   Re: Query crash with 15.5 on debian bookworm/armv8 Clemens Eisserer
• 00:59   Re: Query crash with 15.5 on debian bookworm/armv8 Adrian Klaver
• 01:07   Re: Query crash with 15.5 on debian bookworm/armv8 Clemens Eisserer
• 01:33   Re: Query crash with 15.5 on debian bookworm/armv8 Adrian Klaver
• 01:53   Re: Query crash with 15.5 on debian bookworm/armv8 Tom Lane
• 17:15   Logical replication stall on box type with REPLICA IDENTITY FULL due to lack of exact equality Laurence Parry
• 18:36   Intermittent Issue with WAL Segment Removal in Logical Replication Kaushik Iska
• 19:16   Re: Query crash with 15.5 on debian bookworm/armv8 Clemens Eisserer
• 23:51   ERROR: missing chunk number 0 for toast value 1563962066 in pg_toast_2619 Johnathan Tiamoh
• 23:58   Re: ERROR: missing chunk number 0 for toast value 1563962066 in pg_toast_2619 Adrian Klaver

27 December 2023

• 00:05   Re: PostgreSQL 15.5 stops processing user queries Andrey Zhidenkov
• 01:15   Re: Query crash with 15.5 on debian bookworm/armv8 Thomas Munro
• 05:02   looking for mariadb-devel to install mysql_fdw_16 in AlmaLinux 9 Michael Nolan
• 08:28   Re: looking for mariadb-devel to install mysql_fdw_16 in AlmaLinux 9 Adrian Klaver
• 09:41   Re: Changing a schema's name with function1 calling function2 Kirk Wolak
• 10:29   Re: Read write performance check Kirk Wolak
• 18:31   Re: Intermittent Issue with WAL Segment Removal in Logical Replication Kaushik Iska
• 18:40   Re: Changing a schema's name with function1 calling function2 Adrian Klaver

28 December 2023

• 14:41   Re: Query crash with 15.5 on debian bookworm/armv8 Clemens Eisserer
• 15:03   Re: Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304" Kouber Saparev
• 20:13   Re: Increased storage size of jsonb in pg15 Sean Flaherty
• 21:23   Re: Increased storage size of jsonb in pg15 Adrian Klaver
• 23:41   Re: Increased storage size of jsonb in pg15 Sean Flaherty
• 23:47   Re: Increased storage size of jsonb in pg15 Adrian Klaver

29 December 2023

• 01:24   Re: Intermittent Issue with WAL Segment Removal in Logical Replication Ron Johnson
• 13:05   Re: Increased storage size of jsonb in pg15 Junwang Zhao
• 17:02   Need help 
• 17:22   Re: Increased storage size of jsonb in pg15 Tom Lane
• 18:21   Re: Increased storage size of jsonb in pg15 Sean Flaherty
• 19:43   Re: Increased storage size of jsonb in pg15 Adrian Klaver
• 20:23   Re: Increased storage size of jsonb in pg15 Sean Flaherty
• 22:15   Re: Need help Adrian Klaver
• 22:24   Re: Need help Tom Lane

30 December 2023

• 00:16   Re: Intermittent Issue with WAL Segment Removal in Logical Replication Tomas Vondra
• 00:28   Re: Intermittent Issue with WAL Segment Removal in Logical Replication Kaushik Iska
• 03:26   Re: Intermittent Issue with WAL Segment Removal in Logical Replication Tomas Vondra
• 08:36   Re: Need help Adrian Klaver
• 19:01   Re: Re: Changing a schema's name with function1 calling function2 Wilma Wantren
• 19:29   Re: Need help Adrian Klaver
• 21:05   Re: Changing a schema's name with function1 calling function2 Adrian Klaver

31 December 2023

• 16:00   Re: Re: Changing a schema's name with function1 calling function2 Wilma Wantren