Mailing lists [pgsql-general]

1 December 2021

• 00:04   Re: Issues cross-compiling libpq 14.x to MacOS armv8 Tom Lane
• 00:33   Re: Issues cross-compiling libpq 14.x to MacOS armv8 Tom Lane
• 00:43   Re: Issues cross-compiling libpq 14.x to MacOS armv8 Daniel Gustafsson
• 01:08   Re: Issues cross-compiling libpq 14.x to MacOS armv8 Tom Lane
• 01:53   Re: How to reveal the codes of functions properly? David G. Johnston
• 02:46   Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11 Yi Sun
• 03:17   Re: Wildcarding json keys in json query David G. Johnston
• 06:08   Re: Database Scalability Saurav Sarkar
• 06:52   Re: Database Scalability Mladen Gogala
• 07:18   Re: Database Scalability Michael Stephenson
• 08:28   Re: [EXT] Re: XQuery/XPath 2.0+ support Garfield Lewis
• 08:38   Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11 Kyotaro Horiguchi
• 08:44   Re: [EXT] Re: XQuery/XPath 2.0+ support Pavel Stehule
• 09:11   Re: Issues cross-compiling libpq 14.x to MacOS armv8 Peter Eisentraut
• 10:50   RE: Wildcarding json keys in json query Patrick FICHE
• 10:50   Re: case insensitive collation of Greek's sigma Frank Limpert
• 11:50   Re: Max connections reached without max connections reached Dilip Kumar
• 11:56   Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11 Yi Sun
• 12:05   Re: Issues cross-compiling libpq 14.x to MacOS armv8 Daniel Gustafsson
• 15:12   Re: Issues cross-compiling libpq 14.x to MacOS armv8 Tom Lane
• 15:26   Re: Logical replication issue after Postgresql upgrade from 13 to 14 Marcos Pegoraro
• 15:30   Re: Logical replication issue after Postgresql upgrade from 13 to 14 Sergey Belyashov
• 15:42   Linux: directory change .../lib to .../lib64 Matthias Apitz
• 16:10   Re: Logical replication issue after Postgresql upgrade from 13 to 14 Amit Kapila
• 16:11   Re: Linux: directory change .../lib to .../lib64 Tom Lane
• 16:45   Re: Linux: directory change .../lib to .../lib64 Matthias Apitz
• 17:14   Re: Linux: directory change .../lib to .../lib64 Matthias Apitz
• 17:28   Re: Linux: directory change .../lib to .../lib64 Ron
• 17:32   Re: Database Scalability Ben Chobot
• 17:53   Re: Database Scalability Ben Chobot
• 19:10   Re: Linux: directory change .../lib to .../lib64 Tom Lane
• 21:22   Re: Database Scalability SQL Padawan
• 21:37   Pgcrypto extension - decrypt(encrypt(... not returning original data? SQL Padawan
• 21:51   Re: Pgcrypto extension - decrypt(encrypt(... not returning original data? Wim Bertels
• 21:51   Re: Pgcrypto extension - decrypt(encrypt(... not returning original data? Tom Lane
• 22:20   INSERT ... ON CONFLICT doesn't work Jenda Krynicky
• 22:29   Re: case insensitive collation of Greek's sigma Peter Eisentraut
• 22:31   Re: INSERT ... ON CONFLICT doesn't work Adrian Klaver
• 22:35   Re: INSERT ... ON CONFLICT doesn't work David G. Johnston
• 22:43   Re: INSERT ... ON CONFLICT doesn't work Jenda Krynicky
• 22:43   Re: INSERT ... ON CONFLICT doesn't work Jenda Krynicky
• 22:49   Re: case insensitive collation of Greek's sigma Tom Lane
• 22:52   Re: INSERT ... ON CONFLICT doesn't work Tom Lane
• 22:54   Re: INSERT ... ON CONFLICT doesn't work David G. Johnston
• 22:59   Re: INSERT ... ON CONFLICT doesn't work David G. Johnston
• 23:04   Re: INSERT ... ON CONFLICT doesn't work David G. Johnston
• 23:04   Re: INSERT ... ON CONFLICT doesn't work Jenda Krynicky
• 23:04   Re: INSERT ... ON CONFLICT doesn't work Jenda Krynicky
• 23:15   Re: INSERT ... ON CONFLICT doesn't work Tom Lane
• 23:19   Re: INSERT ... ON CONFLICT doesn't work David G. Johnston
• 23:55   Re: INSERT ... ON CONFLICT doesn't work Adrian Klaver

2 December 2021

• 00:15   Re: INSERT ... ON CONFLICT doesn't work Adrian Klaver
• 01:29   Re: Max connections reached without max connections reached James Sewell
• 01:52   Re: Max connections reached without max connections reached Rob Sargent
• 03:28   Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11 Kyotaro Horiguchi
• 05:08   Re: Max connections reached without max connections reached Michael Lewis
• 06:31   Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11 Yi Sun
• 06:54   Re: Max connections reached without max connections reached Rob Sargent
• 07:05   Re: Max connections reached without max connections reached Dilip Kumar
• 07:07   Re: Max connections reached without max connections reached Michael Lewis
• 07:10   Re: Max connections reached without max connections reached Michael Lewis
• 07:20   Re: INSERT ... ON CONFLICT doesn't work Michael Lewis
• 07:46   Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11 Kyotaro Horiguchi
• 08:22   Re: INSERT ... ON CONFLICT doesn't work Adrian Klaver
• 12:51   Re: Require details that how to find user creation date in postgresql Database Sonai muthu raja M
• 13:07   Logical Replication - When to Enable Disabled Publication and When to Create a New One Avi Weinberg
• 13:11   Logical Replication - When to Enable Disabled Subscription and When to Create a New One Avi Weinberg
• 16:26   Re: case insensitive collation of Greek's sigma Jakub Jedelsky
• 17:04   Re: case insensitive collation of Greek's sigma Gianni Ceccarelli
• 19:05   pg_upgrade question Alan Stange
• 19:10   Re: pg_upgrade question Adrian Klaver
• 19:45   Re: pg_upgrade question Alan Stange
• 21:36   Re: Issues cross-compiling libpq 14.x to MacOS armv8 Vincas Dargis
• 21:56   Re: Issues cross-compiling libpq 14.x to MacOS armv8 Tom Lane
• 21:57   CTE Materialization Paul van der Linden

3 December 2021

• 01:21   Re: Require details that how to find user creation date in postgresql Database Tom Lane
• 01:22   Re: Require details that how to find user creation date in postgresql Database Adrian Klaver
• 01:34   Re: CTE Materialization David G. Johnston
• 02:20   Re: CTE Materialization Paul van der Linden
• 04:29   Re: Max connections reached without max connections reached James Sewell
• 07:05   Re: Require details that how to find user creation date in postgresql Database Sonai muthu raja M
• 10:41   Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11 Yi Sun
• 12:01   Re: Max connections reached without max connections reached Dilip Kumar
• 13:37   libpq: Which functions may hang due to network issues? Daniel Frey
• 14:05   SUM() of INTERVAL type produces INTERVAL with no precision Sebastien Flaesch
• 15:35   Re: Require details that how to find user creation date in postgresql Database Achilleas Mantzios
• 23:13   Insert binary file into bytea where PG server does not have access to the file ? David Gauthier
• 23:33   Re: libpq: Which functions may hang due to network issues? Daniel Frey
• 23:37   Re: Insert binary file into bytea where PG server does not have access to the file ? Adrian Klaver

4 December 2021

• 00:05   Re: Insert binary file into bytea where PG server does not have access to the file ? Adrian Klaver
• 08:14   Handling memory contexts in aggregate function invoking other built-in aggregate functions Matt Magoffin
• 19:16   Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions Tom Lane
• 19:16   Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions Tom Lane
• 20:56   Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions Matt Magoffin
• 20:56   Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions Matt Magoffin
• 23:04   Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions Tom Lane

5 December 2021

• 00:43   Re: libpq: Which functions may hang due to network issues? Laurenz Albe
• 00:55   Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions Matt Magoffin
• 08:25   Re: Max connections reached without max connections reached Dilip Kumar
• 13:23   Re: libpq: Which functions may hang due to network issues? Daniel Frey
• 16:26   Re: Max connections reached without max connections reached Dilip Kumar
• 19:01   Re: libpq: Which functions may hang due to network issues? Tom Lane
• 23:32   Re: libpq: Which functions may hang due to network issues? Daniel Frey

6 December 2021

• 03:40   Re: Max connections reached without max connections reached James Sewell
• 07:41   Re: Max connections reached without max connections reached Amul Sul
• 08:03   Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11 Kyotaro Horiguchi
• 08:47   Re: Max connections reached without max connections reached James Sewell
• 13:08   Re: libpq: Which functions may hang due to network issues? Daniel Frey
• 17:50   Are Foreign Key Disabled During Logical Replication Initial Sync? Avi Weinberg
• 20:03   Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Alan Hodgson
• 20:18   Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Michael Lewis
• 20:19   Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Rob Sargent
• 20:20   Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Francisco Olarte
• 20:41   Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Alan Hodgson
• 20:57   Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Alan Hodgson
• 21:02   Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Alan Hodgson
• 21:07   Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Adrian Klaver
• 21:22   Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Pavel Stehule
• 21:48   Advice on using materialized views Phil Endecott
• 22:19   Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Rob Sargent
• 23:22   Re: CTE Materialization Paul van der Linden

7 December 2021

• 06:16   Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Laurenz Albe
• 07:06   Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Mladen Gogala
• 08:18   Re: Are Foreign Key Disabled During Logical Replication Initial Sync? Peter Eisentraut
• 10:07   Re: Advice on using materialized views Nick Cleaton
• 10:51   RE: Are Foreign Key Disabled During Logical Replication Initial Sync? Avi Weinberg
• 12:15   When Update balloons memory Klaudie Willis
• 12:32   Re: Advice on using materialized views Wicher
• 15:16   how to get value of parameter set in session for other user Vikas Sharma
• 15:34   Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT Francisco Olarte
• 15:40   Re: When Update balloons memory Francisco Olarte
• 17:45   Re: how to get value of parameter set in session for other user Tom Lane
• 17:57   Re: When Update balloons memory Tom Lane
• 19:10   error connecting to pgbouncer admin console Zwettler Markus (OIZ)

8 December 2021

• 01:39   Working with fixed-point calculations in C Oskar Stenberg
• 04:39   Re: CTE Materialization Дмитрий Иванов
• 05:14   Re: CTE Materialization David G. Johnston
• 06:41   Re: Working with fixed-point calculations in C Tom Lane
• 13:25   Re: how to get value of parameter set in session for other user Vikas Sharma
• 13:43   Re: Are Foreign Key Disabled During Logical Replication Initial Sync? Peter Eisentraut
• 13:49   Re: error connecting to pgbouncer admin console Peter Eisentraut
• 14:03   Re: Working with fixed-point calculations in C Peter J. Holzer
• 15:07   How to allow null as an option when using regexp_matches? Shaozhong SHI
• 15:09   Re: How to allow null as an option when using regexp_matches? Karsten Hilbert
• 16:59   AW: error connecting to pgbouncer admin console Zwettler Markus (OIZ)
• 17:18   RE: Working with fixed-point calculations in C Oskar Stenberg
• 20:07   Re: How to allow null as an option when using regexp_matches? Shaozhong SHI
• 20:40   Re: How to allow null as an option when using regexp_matches? Vincent Veyron
• 20:58   Re: CTE Materialization Paul van der Linden
• 20:59   Re: How to allow null as an option when using regexp_matches? Roxanne Reid-Bennett
• 22:44   performance expectations for table(s) with 2B recs David Gauthier

9 December 2021

• 01:14   Re: performance expectations for table(s) with 2B recs Peter J. Holzer
• 06:26   Re: CTE Materialization Дмитрий Иванов
• 12:13   Identity/Serial Column In Subscriber's Tables Avi Weinberg
• 14:03   Use tsquery to check out occurrence of the same phrase in a cell Shaozhong SHI
• 14:38   Re: performance expectations for table(s) with 2B recs Marc Millas
• 14:51   Re: Identity/Serial Column In Subscriber's Tables Laurenz Albe
• 15:06   help Willy Skjæveland
• 15:38   Detecting repeated phrase in a string Shaozhong SHI
• 16:35   Re: Detecting repeated phrase in a string Peter J. Holzer
• 17:19   RE: Identity/Serial Column In Subscriber's Tables Avi Weinberg
• 17:46   Re: Detecting repeated phrase in a string Shaozhong SHI
• 18:11   Re: Detecting repeated phrase in a string Andreas Joseph Krogh
• 19:06   Re: Advice on using materialized views Phil Endecott
• 22:52   Re: Detecting repeated phrase in a string Peter J. Holzer

10 December 2021

• 01:47   pqxx accumulating a transaction Jeff Abrahamson
• 05:19   Need to know more about pg_test_fsync utility PGSQL DBA
• 05:21   request to support "conflict on(col1 or col2) do update xxx" feature sai
• 05:56   Re: Need to know more about pg_test_fsync utility Thomas Munro
• 12:24   Postgresql + containerization possible use case Achilleas Mantzios
• 12:27   What is the best way to redefine a trigger? (lock issue) Marc Mamin
• 13:02   Re: What is the best way to redefine a trigger? (lock issue) Achilleas Mantzios
• 13:20   RE: What is the best way to redefine a trigger? (lock issue) Marc Mamin
• 13:35   Re: What is the best way to redefine a trigger? (lock issue) Achilleas Mantzios
• 13:56   RE: What is the best way to redefine a trigger? (lock issue) Marc Mamin
• 14:02   Re: What is the best way to redefine a trigger? (lock issue) Achilleas Mantzios
• 14:24   Re: Postgresql + containerization possible use case o1bigtenor
• 15:01   Re: Postgresql + containerization possible use case Achilleas Mantzios
• 17:02   Re: Postgresql + containerization possible use case o1bigtenor
• 19:01   Re: Postgresql + containerization possible use case Adrian Klaver
• 21:04   RE: [EXTERNAL] Re: performance expectations for table(s) with 2B recs Godfrin, Philippe E
• 23:06   Re: Postgresql + containerization possible use case Michael Lewis

11 December 2021

• 00:28   Re: Postgresql + containerization possible use case Adrian Klaver
• 00:43   Re: [EXTERNAL] Re: performance expectations for table(s) with 2B recs Peter J. Holzer
• 02:51   Re: CTE Materialization Richard Michael
• 04:00   Difference in execution plans pg12 vs pg14 Дмитрий Иванов
• 04:13   Re: Difference in execution plans pg12 vs pg14 Adrian Klaver
• 04:51   Re: Difference in execution plans pg12 vs pg14 Дмитрий Иванов
• 04:59   Re: Difference in execution plans pg12 vs pg14 Adrian Klaver
• 05:23   PostgreSQL 14 Slaves setup - Question about WAL Files recovery Lucas
• 05:33   Re: Difference in execution plans pg12 vs pg14 Дмитрий Иванов
• 07:12   Re: Difference in execution plans pg12 vs pg14 Imre Samu
• 12:32   Re: Difference in execution plans pg12 vs pg14 Дмитрий Иванов
• 14:18   Re: Difference in execution plans pg12 vs pg14 Peter J. Holzer
• 15:56   Re: Difference in execution plans pg12 vs pg14 Дмитрий Иванов
• 19:31   Re: Postgresql + containerization possible use case Michael Lewis

12 December 2021

• 15:11   Re: Advice on using materialized views Wicher

13 December 2021

• 05:04   Re: Need to know more about pg_test_fsync utility PGSQL DBA
• 05:45   Re: Need to know more about pg_test_fsync utility Thomas Munro
• 09:52   Re: Need to know more about pg_test_fsync utility PGSQL DBA
• 11:06   Re: Postgresql + containerization possible use case Achilleas Mantzios
• 11:09   Re: Postgresql + containerization possible use case Achilleas Mantzios
• 11:17   Re: Postgresql + containerization possible use case Achilleas Mantzios
• 11:29   Re: Postgresql + containerization possible use case Achilleas Mantzios
• 11:46   LibPQ: Lifetime of PGresult passed in to PQnoticeReceiver callback Dominique Devienne
• 12:50   Re: Postgresql + containerization possible use case Rainer Duffner
• 14:41   Re: Postgresql + containerization possible use case Achilleas Mantzios
• 17:34   Where can I follow the progress of "Pluggable Storage" development? Jean Baro
• 18:11   Re: Postgresql + containerization possible use case Rainer Duffner
• 18:55   Re: Postgresql + containerization possible use case Adrian Klaver
• 19:03   Re: Postgresql + containerization possible use case Achilleas Mantzios
• 19:11   Re: Postgresql + containerization possible use case Benedict Holland
• 19:22   Re: Postgresql + containerization possible use case Achilleas Mantzios
• 19:23   Re: Postgresql + containerization possible use case Achilleas Mantzios
• 19:25   Re: Postgresql + containerization possible use case Achilleas Mantzios
• 19:34   RE: [EXTERNAL] Re: performance expectations for table(s) with 2B recs Godfrin, Philippe E
• 20:22   Error : /usr/local/share/lua/5.1/pgmoon/init.lua:211: don’t know how to auth: 10 Kaushal Shriyan
• 20:29   Re: Error : /usr/local/share/lua/5.1/pgmoon/init.lua:211: don’t know how to auth: 10 Tom Lane
• 22:19   Re: Where can I follow the progress of "Pluggable Storage" development? Fabrízio de Royes Mello
• 22:37   Re: Where can I follow the progress of "Pluggable Storage" development? Jean Baro
• 23:45   Why can't I have a "language sql" anonymous block? Bryn Llewellyn
• 23:53   Re: Why can't I have a "language sql" anonymous block? Tom Lane

14 December 2021

• 00:12   Properly handling aggregate in nested function call Matt Magoffin
• 00:15   Re: Why can't I have a "language sql" anonymous block? Bryn Llewellyn
• 02:07   Re: When Update balloons memory Klaudie Willis
• 02:17   Re: When Update balloons memory Tom Lane
• 02:31   Re: Why can't I have a "language sql" anonymous block? Adrian Klaver
• 07:14   locks within select Marc Millas
• 07:25   log shipping with pg_receivewal Marc Millas
• 08:38   Re: log shipping with pg_receivewal Michael Paquier
• 08:40   Re: log shipping with pg_receivewal Dilip Kumar
• 09:29   Re: locks within select David G. Johnston
• 11:16   Re: When Update balloons memory Klaudie Willis
• 12:39   Re: LibPQ: Lifetime of PGresult passed in to PQnoticeReceiver callback Dominique Devienne
• 13:28   Re: LibPQ: Lifetime of PGresult passed in to PQnoticeReceiver callback Dmitry Igrishin
• 15:00    Dennis
• 15:05   Re: Amul Sul
• 15:38   Re: locks within select Marc Millas
• 16:20   Re: locks within select David G. Johnston
• 18:36   timestamp default current_timestamp not working Sanjay Minni
• 18:47   Re: timestamp default current_timestamp not working Ron
• 18:50   Re: timestamp default current_timestamp not working Adrian Klaver
• 18:58   Re: When Update balloons memory Vincent Veyron
• 19:00   Re: timestamp default current_timestamp not working Sanjay Minni
• 19:06   Re: timestamp default current_timestamp not working Ron
• 19:08   Re: timestamp default current_timestamp not working David G. Johnston
• 19:10   Re: timestamp default current_timestamp not working Adrian Klaver
• 19:16   Re: When Update balloons memory Klaudie Willis
• 19:18   Re: When Update balloons memory Tom Lane
• 20:14   Re: locks within select Laurenz Albe
• 21:04   Postgresql DB on virtual machine in Ceph cluster Poul Kristensen
• 21:41   Re: When Update balloons memory Vincent Veyron
• 22:22   Re: locks within select Marc Millas
• 22:30   Re: Why can't I have a "language sql" anonymous block? Bryn Llewellyn
• 23:47   Re: Why can't I have a "language sql" anonymous block? Adrian Klaver

15 December 2021

• 01:51   Re: Properly handling aggregate in nested function call Tom Lane
• 01:58   Re: Why can't I have a "language sql" anonymous block? David G. Johnston
• 03:08   Re: Why can't I have a "language sql" anonymous block? Bryn Llewellyn
• 06:15   Reindex "locked" standby database Martín Fernández
• 06:37   Re: Reindex "locked" standby database Michael Paquier
• 06:52   Re: Reindex "locked" standby database Mladen Gogala
• 07:10   Re: Reindex "locked" standby database Martín Fernández
• 07:20   Re: Reindex "locked" standby database Martín Fernández
• 20:45   Best Strategy for Large Number of Images Estevan Rech
• 20:50   Re: Best Strategy for Large Number of Images Rob Sargent
• 20:56   Re: Best Strategy for Large Number of Images Estevan Rech
• 20:59   Re: Best Strategy for Large Number of Images David G. Johnston
• 21:17   Re: Best Strategy for Large Number of Images Estevan Rech
• 21:23   Re: Best Strategy for Large Number of Images Adrian Klaver
• 21:48   Re: Best Strategy for Large Number of Images Estevan Rech
• 21:52   Re: Best Strategy for Large Number of Images Adrian Klaver
• 21:57   Re: Best Strategy for Large Number of Images David G. Johnston
• 22:22   Re: Best Strategy for Large Number of Images Estevan Rech
• 22:23   Re: Best Strategy for Large Number of Images Ron
• 22:24   Re: Best Strategy for Large Number of Images Rob Sargent
• 22:37   Re: Best Strategy for Large Number of Images Adrian Klaver
• 23:12   Re: Best Strategy for Large Number of Images Estevan Rech

16 December 2021

• 00:05   Re: Why can't I have a "language sql" anonymous block? Bryn Llewellyn
• 00:14   Re: Best Strategy for Large Number of Images Gavan Schneider
• 00:19   Re: Best Strategy for Large Number of Images Marc Millas
• 00:37   Re: Why can't I have a "language sql" anonymous block? Adrian Klaver
• 00:41   Re: Best Strategy for Large Number of Images Bruce Momjian
• 00:47   Re: Best Strategy for Large Number of Images Benedict Holland
• 01:11   Re: Best Strategy for Large Number of Images Bèrto ëd Sèra
• 01:14   Re: Properly handling aggregate in nested function call Matt Magoffin
• 01:31   Re: Why can't I have a "language sql" anonymous block? David G. Johnston
• 01:51   Re: Best Strategy for Large Number of Images David G. Johnston
• 01:54   Re: Properly handling aggregate in nested function call Matt Magoffin
• 02:18   Re: Why can't I have a "language sql" anonymous block? Bryn Llewellyn
• 02:31   Re: Why can't I have a "language sql" anonymous block? Bryn Llewellyn
• 02:45   Re: Why can't I have a "language sql" anonymous block? David G. Johnston
• 04:43   Re: Properly handling aggregate in nested function call Tom Lane
• 04:50   Re: Best Strategy for Large Number of Images Дмитрий Иванов
• 05:11   Re: Properly handling aggregate in nested function call Matt Magoffin
• 14:00   SELECT DISTINCT scans the table? Markus Demleitner
• 22:21   Re: Why can't I have a "language sql" anonymous block? Bryn Llewellyn
• 22:22   Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn
• 22:42   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Adrian Klaver
• 23:21   How to ensure column names are double quoted while using execute format when building a stored procedure? Shaozhong SHI
• 23:24   Re: How to ensure column names are double quoted while using execute format when building a stored procedure? David G. Johnston
• 23:36   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn
• 23:47   Re: SELECT DISTINCT scans the table? Tom Lane

17 December 2021

• 00:05   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Adrian Klaver
• 00:07   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Peter Geoghegan
• 00:11   Re: How to ensure column names are double quoted while using execute format when building a stored procedure? Shaozhong SHI
• 00:25   Re: How to ensure column names are double quoted while using execute format when building a stored procedure? David G. Johnston
• 00:33   Re: How to ensure column names are double quoted while using execute format when building a stored procedure? Shaozhong SHI
• 00:37   Re: How to ensure column names are double quoted while using execute format when building a stored procedure? David G. Johnston
• 00:48   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Pavel Stehule
• 01:04   Re: How to ensure column names are double quoted while using execute format when building a stored procedure? Adrian Klaver
• 01:11   Re: How to ensure column names are double quoted while using execute format when building a stored procedure? David G. Johnston
• 01:15   Re: How to ensure column names are double quoted while using execute format when building a stored procedure? Adrian Klaver
• 05:38   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Mladen Gogala
• 05:52   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Peter Geoghegan
• 07:08   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Pavel Stehule
• 10:27   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Laurenz Albe
• 12:19   Re: SELECT DISTINCT scans the table? Markus Demleitner
• 22:13   Reg. static SQL code analysis tool for PostgreSQL holistic.dev
• 22:43   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn

18 December 2021

• 02:05   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Peter Geoghegan
• 02:53   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn

19 December 2021

• 14:50   PGBouncer logs explanation required Shubham Mittal
• 17:24   RE: Best Strategy for Large Number of Images Zahir Lalani

20 December 2021

• 12:35   md5 issues Postgres14 on OL7 Michael Mühlbeyer
• 13:29   Re: Best Strategy for Large Number of Images Estevan Rech
• 13:44   Re: Best Strategy for Large Number of Images Andreas Joseph Krogh
• 14:32   Re: Best Strategy for Large Number of Images Imre Samu
• 15:30   How to reduce query planning time (10s) iulian dragos
• 15:42   Re: How to reduce query planning time (10s) Pavel Stehule
• 16:45   Update concurrency Sylvain Déve
• 16:52   Re: Update concurrency David G. Johnston
• 17:22   Re: md5 issues Postgres14 on OL7 Christoph Moench-Tegeder
• 18:07   Re: Update concurrency Tom Lane
• 19:38   Re: Update concurrency Tom Lane
• 19:50   Re: How to reduce query planning time (10s) iulian dragos
• 19:53   Re: How to reduce query planning time (10s) Pavel Stehule
• 20:04   Re: How to reduce query planning time (10s) Tom Lane
• 22:28   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn
• 22:37   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Pavel Stehule
• 23:26   Freeing transient memory in aggregate functions Matt Magoffin

21 December 2021

• 00:07   Re: PGBouncer logs explanation required Peter Eisentraut
• 00:25   Re: Freeing transient memory in aggregate functions Tom Lane
• 01:10   How best to turn select result into options like 'a|b|c'' Shaozhong SHI
• 01:23   Re: How best to turn select result into options like 'a|b|c'' Ray O'Donnell
• 01:37   Re: How best to turn select result into options like 'a|b|c'' David G. Johnston
• 03:22   Re: Max connections reached without max connections reached James Sewell
• 03:25   Re: Max connections reached without max connections reached James Sewell
• 08:09   Sorting difference in version 10 vs 13 Akheel Ahmed
• 08:12   Re: Sorting difference in version 10 vs 13 Tom Lane
• 08:31   Re: Sorting difference in version 10 vs 13 Akheel Ahmed
• 09:35   Re: Sorting difference in version 10 vs 13 Ron

23 December 2021

• 13:14   Re: How to confirm the pg_hba.conf service is correctly working shing dong
• 14:25   Re: How to confirm the pg_hba.conf service is correctly working Imre Samu
• 16:32   Re: How to confirm the pg_hba.conf service is correctly working Vijaykumar Jain
• 18:02   Re: storing zipped SQLite inside PG ? Дмитрий Иванов

24 December 2021

• 00:05   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn
• 08:35   Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Pavel Stehule

25 December 2021

• 11:04   restore-command error handling Sebastiaan Mannem

26 December 2021

• 15:09   Wal files in /pgsql/14/main/pg_wal not removed Lucas
• 15:43   Re: storing zipped SQLite inside PG ? amihay gonen
• 19:14   Re: Wal files in /pgsql/14/main/pg_wal not removed Tom Lane

27 December 2021

• 02:09   Re: Wal files in /pgsql/14/main/pg_wal not removed Lucas
• 11:55   Deprecating plans for PGPASSWORD environment variable as insecure Alexey Murz Korepov
• 12:03   Re: Deprecating plans for PGPASSWORD environment variable as insecure Pavel Stehule
• 16:35   Logical Replication - One table 8 minutes, Identical Two Tables 28 Minutes (Expected 16 Minutes) Avi Weinberg

28 December 2021

• 15:29   psql command failing with error "undefined symbol: PQhostaddr" Narendra katlamudi
• 15:44   Re: psql command failing with error "undefined symbol: PQhostaddr" Osvaldo Kussama
• 15:52   Re: psql command failing with error "undefined symbol: PQhostaddr" Pavel Stehule
• 18:54   Re: psql command failing with error "undefined symbol: PQhostaddr" Adrian Klaver

29 December 2021

• 11:31   Re: psql command failing with error "undefined symbol: PQhostaddr" Narendra katlamudi
• 15:39   Initial Sync - One Subscriber After The Other vs. Parallel Avi Weinberg
• 20:43   Find missing data in a column john polo
• 20:54   Find missing data in a column David G. Johnston
• 20:56   Re: Find missing data in a column Adrian Klaver
• 21:07   Re: Find missing data in a column Adrian Klaver
• 21:10   Re: Find missing data in a column Rob Sargent
• 21:16   Re: Find missing data in a column Adrian Klaver
• 21:36   Re: Find missing data in a column Alan Hodgson

30 December 2021

• 00:08   csv copy error ourdiaspora
• 00:15   Re: csv copy error Adrian Klaver
• 00:46   Re: csv copy error David G. Johnston
• 01:59   Default values in functions Michael Lewis
• 02:31   Re: Default values in functions Tom Lane
• 02:34   Re: Default values in functions David G. Johnston
• 03:17   Re: Default values in functions Michael Lewis
• 03:22   Re: Default values in functions Michael Lewis
• 03:28   Re: Default values in functions Tom Lane
• 03:31   Re: Default values in functions Tom Lane
• 03:46   Re: Default values in functions Michael Lewis
• 05:09   Re: Find missing data in a column john polo
• 10:09   pg_config header files are missing - Postgres 13 - Amazon Linux 2 Hasan Marzooq
• 10:30   Re: csv copy error Guillaume Lelarge
• 12:48   Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 Magnus Hagander

31 December 2021

• 05:32   Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 Hasan Marzooq
• 13:03   Re: csv copy error ourdiaspora
• 16:12   create query with date values ourdiaspora
• 18:34   Re: create query with date values Ron
• 19:24   Re: create query with date values David G. Johnston
• 23:27   a very naive question about table names in Postgres Martin Mueller
• 23:36   Re: a very naive question about table names in Postgres Craig McIlwee
• 23:40   Re: a very naive question about table names in Postgres Gavin Flower
• 23:41   Re: a very naive question about table names in Postgres Craig McIlwee