pgsql-general since 2023-07-17 00:00

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

July 17, 2023

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

July 18, 2023

Thread Author Time
Re: Support logical replication of DDLs Masahiko Sawada 05:28
Re: Support logical replication of DDLs Michael Paquier 05:37
suggestion about time based partitioning and hibernate Luca Ferrari 06:18
Re: suggestion about time based partitioning and hibernate Ron 06:47
RE: Support logical replication of DDLs 📎 Zhijie Hou (Fujitsu) 07:09
RE: suggestion about time based partitioning and hibernate n.kobzarev 07:32
fsync data directory after DB crash Pandora 08:50
Upgrade Failure Johnathan Tiamoh 10:02
Re: Upgrade Failure Laurenz Albe 10:12
Re: Upgrade Failure Johnathan Tiamoh 10:14
Re: Upgrade Failure Daniel Gustafsson 10:14
Re: Upgrade Failure Johnathan Tiamoh 10:26
Re: Upgrade Failure Daniel Gustafsson 10:38
Re: Query take a long time and use no index David Rowley 11:28
Re: Query take a long time and use no index David Rowley 11:34
Re: Upgrade Failure Ron 14:44
Effects of dropping a large table Devin Ivy 17:58
Re: Effects of dropping a large table Rob Sargent 19:41

July 19, 2023

Thread Author Time
Re: fsync data directory after DB crash Michael Paquier 00:41
Re: fsync data directory after DB crash Thomas Munro 01:37
回复: fsync data directory after DB crash Pandora 02:09
Fwd: Regarding Installation of PostgreSQL 📎 Sahil Sojitra 03:14
Pgoutput not capturing the generated columns Rajendra Kumar Dangwal 03:53
Re: Effects of dropping a large table Laurenz Albe 08:17
Need help setting up Windows authentication SSPI user mapping Haidong Huang 14:56
Re: Fwd: Regarding Installation of PostgreSQL Adrian Klaver 15:36
Re: suggestion about time based partitioning and hibernate Alvaro Herrera 16:45
Re: Effects of dropping a large table David Rowley 23:15
Re: Effects of dropping a large table Rob Sargent 23:33

July 20, 2023

Thread Author Time
Nu-B here Amn Ojee Uw 00:36
My 1st JDBC and PostgreSQL Amn Ojee Uw 00:37
Re: Nu-B here Tom Lane 00:54
Re: Nu-B here Maciek Sakrejda 00:55
Re: My 1st JDBC and PostgreSQL Tom Lane 00:58
Re: My 1st JDBC and PostgreSQL Chuck Davis 01:11
Re: My 1st JDBC and PostgreSQL Jeffrey Walton 01:52
Postgres SQL Anthony Apollis 05:40
Re: Nu-B here Alban Hertroys 06:32
How to improve the performance of my SQL query? gzh 07:09
Re: Postgrsql blocked for more than 120 s Bogdan Siara 07:38
Re: Postgres SQL Maciek Sakrejda 08:00
Re: How to improve the performance of my SQL query? Erik Wienhold 08:07
Re: How to improve the performance of my SQL query? Peter J. Holzer 09:44
TSQL To Postgres - Unpivot/Union All Anthony Apollis 11:29
Re:Re: How to improve the performance of my SQL query? gzh 11:36
Re: How to improve the performance of my SQL query? Laurenz Albe 11:58
Fwd: TSQL To Postgres - Unpivot/Union All Anthony Apollis 12:17
Re: TSQL To Postgres - Unpivot/Union All David G. Johnston 12:48
Re: TSQL To Postgres - Unpivot/Union All Geoff Winkless 13:58
Re: How to improve the performance of my SQL query? gzh 14:14
Fwd: TSQL To Postgres - Unpivot/Union All 📎 Anthony Apollis 14:28
Re: Nu-B here Adrian Klaver 14:41
Re: How to improve the performance of my SQL query? Laurenz Albe 14:48
Re: TSQL To Postgres - Unpivot/Union All Geoff Winkless 14:51
Re: Fwd: TSQL To Postgres - Unpivot/Union All Thomas Kellerer 15:07
Re: My 1st JDBC and PostgreSQL Adrian Klaver 15:18
Re: Re: How to improve the performance of my SQL query? jian he 15:20
Re: My 1st JDBC and PostgreSQL Adrian Klaver 15:21
Re: suggestion about time based partitioning and hibernate Luca Ferrari 15:31
Re: TSQL To Postgres - Unpivot/Union All Anthony Apollis 15:47
Re: My 1st JDBC and PostgreSQL Chuck Davis 16:44
Re: suggestion about time based partitioning and hibernate Ron 16:52
pg_upgradecluster fails if pg_hba.conf contains "@file" entries Albrecht Dreß 17:18
Re: fsync data directory after DB crash Thomas Munro 23:26

July 21, 2023

Thread Author Time
Re: How to improve the performance of my SQL query? gzh 01:43
Re:How to improve the performance of my SQL query? gzh 02:02
Server unable to UP after restore Ram Pratap Maurya 04:06
invalid value for parameter "default_text_search_config": "public.pg" Les 05:25
Re: invalid value for parameter "default_text_search_config": "public.pg" David G. Johnston 05:41
Re: invalid value for parameter "default_text_search_config": "public.pg" Les 05:42
Re: Moving data from huge table slow, min() query on indexed column taking 38s Dimitrios Apostolou 07:20
aclitem binary encoding Joseph Koshakow 14:30
Re: invalid value for parameter "default_text_search_config": "public.pg" Adrian Klaver 14:49
Re: aclitem binary encoding Tom Lane 14:58
Re: invalid value for parameter "default_text_search_config": "public.pg" Adrian Klaver 15:28
Re: invalid value for parameter "default_text_search_config": "public.pg" Les 18:51
Re: invalid value for parameter "default_text_search_config": "public.pg" Les 18:59
Re: invalid value for parameter "default_text_search_config": "public.pg" Tom Lane 19:31
Re: invalid value for parameter "default_text_search_config": "public.pg" Les 19:57
Re: invalid value for parameter "default_text_search_config": "public.pg" Tom Lane 21:09

July 22, 2023

Thread Author Time
Re: invalid value for parameter "default_text_search_config": "public.pg" Les 07:29
Duplicate Primary keys in postgresql tables De Lan 17:11
Re: Duplicate Primary keys in postgresql tables Ken Marshall 17:30
Re: Duplicate Primary keys in postgresql tables Adrian Klaver 18:02
Re: Effects of dropping a large table Gus Spier 20:37

July 23, 2023

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

July 24, 2023

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

July 25, 2023

Thread Author Time
Setting Auto Commit off in C API Badri Subramaniam 01:54
Re: How to improve the performance of my SQL query? gzh 03:11
Re: How to improve the performance of my SQL query? gzh 03:58
Re: How to improve the performance of my SQL query? Laurenz Albe 05:56
Re: Setting Auto Commit off in C API Laurenz Albe 05:57
Re: [Beginner Question]Is there way to test the postgres's kernel function? jian he 08:37
Difference in the tablespace folders on primary and secondary nodes Abhishek Bhola 08:38
Re: suggestion about time based partitioning and hibernate Marc Millas 10:23
Re: Difference in the tablespace folders on primary and secondary nodes Stephen Frost 12:22
Re: Re: How to improve the performance of my SQL query? David Rowley 12:58
Re: How to improve the performance of my SQL query? David Rowley 13:04
Re: Error 503 Backend fetch failed Stephen Frost 13:49
logging_collector is off, but the logging is opening Wen Yi 21:43
Re: Nu-B here Amn Ojee Uw 22:10

July 26, 2023

Thread Author Time
Re: Difference in the tablespace folders on primary and secondary nodes Abhishek Bhola 02:00
Re: Difference in the tablespace folders on primary and secondary nodes Abhishek Bhola 06:12
Re: How to improve the performance of my SQL query? gzh 07:46
How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint? Dionisis Kontominas 09:00
Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint? Thomas Kellerer 09:18
Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint? Dionisis Kontominas 09:25
Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint? Dominique Devienne 09:39
Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint? Thomas Kellerer 09:56
Query on Primary_conninfo Praneel Devisetty 12:03
Re: Difference in the tablespace folders on primary and secondary nodes Stephen Frost 13:55
Re: logging_collector is off, but the logging is opening Adrian Klaver 15:31

July 27, 2023

Thread Author Time
Re: Query on Primary_conninfo Michael Paquier 00:55
Re: Difference in the tablespace folders on primary and secondary nodes Abhishek Bhola 01:30
Re: Difference in the tablespace folders on primary and secondary nodes Stephen Frost 02:39
Re: How to improve the performance of my SQL query? David Rowley 03:36
Bogus temp file reporting? kg.postgresql 07:30
Re: How to improve the performance of my SQL query? gzh 08:09
Re: Bogus temp file reporting? Kyotaro Horiguchi 08:31
Re: Bogus temp file reporting? kg.postgresql 10:27
Create DB privilege is not inherited Ben Hancock 12:47
Re: Create DB privilege is not inherited David G. Johnston 13:09
Re: Create DB privilege is not inherited Ben Hancock 14:37
Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3 Hellen Jiang 20:02
password error in batch script Atul Kumar 20:17
Re: How to improve the performance of my SQL query? Charly 20:38
Re: password error in batch script Adrian Klaver 21:45

July 28, 2023

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

July 29, 2023

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

July 30, 2023

Thread Author Time
[Question]Can someone explain the context_freelists? Wen Yi 11:44

Browse Archives

Prev | Next