pgsql-general since 2023-07-19 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 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
Upgrading Amn Ojee Uw 11:53
Re: Upgrading Wen Yi 12:04
Re: Upgrading Ron 12:12
Migrating MySQL DB to PostgreSQL DB. Kaushal Shriyan 14:01
Re: Migrating MySQL DB to PostgreSQL DB. Ken Marshall 14:11
Re: Migrating MySQL DB to PostgreSQL DB. Adrian Klaver 14:53
Re: Upgrading Peter J. Holzer 15:34
Re: Migrating MySQL DB to PostgreSQL DB. Kaushal Shriyan 17:53
Re: Migrating MySQL DB to PostgreSQL DB. Ron 22:45

July 31, 2023

Thread Author Time
Re: Migrating MySQL DB to PostgreSQL DB. Kaushal Shriyan 00:36
Re: Understanding pg_stat_io.evictions Kyotaro Horiguchi 01:32
Re: Upgrading Amn Ojee Uw 02:22
Re: Migrating MySQL DB to PostgreSQL DB. Tom Browder 02:26
Re: Upgrading Adrian Klaver 02:46
AW: AW: Compile static postgres.lib for postgres 15.3 on Windows Priess Stefan 06:59
AW: AW: Compile static postgres.lib for postgres 15.3 on Windows Priess Stefan 07:52
Re: Understanding pg_stat_io.evictions Daniel Westermann (DWE) 07:57
AW: AW: Compile static postgres.lib for postgres 15.3 on Windows Priess Stefan 08:16
jsonb on-disk size calculation jian he 11:10
Re: How to get an md5/sha256 hash of a really large object in psql? Alex Shan 12:14
Completely Removing PostgreSQL Amn Ojee Uw 12:47
Re: Completely Removing PostgreSQL Alvaro Herrera 12:52
Re: Completely Removing PostgreSQL Ron 13:32
Re: Completely Removing PostgreSQL Adrian Klaver 14:27
Re: jsonb on-disk size calculation Adrian Klaver 15:56
PORT 5432 ERROR David Beck 23:18

Aug. 1, 2023

Thread Author Time
Re: jsonb on-disk size calculation Junwang Zhao 03:58
How to build a new grammer for pg? 📎 jacktby 09:27
error: connection to server on socket... Amn Ojee Uw 10:22
Re: error: connection to server on socket... Amn Ojee Uw 10:25
Re: error: connection to server on socket... Tomas Pospisek 10:38
Re: PORT 5432 ERROR Tomas Pospisek 10:41
Re: error: connection to server on socket... pf 11:28
Re: error: connection to server on socket... Matthias Apitz 11:57
Re: error: connection to server on socket... Tom Lane 13:10
Re: PORT 5432 ERROR Adrian Klaver 14:33
Re: error: connection to server on socket... Adrian Klaver 14:35
Re:How to build a new grammer for pg? Wen Yi 14:45
PostgreSQL listens on localhost? Frank Gunseor 16:12
Re: PostgreSQL listens on localhost? Matthias Apitz 16:21

Browse Archives

Prev | Next