pgsql-general - December 2021

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31

Dec. 1, 2021

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

Dec. 2, 2021

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

Dec. 3, 2021

Thread Author Time
Re: Max connections reached without max connections reached James Sewell 01:29
Re: Require details that how to find user creation date in postgresql Database Sonai muthu raja M 04:05
Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11 Yi Sun 07:41
Re: Max connections reached without max connections reached 📎 Dilip Kumar 09:01
libpq: Which functions may hang due to network issues? Daniel Frey 10:37
SUM() of INTERVAL type produces INTERVAL with no precision Sebastien Flaesch 11:05
Re: Require details that how to find user creation date in postgresql Database Achilleas Mantzios 12:35
Re: SUM() of INTERVAL type produces INTERVAL with no precision Tom Lane 15:15
Re: Max connections reached without max connections reached Tom Lane 15:32
Re: libpq: Which functions may hang due to network issues? Laurenz Albe 16:00
Re: SUM() of INTERVAL type produces INTERVAL with no precision Sebastien Flaesch 16:08
Re: SUM() of INTERVAL type produces INTERVAL with no precision Sebastien Flaesch 16:12
Re: libpq: Which functions may hang due to network issues? Daniel Frey 16:25
Re: SUM() of INTERVAL type produces INTERVAL with no precision Adrian Klaver 16:30
Re: Max connections reached without max connections reached Dmitry Dolgov 16:31
Re: SUM() of INTERVAL type produces INTERVAL with no precision Sebastien Flaesch 16:45
Re: libpq: Which functions may hang due to network issues? Tom Lane 17:14
Insert binary file into bytea where PG server does not have access to the file ? David Gauthier 20:13
Re: libpq: Which functions may hang due to network issues? Daniel Frey 20:33
Re: Insert binary file into bytea where PG server does not have access to the file ? Adrian Klaver 20:37
Re: Insert binary file into bytea where PG server does not have access to the file ? Adrian Klaver 21:05

Dec. 4, 2021

Thread Author Time
Handling memory contexts in aggregate function invoking other built-in aggregate functions Matt Magoffin 05:14
Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions Tom Lane 16:16
Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions Matt Magoffin 17:56
Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions Tom Lane 20:04
Re: libpq: Which functions may hang due to network issues? Laurenz Albe 21:43
Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions Matt Magoffin 21:55

Dec. 5, 2021

Thread Author Time
Re: Max connections reached without max connections reached Dilip Kumar 05:25
Re: libpq: Which functions may hang due to network issues? Daniel Frey 10:23
Re: Max connections reached without max connections reached 📎 Dilip Kumar 13:26
Re: libpq: Which functions may hang due to network issues? Tom Lane 16:01
Re: libpq: Which functions may hang due to network issues? Daniel Frey 20:32

Dec. 6, 2021

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

Dec. 7, 2021

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

Dec. 8, 2021

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

Dec. 9, 2021

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

Dec. 10, 2021

Thread Author Time
Need to know more about pg_test_fsync utility PGSQL DBA 02:19
request to support "conflict on(col1 or col2) do update xxx" feature sai 02:21
Re: Need to know more about pg_test_fsync utility Thomas Munro 02:56
Postgresql + containerization possible use case Achilleas Mantzios 09:24
What is the best way to redefine a trigger? (lock issue) 📎 Marc Mamin 09:27
Re: What is the best way to redefine a trigger? (lock issue) Achilleas Mantzios 10:02
RE: What is the best way to redefine a trigger? (lock issue) 📎 Marc Mamin 10:20
Re: What is the best way to redefine a trigger? (lock issue) Achilleas Mantzios 10:35
RE: What is the best way to redefine a trigger? (lock issue) Marc Mamin 10:56
Re: What is the best way to redefine a trigger? (lock issue) Achilleas Mantzios 11:02
Re: Postgresql + containerization possible use case o1bigtenor 11:24
Re: Postgresql + containerization possible use case Achilleas Mantzios 12:01
Re: Postgresql + containerization possible use case o1bigtenor 14:02
Re: Postgresql + containerization possible use case Adrian Klaver 16:01
RE: [EXTERNAL] Re: performance expectations for table(s) with 2B recs Godfrin, Philippe E 18:04
Re: Postgresql + containerization possible use case Michael Lewis 20:06
Re: Postgresql + containerization possible use case Adrian Klaver 21:28
Re: [EXTERNAL] Re: performance expectations for table(s) with 2B recs Peter J. Holzer 21:43
Re: CTE Materialization Richard Michael 23:51

Dec. 11, 2021

Thread Author Time
Difference in execution plans pg12 vs pg14 📎 Дмитрий Иванов 01:00
Re: Difference in execution plans pg12 vs pg14 Adrian Klaver 01:13
Re: Difference in execution plans pg12 vs pg14 Дмитрий Иванов 01:51
Re: Difference in execution plans pg12 vs pg14 Adrian Klaver 01:59
PostgreSQL 14 Slaves setup - Question about WAL Files recovery Lucas 02:23
Re: Difference in execution plans pg12 vs pg14 Дмитрий Иванов 02:33
Re: Difference in execution plans pg12 vs pg14 Imre Samu 04:12
Re: Difference in execution plans pg12 vs pg14 📎 Дмитрий Иванов 09:32
Re: Difference in execution plans pg12 vs pg14 Peter J. Holzer 11:18
Re: Difference in execution plans pg12 vs pg14 Дмитрий Иванов 12:56
Re: Postgresql + containerization possible use case Michael Lewis 16:31

Dec. 12, 2021

Thread Author Time
Re: Advice on using materialized views Wicher 12:11

Dec. 13, 2021

Thread Author Time
Re: Need to know more about pg_test_fsync utility 📎 PGSQL DBA 02:04

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31