pgsql-general - June 2023

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)

Browse Archives

Prev | Next

June 1, 2023

Thread Author Time
RE: Support logical replication of DDLs Yu Shi (Fujitsu) 02:12
Re: speed up full table scan using psql Adrian Klaver 04:16
Re: speed up full table scan using psql Lian Jiang 05:51
RE: Support logical replication of DDLs Yu Shi (Fujitsu) 07:39
Dynamic creation of list partitions in highly concurrent write environment Jim Vanns 10:14
Re: Hash Index on Partitioned Table Marc Millas 10:42
Re: Dynamic creation of list partitions in highly concurrent write environment Tom Lane 13:32
Re: Dynamic creation of list partitions in highly concurrent write environment Jim Vanns 13:45
Re: speed up full table scan using psql Adrian Klaver 15:03
Re: Support logical replication of DDLs 📎 vignesh C 15:42
Re: Adding SHOW CREATE TABLE Kirk Wolak 16:57
Re: Adding SHOW CREATE TABLE Andrew Dunstan 19:13
Re: Adding SHOW CREATE TABLE Kirk Wolak 20:39
Re: Adding SHOW CREATE TABLE Andrew Dunstan 20:46

June 2, 2023

Thread Author Time
[Beginner Question]A question about yacc & lex Wen Yi 00:47
Re: [Beginner Question]A question about yacc & lex Tom Lane 12:07
Re: Pg 16: will pg_dump & pg_restore be faster? Jonathan S. Katz 12:14
Interconnected views Oliver Kohll 13:36
Re: Adding SHOW CREATE TABLE Kirk Wolak 14:57
Re: Interconnected views Chris Travers 17:58
custom background worker task for \copy? Joe Carlson 18:36
Re: Interconnected views Guillermo González de Agüero 18:46

June 3, 2023

Thread Author Time
pg_upgrade and schema complexity... Ron 00:44
Re: pg_upgrade and schema complexity... Adrian Klaver 00:58
Re: pg_upgrade and schema complexity... Ron 01:06
Re: pg_upgrade and schema complexity... Christophe Pettus 01:08
Re: pg_upgrade and schema complexity... Adrian Klaver 02:22
Re: custom background worker task for \copy? Laurenz Albe 04:41
How to remove user specific grant and revoke Andrus 07:16
No Greek stop words in FTS ? Florents Tselai 08:24
Number of dashes in the expanded view of psql 📎 Rajiv Harlalka 10:12
Re: How to remove user specific grant and revoke Erik Wienhold 12:46
Re: How to remove user specific grant and revoke Erik Wienhold 13:07
Re: pg_upgrade and schema complexity... Ron 13:51
Re: custom background worker task for \copy? Joe Carlson 14:46
Re: Number of dashes in the expanded view of psql Adrian Klaver 15:05
Re: How to remove user specific grant and revoke Andrus 16:14
Re: How to remove user specific grant and revoke Erik Wienhold 16:38
Re: How to remove user specific grant and revoke Andrus 20:33
Re: How to remove user specific grant and revoke Erik Wienhold 20:57
Re: How to remove user specific grant and revoke Andrus 21:34
Re: How to remove user specific grant and revoke Andrus 22:08

June 4, 2023

Thread Author Time
Re: How to remove user specific grant and revoke Erik Wienhold 00:36
Re: How to remove user specific grant and revoke Erik Wienhold 00:36
Connection error to new pg15 instance Steve Baldwin 01:11
Can't send mail to `[email protected]` Wen Yi 01:46
Re: Can't send mail to `[email protected]` Adrian Klaver 03:11
Re: Can't send mail to `[email protected]` Wen Yi 03:29
Re: Interconnected views Kirk Wolak 03:40
Re: Connection error to new pg15 instance Steve Baldwin 05:10
Re: How to remove user specific grant and revoke Andrus 07:00
Re: Connection error to new pg15 instance Steve Baldwin 07:23
"pgsql-zh-general" can't send chinese mail. Wen Yi 09:15
Re: "pgsql-zh-general" can't send chinese mail. postgresql439848 11:58

June 5, 2023

Thread Author Time
Re: "pgsql-zh-general" can't send chinese mail. Wen Yi 02:11
[Question]What will happen if the server active close the connection? Wen Yi 02:18
Re: Pg 16: will pg_dump & pg_restore be faster? David Rowley 04:53
Is there any good optimization solution to improve the query efficiency? gzh 06:56
Re: [Question]What will happen if the server active close the connection? Laurenz Albe 07:27
Re: Is there any good optimization solution to improve the query efficiency? Oliver Kohll 07:45
Re: Is there any good optimization solution to improve the query efficiency? Ron 07:59
Re: Is there any good optimization solution to improve the query efficiency? David Rowley 08:21
Re: Support logical replication of DDLs 📎 shveta malik 09:30
Re:Re: Is there any good optimization solution to improve the query efficiency? gzh 09:38
Re: Is there any good optimization solution to improve the query efficiency? Lorusso Domenico 09:47
Composite type: Primary Key and validation Lorusso Domenico 09:49
Re: Is there any good optimization solution to improve the query efficiency? gzh 10:06
Re: Adding SHOW CREATE TABLE 📎 Jelte Fennema 11:43
Re: Composite type: Primary Key and validation Laurenz Albe 14:02
Re: Composite type: Primary Key and validation Ron 14:17
Re: Is there any good optimization solution to improve the query efficiency? Lorusso Domenico 14:53
Re: Composite type: Primary Key and validation Lorusso Domenico 15:02
Re: Composite type: Primary Key and validation Lorusso Domenico 15:06
Re: Composite type: Primary Key and validation Adrian Klaver 15:17
Re: Composite type: Primary Key and validation Laurenz Albe 17:08
Re: Composite type: Primary Key and validation Merlin Moncure 17:41
Re: Composite type: Primary Key and validation Lorusso Domenico 18:19
Re: Composite type: Primary Key and validation Adrian Klaver 18:22
Re: Composite type: Primary Key and validation Ron 19:43

June 6, 2023

Thread Author Time
RE: Support logical replication of DDLs 📎 Wei Wang (Fujitsu) 06:01
Drivers users by connections Hrishikesh (Richie) Rode 07:18
Re: Is there any good optimization solution to improve the query efficiency? gzh 08:33
Re: Support logical replication of DDLs vignesh C 09:12
No prompt for setting up a master password Stephanie Goulet 10:55
Re: Support logical replication of DDLs Amit Kapila 10:56
Re: Drivers users by connections Erik Wienhold 11:20
vacuum to prevent wraparound Marcos Pegoraro 14:36
Re: No prompt for setting up a master password Adrian Klaver 14:50
Re: vacuum to prevent wraparound Laurenz Albe 16:52
Fwd: No prompt for setting up a master password Stephanie Goulet 17:36
Re: Is there any good optimization solution to improve the query efficiency? Lorusso Domenico 21:13

June 7, 2023

Thread Author Time
PostgreSQL Dependency tree Lucas Possamai 01:13
Re: No prompt for setting up a master password Nikhil Mohite 04:47
How to manipulate field in New record Lorusso Domenico 12:12
Re: How to manipulate field in New record hubert depesz lubaczewski 12:58
Re: How to manipulate field in New record Adrian Klaver 13:57
Re: How to manipulate field in New record Lorusso Domenico 16:46
Native Logical Replication Initial Import Qs Don Seiler 21:12
Re: Native Logical Replication Initial Import Qs Jeremy Schneider 21:30
Re: No prompt for setting up a master password Stephanie Goulet 21:35
Re: No prompt for setting up a master password richard coleman 22:15

June 8, 2023

Thread Author Time
Re: Support logical replication of DDLs Amit Kapila 05:05
Re: Support logical replication of DDLs 📎 shveta malik 12:01
Re: Support logical replication of DDLs shveta malik 12:07
Re: Support logical replication of DDLs shveta malik 12:18

June 9, 2023

Thread Author Time
Re: Support logical replication of DDLs Masahiko Sawada 00:05
How To: A large [2D] matrix, 100,000+ rows/columns Pat Trainor 02:17
Re: Support logical replication of DDLs shveta malik 03:10
Question about where to deploy the business logics for data processing Nim Li 03:21
Re: Support logical replication of DDLs Amit Kapila 05:38
How to store query result into another table using stored procedure Rama Krishnan 05:51
How to securely isolate databases/users in a multi-tenant Postgresql? Alex Lee 06:54
Re: How To: A large [2D] matrix, 100,000+ rows/columns Alban Hertroys 06:59
Re: How to store query result into another table using stored procedure Ron 09:01
Logical replication slots stuck in catchup on a very large table Mathieu Poussin 09:05
Re: Support logical replication of DDLs Ajin Cherian 09:51
Why lex & yacc think this is a syntax error? Wen Yi 09:55
Re: How to securely isolate databases/users in a multi-tenant Postgresql? Erik Wienhold 10:32
Active Active PostgreSQL Solution Mohsin Kazmi 10:38
Re: How to store query result into another table using stored procedure Erik Wienhold 10:46
Re: Active Active PostgreSQL Solution Andreas Kretschmer 12:46
Re: Active Active PostgreSQL Solution Marcos Pegoraro 13:01
Re: Active Active PostgreSQL Solution Ben Chobot 13:04
Re: How To: A large [2D] matrix, 100,000+ rows/columns Joe Conway 13:16
Re: How To: A large [2D] matrix, 100,000+ rows/columns Wim Bertels 14:00
Re: How To: A large [2D] matrix, 100,000+ rows/columns Erik Wienhold 14:12
Re: Question about where to deploy the business logics for data processing Rob Sargent 15:06
Re: Question about where to deploy the business logics for data processing Michael Nolan 15:46
Re: Question about where to deploy the business logics for data processing Lorusso Domenico 16:34
Re: Question about where to deploy the business logics for data processing Nim Li 18:36
Re: Question about where to deploy the business logics for data processing Ron 20:38
Re: Question about where to deploy the business logics for data processing Guyren Howe 23:07
Re: Question about where to deploy the business logics for data processing Adrian Klaver 23:23

June 10, 2023

Thread Author Time
Re: Question about where to deploy the business logics for data processing Michael Nolan 00:13
Re: Active Active PostgreSQL Solution Bruce Momjian 01:22
Re: Active Active PostgreSQL Solution Marcos Pegoraro 05:18
initdb can't init the database Wen Yi 05:30
Re: initdb can't init the database Ian Lawrence Barwick 05:54
Re: initdb can't init the database Wen Yi 08:40
Re: Active Active PostgreSQL Solution Bruce Momjian 13:10
[No subject] Rajmohan Masa 16:55

June 11, 2023

Thread Author Time
What is gcda file? Wen Yi 02:03
Re: What is gcda file? David G. Johnston 02:20
Re: What is gcda file? Wen Yi 02:22

June 12, 2023

Thread Author Time
RE: Support logical replication of DDLs Wei Wang (Fujitsu) 01:47
How to trace the postgres? Wen Yi 10:37
Re: Question about where to deploy the business logics for data processing Lorusso Domenico 15:15
SOC II Type 2 report. Raj Kiran 18:57
Dynamic binding issue Lorusso Domenico 22:13
Re: Dynamic binding issue Adrian Klaver 23:31

June 13, 2023

Thread Author Time
Re: Question about where to deploy the business logics for data processing Merlin Moncure 02:49
Re: Support logical replication of DDLs Amit Kapila 05:15
Re: How to trace the postgres? Wen Yi 06:49
Reproducing incorrect order with order by in a subquery Ruslan Zakirov 07:49
Re: Support logical replication of DDLs Michael Paquier 07:50
[Beginner Question] Will the backup wal file take too much storage space? Wen Yi 08:00
"paths" between two ROLEs Dominique Devienne 08:17
pg_upgrade v15 not generating analyze_new_cluster.sh rihad 08:35
pg_upgrade v15 not generating analyze_new_cluster.sh rihad 08:35
Re: pg_upgrade v15 not generating analyze_new_cluster.sh Magnus Hagander 08:57
Re: Dynamic binding issue Lorusso Domenico 09:07
Re: pg_upgrade v15 not generating analyze_new_cluster.sh rihad 09:10
Re: Reproducing incorrect order with order by in a subquery Thomas Kellerer 10:26
Re: [Beginner Question] Will the backup wal file take too much storage space? Francisco Olarte 11:34
Re: "paths" between two ROLEs Joe Conway 12:20
Re: Support logical replication of DDLs Amit Kapila 13:19
Re: [Beginner Question] Will the backup wal file take too much storage space? Ron 14:50
Re: SOC II Type 2 report. Christophe Pettus 14:54
Re: Reproducing incorrect order with order by in a subquery Ruslan Zakirov 14:58
Re: Reproducing incorrect order with order by in a subquery Tom Lane 15:06
Re: "paths" between two ROLEs Dominique Devienne 15:11
Re: Reproducing incorrect order with order by in a subquery Ruslan Zakirov 17:55
Re: Reproducing incorrect order with order by in a subquery David G. Johnston 18:07
Exclusion constraint with negated operator? Torsten Förtsch 18:11
Helping planner to chose sequential scan when it improves performance 📎 Patrick O'Toole 19:24
Re: Exclusion constraint with negated operator? Tom Lane 20:15
Re: Support logical replication of DDLs Michael Paquier 21:56

June 14, 2023

Thread Author Time
Re: SOC II Type 2 report. raf 07:48
Re: Reproducing incorrect order with order by in a subquery Ruslan Zakirov 10:03
Re: Reproducing incorrect order with order by in a subquery Ron 11:47
Re: Reproducing incorrect order with order by in a subquery Karsten Hilbert 12:50
Re: Active Active PostgreSQL Solution Jan Wieck 16:13
date format Marc Millas 16:42
Re: date format Michael Nolan 17:05
Re: date format David G. Johnston 17:27
Re: date format Marc Millas 18:02
Re: date format Ron 18:14
Re: date format Marc Millas 18:23
Re: date format Marc Millas 18:24
Re: date format Adrian Klaver 18:53
Re: date format Laurenz Albe 20:44
Re: Reproducing incorrect order with order by in a subquery Ruslan Zakirov 21:58
Re: Helping planner to chose sequential scan when it improves performance Ruslan Zakirov 23:00

June 15, 2023

Thread Author Time
Re: Reproducing incorrect order with order by in a subquery Karsten Hilbert 18:15

June 16, 2023

Thread Author Time
Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 09:40
Re: Question: Multiple pg clusters on one server can be reached with the standard port. 📎 Thomas Markus 10:04
Re: Support logical replication of DDLs 📎 shveta malik 10:31
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Michael Weiller 11:52
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 11:53
Using vars in jsonbpath operator ? Markur Sens 11:54

Browse Archives

Prev | Next