Home > mailing lists

Mailing lists [pgsql-general]

1 July 2023

00:56 Is anyone using db_user_namespace? Nathan Bossart
08:40 Re: psql and pgpass.conf on Windows Kirk Wolak
09:06 Re: psql and pgpass.conf on Windows Julien Rouhaud
10:10 [Beginner Question] How to print the call link graph? Wen Yi
18:26 Re: [Beginner Question] How to print the call link graph? Ron
19:08 Re: [Beginner Question] How to print the call link graph? Julien Rouhaud
20:05 Re: [EXT] Re: [Beginner Question] How to print the call link graph? Garfield Lewis
22:44 Re: [Beginner Question] How to print the call link graph? Erik Wienhold

2 July 2023

14:06 Re: [Beginner Question] How to print the call link graph? Wen Yi
14:19 [Beginner Question]What's the use of ResTarget? Wen Yi

3 July 2023

01:06 Re: need explanation about an explain plan David Rowley
02:12 Re: need explanation about an explain plan Umut TEKİN
11:37 Re: Query regarding managing Replication Ashok Patil
12:36 Re: Query regarding managing Replication Julien Rouhaud
18:10 Re: psql and pgpass.conf on Windows Kirk Wolak

4 July 2023

15:21 psql -c command parse "select $$hello$$" failed jian he
15:36 Re: psql -c command parse "select $$hello$$" failed Julien Rouhaud
15:45 Re: psql -c command parse "select $$hello$$" failed Erik Wienhold

5 July 2023

15:23 Strange behaviour on function Lorusso Domenico
16:53 Re: Strange behaviour on function Erik Wienhold
18:16 Re: Strange behaviour on function Adrian Klaver
18:33 Re: Strange behaviour on function Erik Wienhold
22:56 Re: Strange behaviour on function Lorusso Domenico
23:03 Re: Strange behaviour on function Lorusso Domenico

6 July 2023

07:52 Need help aarthi rajagopal
12:19 function to_char(iso-8859-1) is not unique at character 8 gzh
14:21 Re: function to_char(iso-8859-1) is not unique at character 8 Pavel Stehule
14:36 Re: function to_char(iso-8859-1) is not unique at character 8 Erik Wienhold
14:38 Re: function to_char(iso-8859-1) is not unique at character 8 gzh
14:54 Re: function to_char(iso-8859-1) is not unique at character 8 Pavel Stehule
15:34 Logical replication restarts Paula Berenguel
15:44 Re: Logical replication restarts Mateusz Henicz
17:01 Re: function to_char(iso-8859-1) is not unique at character 8 Ron
17:07 Re: function to_char(iso-8859-1) is not unique at character 8 Tom Lane
17:15 Re: function to_char(iso-8859-1) is not unique at character 8 gzh
17:16 Re: function to_char(iso-8859-1) is not unique at character 8 Pavel Stehule
17:28 Re: function to_char(iso-8859-1) is not unique at character 8 gzh
17:42 Re: function to_char(iso-8859-1) is not unique at character 8 Pavel Stehule
18:00 Moving data from huge table slow, min() query on indexed column taking 38s Dimitrios Apostolou
19:11 Re: Moving data from huge table slow, min() query on indexed column taking 38s Dimitrios Apostolou
22:29 Re: Need help Adrian Klaver

7 July 2023

00:42 Re: Moving data from huge table slow, min() query on indexed column taking 38s Lorusso Domenico
00:52 [bug]? insert returning composite type fails Lorusso Domenico
01:04 Re: [bug]? insert returning composite type fails David G. Johnston
02:20 Re: [bug]? insert returning composite type fails Adrian Klaver
05:20 Re: function to_char(iso-8859-1) is not unique at character 8 gzh
14:03 Re: [bug]? insert returning composite type fails Lorusso Domenico
15:43 temp table security labels Ted Toth
16:05 Re: temp table security labels Ted Toth
17:42 track_activity_query_size max practical size? Ron
17:51 Re: track_activity_query_size max practical size? Adrian Klaver
17:55 Re: track_activity_query_size max practical size? Adrian Klaver
17:56 Re: track_activity_query_size max practical size? Ron
17:58 Re: track_activity_query_size max practical size? Ron
18:13 Re: track_activity_query_size max practical size? Adrian Klaver
18:27 Re: track_activity_query_size max practical size? Ron
18:44 Re: temp table security labels Ted Toth
18:52 Re: temp table security labels Ted Toth
18:53 Re: track_activity_query_size max practical size? Adrian Klaver
19:23 pgbouncer best practices Rita
19:37 Re: pgbouncer best practices Ben Chobot
21:09 Re: pgbouncer best practices Gurjeet Singh

8 July 2023

14:27 Re: pgbouncer best practices Rita
16:46 Re: pgbouncer best practices Ben Chobot
18:06 How to add function schema in search_path in option definitio Lorusso Domenico
18:31 Re: How to add function schema in search_path in option definitio Adrian Klaver
18:46 Re: How to add function schema in search_path in option definitio Adrian Klaver
20:00 Re: How to add function schema in search_path in option definitio Lorusso Domenico

9 July 2023

00:10 Re: How to add function schema in search_path in option definitio Adrian Klaver
13:59 Re: [Beginner Question]What's the use of ResTarget? Alvaro Herrera
14:01 Re: How to add function schema in search_path in option definitio Peter J. Holzer
15:13 now() literal in pg_input_is_valid jian he
16:27 Re: pgbouncer best practices Rita
17:22 Re: now() literal in pg_input_is_valid Tom Lane
17:22 Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" Avi Weinberg
23:47 Re: How to add function schema in search_path in option definitio Lorusso Domenico

10 July 2023

00:21 Re: How to add function schema in search_path in option definitio Adrian Klaver
01:58 INSERT UNIQUE row? pf@pfortin.com
02:02 Re: INSERT UNIQUE row? Christophe Pettus
02:42 Re: INSERT UNIQUE row? David G. Johnston
03:04 Re: INSERT UNIQUE row? Adrian Klaver
03:06 Re: INSERT UNIQUE row? Adrian Klaver
05:25 Re: INSERT UNIQUE row? pf@pfortin.com
05:29 Re: INSERT UNIQUE row? pf@pfortin.com
10:41 Re: Query regarding managing Replication Ashok Patil
10:43 Re: INSERT UNIQUE row? Erik Wienhold
11:02 Re: Query regarding managing Replication Julien Rouhaud
11:27 search_path for replica-mode André Kutepow
13:21 search_path for replica-mode André Kutepow
16:11 Re: search_path for replica-mode David G. Johnston
17:18 what causes new temp schemas to be created Ted Toth
17:20 Re: what causes new temp schemas to be created David G. Johnston
17:28 Re: what causes new temp schemas to be created Ron
18:58 Re: Moving data from huge table slow, min() query on indexed column taking 38s Dimitrios Apostolou
19:11 Prevent LSN pointer advancement in case of cursor exception (wal2json + pg_logical_slot_get_changes) Mertez
19:19 Re: what causes new temp schemas to be created Ted Toth
19:22 Re: what causes new temp schemas to be created David G. Johnston
20:03 Re: what causes new temp schemas to be created Ted Toth
20:08 Re: what causes new temp schemas to be created Tom Lane
20:45 Re: Is anyone using db_user_namespace? Nathan Bossart
21:15 Need Help On Upgrade Johnathan Tiamoh
21:20 Trigger Function question DAVID ROTH
21:23 Re: Trigger Function question Christophe Pettus
21:29 Re: Trigger Function question DAVID ROTH
21:31 Re: Trigger Function question Christophe Pettus
21:37 Re: Trigger Function question DAVID ROTH
21:38 Re: Trigger Function question Christophe Pettus
21:42 Re: Trigger Function question DAVID ROTH
21:46 Re: Trigger Function question DAVID ROTH
21:51 Re: Trigger Function question Marcos Pegoraro
21:52 Re: Trigger Function question Christophe Pettus
21:54 Using "exit" to bring "goto" functionality. Bryn Llewellyn
21:58 Re: Using "exit" to bring "goto" functionality. Christophe Pettus
22:08 Re: Using "exit" to bring "goto" functionality. DAVID ROTH
22:29 Re: Using "exit" to bring "goto" functionality. Adrian Klaver
22:38 Re: Need Help On Upgrade Adrian Klaver
23:00 Re: Need Help On Upgrade Adrian Klaver
23:02 Re: Need Help On Upgrade Johnathan Tiamoh
23:20 Re: Need Help On Upgrade Johnathan Tiamoh
23:26 Re: Using "exit" to bring "goto" functionality. Bryn Llewellyn
23:52 Re: Using "exit" to bring "goto" functionality. Pavel Stehule

11 July 2023

00:17 Re: Using "exit" to bring "goto" functionality. Bryn Llewellyn
01:36 Re: Need Help On Upgrade Adrian Klaver
03:38 Re: Need Help On Upgrade Johnathan Tiamoh
04:14 Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" Kyotaro Horiguchi
04:24 Re: Is anyone using db_user_namespace? Ian Lawrence Barwick
04:28 Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" Tom Lane
04:29 Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" Kyotaro Horiguchi
04:59 Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" David G. Johnston
06:45 Re: Need Help On Upgrade Laurenz Albe
09:47 Re: pgbouncer best practices Gurjeet Singh
10:27 Re: how to return data from insert into ... on conflict ... returning ... into Gurjeet Singh
10:30 Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" Kyotaro Horiguchi
11:50 BI Reports and Postgres KK CHN
11:50 Re: search_path for replica-mode André Kutepow
17:16 Re: Need Help On Upgrade Johnathan Tiamoh
18:46 Re: Need Help On Upgrade Adrian Klaver
18:53 Re: Need Help On Upgrade Johnathan Tiamoh
19:19 Re: Need Help On Upgrade Adrian Klaver
20:54 Re: BI Reports and Postgres Gurjeet Singh
22:31 Re: Moving data from huge table slow, min() query on indexed column taking 38s Lorusso Domenico
22:35 Re: How to add function schema in search_path in option definitio Lorusso Domenico
22:41 Re: How to add function schema in search_path in option definitio Adrian Klaver
22:41 Re: Trigger Function question Lorusso Domenico
22:47 Re: How to add function schema in search_path in option definitio Lorusso Domenico
23:17 Re: How to add function schema in search_path in option definitio Adrian Klaver
23:50 Re: How to add function schema in search_path in option definitio David G. Johnston

12 July 2023

00:45 Re: Need Help On Upgrade Johnathan Tiamoh
02:32 Re: Need Help On Upgrade Adrian Klaver
02:39 Re: Is anyone using db_user_namespace? Nathan Bossart
04:31 Re: Need Help On Upgrade Benedict Holland
06:52 psql -af > out, is possible to also have raise notice, raise info part. jian he
07:05 Re: psql -af > out, is possible to also have raise notice, raise info part. David G. Johnston
07:27 Re: psql -af > out, is possible to also have raise notice, raise info part. jian he
07:39 Re: Need Help On Upgrade Johnathan Tiamoh
10:50 [Beginner Question] Will the vxid replace xid? Wen Yi
16:28 RE: How to add function schema in search_path in option definitio Joel Rabinovitch
21:54 Re: Requesting Information for GSSAPI Stephen Frost
22:28 Reset Postgresql users password Johnathan Tiamoh
22:34 Re: Reset Postgresql users password Gianni Ceccarelli
22:42 Re: Reset Postgresql users password Mateusz Henicz
23:16 Re: Reset Postgresql users password Gurjeet Singh
23:25 Re: Reset Postgresql users password Johnathan Tiamoh
23:35 Re: Reset Postgresql users password David G. Johnston
23:45 Re: How to add function schema in search_path in option definitio Lorusso Domenico

13 July 2023

08:12 create a temp table in SPI 黄宁
09:28 EDB to Postgres Migration KK CHN
10:41 pg_restore mostly idle on restoring a large number of tables Boris Sagadin
12:39 Re: EDB to Postgres Migration Laurenz Albe
12:48 Re: create a temp table in SPI Laurenz Albe
13:23 JOB | DBA (Tokyo) James Tobin
14:20 Problem perhaps after upgrading to pgadmin4 7.4 Carl Erik Eriksson
14:52 Re: Problem perhaps after upgrading to pgadmin4 7.4 hubert depesz lubaczewski
14:58 Re: Problem perhaps after upgrading to pgadmin4 7.4 Carl Erik Eriksson
16:48 Re: Problem perhaps after upgrading to pgadmin4 7.4 Carl Erik Eriksson
20:53 Re: Problem perhaps after upgrading to pgadmin4 7.4 Erik Wienhold
23:50 Re: "PANIC: could not open critical system index 2662" - twice Andres Freund

15 July 2023

09:38 Fwd: error in the example given for numeric data types Priyank Rajvansh
10:16 Re: error in the example given for numeric data types jian he
16:16 Re: error in the example given for numeric data types Tom Lane
17:30 Installation Issue Baskar Muthu
17:51 Re: pg_restore mostly idle on restoring a large number of tables Ron
19:37 Rocky Linux 9 and postgres10 Daniel Gallo
19:45 Re: Rocky Linux 9 and postgres10 David G. Johnston
20:01 Re: Rocky Linux 9 and postgres10 Adrian Klaver
20:50 Re: error in the example given for numeric data types Priyank Rajvansh
20:56 Re: pg_restore mostly idle on restoring a large number of tables Tom Lane
21:09 Re: error in the example given for numeric data types David G. Johnston
23:42 Re: Toasted column values during replication Chandy G

16 July 2023

00:11 Re: Rocky Linux 9 and postgres10 Daniel Gallo
00:19 Re: Fwd: error in the example given for numeric data types Peter J. Holzer
18:35 Re: Installation Issue Adrian Klaver

17 July 2023

05:12 Re: create a temp table in SPI 黄宁
05:23 Re: Problem perhaps after upgrading to pgadmin4 7.4 Ron
05:27 Re: Rocky Linux 9 and postgres10 Ron
05:28 Re: Reset Postgresql users password Ron
06:23 [Beginner Question]What is query jumbling? Wen Yi
06:27 Re: Reset Postgresql users password Wen Yi
08:40 Postgrsql blocked for more than 120 s Bogdan Siara
10:52 Re: Reset Postgresql users password Chris Travers
12:13 Query take a long time and use no index basti
13:59 Re: [Beginner Question]What is query jumbling? Tomas Vondra
14:20 Re: Query take a long time and use no index Tomas Vondra
14:21 Re: Query take a long time and use no index Tomas Vondra
16:03 Re: Query take a long time and use no index Ron
17:11 How to grant read only functions execute permission to read only user Yi Sun
17:30 Re: Installation Issue Adrian Klaver
18:43 Re: How to grant read only functions execute permission to read only user Tomas Vondra
18:49 Re: How to grant read only functions execute permission to read only user David G. Johnston
19:31 Re: Installation Issue Erik Wienhold
19:34 Re: Installation Issue Carl Erik Eriksson
21:19 Re: Query take a long time and use no index basti
21:50 Re: Is anyone using db_user_namespace? Nathan Bossart

18 July 2023

02:53 backup_manifest rename to backup_manifest.old after successful postgres start up Gert Cuykens
09:18 suggestion about time based partitioning and hibernate Luca Ferrari
09:47 Re: suggestion about time based partitioning and hibernate Ron
10:32 RE: suggestion about time based partitioning and hibernate
11:50 fsync data directory after DB crash Pandora
13:02 Upgrade Failure Johnathan Tiamoh
13:12 Re: Upgrade Failure Laurenz Albe
13:14 Re: Upgrade Failure Johnathan Tiamoh
13:14 Re: Upgrade Failure Daniel Gustafsson
13:26 Re: Upgrade Failure Johnathan Tiamoh
13:38 Re: Upgrade Failure Daniel Gustafsson
14:28 Re: Query take a long time and use no index David Rowley
14:34 Re: Query take a long time and use no index David Rowley
17:44 Re: Upgrade Failure Ron
20:58 Effects of dropping a large table Devin Ivy
22:41 Re: Effects of dropping a large table Rob Sargent

19 July 2023

03:41 Re: fsync data directory after DB crash Michael Paquier
04:37 Re: fsync data directory after DB crash Thomas Munro
05:09 回复： fsync data directory after DB crash Pandora
06:14 Fwd: Regarding Installation of PostgreSQL Sahil Sojitra
06:53 Pgoutput not capturing the generated columns Rajendra Kumar Dangwal
11:17 Re: Effects of dropping a large table Laurenz Albe
17:56 Need help setting up Windows authentication SSPI user mapping Haidong Huang
18:36 Re: Fwd: Regarding Installation of PostgreSQL Adrian Klaver
19:45 Re: suggestion about time based partitioning and hibernate Alvaro Herrera

20 July 2023

02:15 Re: Effects of dropping a large table David Rowley
02:33 Re: Effects of dropping a large table Rob Sargent
03:36 Nu-B here Amn Ojee Uw
03:37 My 1st JDBC and PostgreSQL Amn Ojee Uw
03:54 Re: Nu-B here Tom Lane
03:55 Re: Nu-B here Maciek Sakrejda
03:58 Re: My 1st JDBC and PostgreSQL Tom Lane
04:11 Re: My 1st JDBC and PostgreSQL Chuck Davis
04:52 Re: My 1st JDBC and PostgreSQL Jeffrey Walton
08:40 Postgres SQL Anthony Apollis
09:32 Re: Nu-B here Alban Hertroys
10:09 How to improve the performance of my SQL query？ gzh
10:38 Re: Postgrsql blocked for more than 120 s Bogdan Siara
11:00 Re: Postgres SQL Maciek Sakrejda
11:07 Re: How to improve the performance of my SQL query？ Erik Wienhold
12:44 Re: How to improve the performance of my SQL query？ Peter J. Holzer
14:36 Re:Re: How to improve the performance of my SQL query？ gzh
14:58 Re: How to improve the performance of my SQL query？ Laurenz Albe
15:17 Fwd: TSQL To Postgres - Unpivot/Union All Anthony Apollis
15:48 Re: TSQL To Postgres - Unpivot/Union All David G. Johnston
16:58 Re: TSQL To Postgres - Unpivot/Union All Geoff Winkless
17:14 Re: How to improve the performance of my SQL query？ gzh
17:28 Fwd: TSQL To Postgres - Unpivot/Union All Anthony Apollis
17:41 Re: Nu-B here Adrian Klaver
17:48 Re: How to improve the performance of my SQL query？ Laurenz Albe
17:51 Re: TSQL To Postgres - Unpivot/Union All Geoff Winkless
18:07 Re: Fwd: TSQL To Postgres - Unpivot/Union All Thomas Kellerer
18:18 Re: My 1st JDBC and PostgreSQL Adrian Klaver
18:20 Re: Re: How to improve the performance of my SQL query？ jian he
18:21 Re: My 1st JDBC and PostgreSQL Adrian Klaver
18:31 Re: suggestion about time based partitioning and hibernate Luca Ferrari
18:47 Re: TSQL To Postgres - Unpivot/Union All Anthony Apollis
19:44 Re: My 1st JDBC and PostgreSQL Chuck Davis
19:52 Re: suggestion about time based partitioning and hibernate Ron
20:18 pg_upgradecluster fails if pg_hba.conf contains "@file" entries Albrecht Dreß

21 July 2023

02:26 Re: fsync data directory after DB crash Thomas Munro
04:43 Re: How to improve the performance of my SQL query？ gzh
05:02 Re:How to improve the performance of my SQL query？ gzh
07:06 Server unable to UP after restore Ram Pratap Maurya
08:25 invalid value for parameter "default_text_search_config": "public.pg" Les
08:41 Re: invalid value for parameter "default_text_search_config": "public.pg" David G. Johnston
08:42 Re: invalid value for parameter "default_text_search_config": "public.pg" Les
10:20 Re: Moving data from huge table slow, min() query on indexed column taking 38s Dimitrios Apostolou
17:30 aclitem binary encoding Joseph Koshakow
17:49 Re: invalid value for parameter "default_text_search_config": "public.pg" Adrian Klaver
17:58 Re: aclitem binary encoding Tom Lane
18:28 Re: invalid value for parameter "default_text_search_config": "public.pg" Adrian Klaver
21:51 Re: invalid value for parameter "default_text_search_config": "public.pg" Les
21:59 Re: invalid value for parameter "default_text_search_config": "public.pg" Les
22:31 Re: invalid value for parameter "default_text_search_config": "public.pg" Tom Lane
22:57 Re: invalid value for parameter "default_text_search_config": "public.pg" Les

22 July 2023

00:09 Re: invalid value for parameter "default_text_search_config": "public.pg" Tom Lane
10:29 Re: invalid value for parameter "default_text_search_config": "public.pg" Les
20:11 Duplicate Primary keys in postgresql tables De Lan
20:30 Re: Duplicate Primary keys in postgresql tables Ken Marshall
21:02 Re: Duplicate Primary keys in postgresql tables Adrian Klaver

23 July 2023

12:22 [Beginner Question]Is there way to test the postgres's kernel function? Wen Yi
12:51 Re: Effects of dropping a large table Peter J. Holzer
13:09 Re: Effects of dropping a large table Gus Spier
13:27 Re: Effects of dropping a large table Peter J. Holzer
23:05 Re: Effects of dropping a large table Ron

24 July 2023

03:57 pageinspect bt_page_items doc jian he
04:46 Re: pageinspect bt_page_items doc Julien Rouhaud
05:25 \d don't print all the tables Wen Yi
08:43 Re: How to improve the performance of my SQL query？ Laurenz Albe
12:51 Re: \d don't print all the tables Antonio Čale
12:54 Re: How to improve the performance of my SQL query？ gzh
15:44 Re: aclitem binary encoding Dominique Devienne
16:01 Error 503 Backend fetch failed Sabri Taner Burak ALTINDAL
16:15 Grant all privileges to user on a database Kaushal Shriyan
16:17 Re: \d don't print all the tables Ron
16:21 Re: Grant all privileges to user on a database Ron
16:38 Re: Grant all privileges to user on a database Kaushal Shriyan
16:42 Re: \d don't print all the tables Adrian Klaver
16:56 Re: Grant all privileges to user on a database David G. Johnston
17:09 Re: Grant all privileges to user on a database Tom Lane
17:17 Re: \d don't print all the tables Alvaro Herrera
17:42 Re: How to improve the performance of my SQL query？ jian he
17:51 Re: Grant all privileges to user on a database Ron
17:56 Re: [Beginner Question]Is there way to test the postgres's kernel function? David G. Johnston
17:59 Re: Grant all privileges to user on a database David G. Johnston
18:58 Re: How to improve the performance of my SQL query？ Laurenz Albe
19:59 Re: Duplicate Primary keys in postgresql tables De Lan

25 July 2023

04:54 Setting Auto Commit off in C API Badri Subramaniam
06:11 Re: How to improve the performance of my SQL query？ gzh
06:58 Re: How to improve the performance of my SQL query？ gzh
08:56 Re: How to improve the performance of my SQL query？ Laurenz Albe
08:57 Re: Setting Auto Commit off in C API Laurenz Albe
11:37 Re: [Beginner Question]Is there way to test the postgres's kernel function? jian he
11:38 Difference in the tablespace folders on primary and secondary nodes Abhishek Bhola
13:23 Re: suggestion about time based partitioning and hibernate Marc Millas
15:22 Re: Difference in the tablespace folders on primary and secondary nodes Stephen Frost
15:58 Re: Re: How to improve the performance of my SQL query？ David Rowley
16:04 Re: How to improve the performance of my SQL query？ David Rowley
16:49 Re: Error 503 Backend fetch failed Stephen Frost

26 July 2023

00:43 logging_collector is off, but the logging is opening Wen Yi
01:10 Re: Nu-B here Amn Ojee Uw
05:00 Re: Difference in the tablespace folders on primary and secondary nodes Abhishek Bhola
09:12 Re: Difference in the tablespace folders on primary and secondary nodes Abhishek Bhola
10:46 Re: How to improve the performance of my SQL query？ gzh
12:00 How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint? Dionisis Kontominas
12:18 Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint? Thomas Kellerer
12:25 Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint? Dionisis Kontominas
12:39 Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint? Dominique Devienne
12:56 Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint? Thomas Kellerer
15:03 Query on Primary_conninfo Praneel Devisetty
16:55 Re: Difference in the tablespace folders on primary and secondary nodes Stephen Frost
18:31 Re: logging_collector is off, but the logging is opening Adrian Klaver

27 July 2023

03:55 Re: Query on Primary_conninfo Michael Paquier
04:30 Re: Difference in the tablespace folders on primary and secondary nodes Abhishek Bhola
05:39 Re: Difference in the tablespace folders on primary and secondary nodes Stephen Frost
06:36 Re: How to improve the performance of my SQL query？ David Rowley
10:30 Bogus temp file reporting? kg.postgresql@olympiakos.com
11:09 Re: How to improve the performance of my SQL query？ gzh
11:31 Re: Bogus temp file reporting? Kyotaro Horiguchi
13:27 Re: Bogus temp file reporting? kg.postgresql@olympiakos.com
15:47 Create DB privilege is not inherited Ben Hancock
16:09 Re: Create DB privilege is not inherited David G. Johnston
17:37 Re: Create DB privilege is not inherited Ben Hancock
23:02 Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3 Hellen Jiang
23:17 password error in batch script Atul Kumar
23:38 Re: How to improve the performance of my SQL query？ Charly

28 July 2023

00:45 Re: password error in batch script Adrian Klaver
03:19 PostgreSQL - How to login with my Linux user account Amn Ojee Uw
03:23 Re: PostgreSQL - How to login with my Linux user account David G. Johnston
03:31 Re: PostgreSQL - How to login with my Linux user account Adrian Klaver
13:23 Compile static postgres.lib for postgres 15.3 on Windows Priess Stefan
13:36 Understanding pg_stat_io.evictions Daniel Westermann (DWE)
13:48 Re: Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3 Laurenz Albe
14:50 Re: How to improve the performance of my SQL query？ gzh
15:20 impact pgbench on a physical replicated stream Gert Cuykens
15:48 Re: Compile static postgres.lib for postgres 15.3 on Windows Tom Lane
17:00 Re: PostgreSQL - How to login with my Linux user account Amn Ojee Uw
17:12 Re: password error in batch script Ron
17:26 AW: Compile static postgres.lib for postgres 15.3 on Windows Priess Stefan
17:43 Re: AW: Compile static postgres.lib for postgres 15.3 on Windows Adrian Klaver
17:44 Re: PostgreSQL - How to login with my Linux user account Ron
17:48 Re: PostgreSQL - How to login with my Linux user account Adrian Klaver
17:50 Re: impact pgbench on a physical replicated stream Ron
18:01 Re: AW: Compile static postgres.lib for postgres 15.3 on Windows Tom Lane
19:32 Re: impact pgbench on a physical replicated stream Gert Cuykens
20:29 Re: Bogus temp file reporting? Ron

29 July 2023

05:55 Re: backup_manifest rename to backup_manifest.old after successful postgres start up Michael Paquier
09:42 How to get an md5/sha256 hash of a really large object in psql? Alex Shan
11:59 Re: How to improve the performance of my SQL query？ Peter J. Holzer
12:37 Re: How to improve the performance of my SQL query？ Alban Hertroys
16:49 Timeout in Logical Replication Philip Warner
19:57 Re: How to get an md5/sha256 hash of a really large object in psql? Erik Wienhold

30 July 2023

14:44 [Question]Can someone explain the context_freelists? Wen Yi
14:53 Upgrading Amn Ojee Uw
15:04 Re: Upgrading Wen Yi
15:12 Re: Upgrading Ron
17:01 Migrating MySQL DB to PostgreSQL DB. Kaushal Shriyan
17:11 Re: Migrating MySQL DB to PostgreSQL DB. Ken Marshall
17:53 Re: Migrating MySQL DB to PostgreSQL DB. Adrian Klaver
18:34 Re: Upgrading Peter J. Holzer
20:53 Re: Migrating MySQL DB to PostgreSQL DB. Kaushal Shriyan

31 July 2023

01:45 Re: Migrating MySQL DB to PostgreSQL DB. Ron
03:36 Re: Migrating MySQL DB to PostgreSQL DB. Kaushal Shriyan
04:32 Re: Understanding pg_stat_io.evictions Kyotaro Horiguchi
05:22 Re: Upgrading Amn Ojee Uw
05:26 Re: Migrating MySQL DB to PostgreSQL DB. Tom Browder
05:46 Re: Upgrading Adrian Klaver
09:59 AW: AW: Compile static postgres.lib for postgres 15.3 on Windows Priess Stefan
10:52 AW: AW: Compile static postgres.lib for postgres 15.3 on Windows Priess Stefan
10:57 Re: Understanding pg_stat_io.evictions Daniel Westermann (DWE)
11:16 AW: AW: Compile static postgres.lib for postgres 15.3 on Windows Priess Stefan
14:10 jsonb on-disk size calculation jian he
15:14 Re: How to get an md5/sha256 hash of a really large object in psql? Alex Shan
15:47 Completely Removing PostgreSQL Amn Ojee Uw
15:52 Re: Completely Removing PostgreSQL Alvaro Herrera
16:32 Re: Completely Removing PostgreSQL Ron
17:27 Re: Completely Removing PostgreSQL Adrian Klaver
18:56 Re: jsonb on-disk size calculation Adrian Klaver