pgsql-general - April 2025

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

April 1, 2025

Thread Author Time
Doubt on pg_timezone_names and pg_timezone_abbrevs Jayadevan M 03:38
Re: Doubt on pg_timezone_names and pg_timezone_abbrevs David G. Johnston 03:58
Re: Doubt on pg_timezone_names and pg_timezone_abbrevs Tom Lane 04:06
Re: Doubt on pg_timezone_names and pg_timezone_abbrevs Jayadevan M 06:32

April 2, 2025

Thread Author Time
Postgres Query Plan using wrong index Manikandan Swaminathan 00:12
Re: Postgres Query Plan using wrong index Tom Lane 00:30
Re: Any industry best practise to overcome this specific malware "pg_mem" Adrian Klaver 15:31
Re: Any industry best practise to overcome this specific malware "pg_mem" Ron Johnson 16:22
Issue installing postgis on RHEL9 Danny Im 16:29
Re: Issue installing postgis on RHEL9 Ron Johnson 16:32
Re: Issue installing postgis on RHEL9 Danny Im 17:12
Performance issues during pg_restore -j with big partitioned table Dimitrios Apostolou 17:32
Re: Performance issues during pg_restore -j with big partitioned table Adrian Klaver 17:39
Re: Experience and feedback on pg_restore --data-only Dimitrios Apostolou 17:42
Re: Performance issues during pg_restore -j with big partitioned table Adrian Klaver 17:45
Re: Performance issues during pg_restore -j with big partitioned table Dimitrios Apostolou 17:46
Re: Performance issues during pg_restore -j with big partitioned table Dimitrios Apostolou 17:51
Re: Issue installing postgis on RHEL9 Devrim Gündüz 18:29
Re: Issue installing postgis on RHEL9 Devrim Gündüz 18:48
Re: Issue installing postgis on RHEL9 Devrim Gündüz 18:49
Re: Issue installing postgis on RHEL9 Danny Im 19:13
Re: Postgres Query Plan using wrong index Manikandan Swaminathan 23:44

April 3, 2025

Thread Author Time
Re: Postgres Query Plan using wrong index Tom Lane 00:30
Re: Postgres Query Plan using wrong index Manikandan Swaminathan 03:24
Re: Postgres Query Plan using wrong index David Rowley 04:41
Re: Postgres Query Plan using wrong index Tom Lane 05:07
Re: Postgres Query Plan using wrong index David Rowley 10:27

April 4, 2025

Thread Author Time
find replication slots that "belong" to a publication Willy-Bas Loos 08:58
Re: Will PQsetSingleRowMode get me results faster? Stijn Sanders 11:41
Re: find replication slots that "belong" to a publication Willy-Bas Loos 11:42
Re: Performance issues during pg_restore -j with big partitioned table Dimitrios Apostolou 13:13
Re: Performance issues during pg_restore -j with big partitioned table Adrian Klaver 15:02
Re: Performance issues during pg_restore -j with big partitioned table Dimitrios Apostolou 15:09
Re: Performance issues during pg_restore -j with big partitioned table Adrian Klaver 15:23
Re: Performance issues during pg_restore -j with big partitioned table Ron Johnson 16:45
Re: Performance issues during pg_restore -j with big partitioned table Adrian Klaver 17:09

April 5, 2025

Thread Author Time
Custom index access method for primary keys Fabian Lindfors 10:34
Kubernetes, cgroups v2 and OOM killer - how to avoid? Ancoron Luciferis 11:53

April 6, 2025

Thread Author Time
Re: find replication slots that "belong" to a publication Justin 13:36
Re: pgvector as standard PostgreSQL feature? Merlin Moncure 20:59

April 7, 2025

Thread Author Time
Re: Kubernetes, cgroups v2 and OOM killer - how to avoid? Laurenz Albe 08:10
Re: Will PQsetSingleRowMode get me results faster? Laurenz Albe 08:14
PgBackRest fails due to filesystem full KK CHN 09:34
Re: find replication slots that "belong" to a publication Willy-Bas Loos 10:16
Performance regression when adding LIMIT 1 to a query Costa Alexoglou 12:44
Re: Kubernetes, cgroups v2 and OOM killer - how to avoid? Joe Conway 13:21
Re: find replication slots that "belong" to a publication Laurenz Albe 13:31
Re: Performance regression when adding LIMIT 1 to a query Artur Zakirov 14:05
Re: Custom index access method for primary keys Tom Lane 14:06
Slow timestamp query after upgrading from Pg13 to Pg16 Simon Windsor 14:48
Re: Slow timestamp query after upgrading from Pg13 to Pg16 Laurenz Albe 14:51
Re: Performance regression when adding LIMIT 1 to a query Costa Alexoglou 15:34
Re: Slow timestamp query after upgrading from Pg13 to Pg16 Simon Windsor 19:25
Re: Slow timestamp query after upgrading from Pg13 to Pg16 Adrian Klaver 19:36
Re: find replication slots that "belong" to a publication Willy-Bas Loos 20:32
Re: find replication slots that "belong" to a publication Adrian Klaver 20:44
Re: find replication slots that "belong" to a publication Justin 21:00

April 8, 2025

Thread Author Time
Re: find replication slots that "belong" to a publication Laurenz Albe 05:53
Re: Slow timestamp query after upgrading from Pg13 to Pg16 Laurenz Albe 06:40
Queries for monitor yudhi s 10:38
Wal file query Atul Kumar 11:44
Re: Wal file query Kashif Zeeshan 12:01
Re: Wal file query Atul Kumar 13:09
Re: Wal file query Ron Johnson 13:32
timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Achilleas Mantzios - cloud 16:10
Re: PgBackRest fails due to filesystem full Greg Sabino Mullane 16:58
Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Amitabh Kant 17:37
Re: Kubernetes, cgroups v2 and OOM killer - how to avoid? Ancoron Luciferis 17:58
Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Achilleas Mantzios 17:59
Re: Kubernetes, cgroups v2 and OOM killer - how to avoid? Joe Conway 18:15
Postgres_fdw- User Mapping with md5-hashed password Dirschel, Steve 20:00
Re: Postgres_fdw- User Mapping with md5-hashed password Adrian Klaver 20:33

April 9, 2025

Thread Author Time
Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Amitabh Kant 01:50
Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Brent Wood 02:23
Re: PgBackRest fails due to filesystem full KK CHN 05:51
Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Achilleas Mantzios - cloud 06:20
Re: Is pg_basebackup Performance Limited by Files Page Cache? Alexandru Lazarev 11:20
Re: PgBackRest fails due to filesystem full Ron Johnson 13:16
Interesting case of IMMUTABLE significantly hurting performance Olleg Samoylov 16:12
Cannot connect local with ttrust (pg_upgrade assumes it) Abraham, Danny 16:20
Re: Cannot connect local with ttrust (pg_upgrade assumes it) Adrian Klaver 16:28
Re: Cannot connect local with ttrust (pg_upgrade assumes it) David G. Johnston 16:37
Re: Cannot connect local with ttrust (pg_upgrade assumes it) Francisco Olarte 17:03
Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Abraham, Danny 17:44
Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Abraham, Danny 17:45
Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Adrian Klaver 17:47
Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Adrian Klaver 17:49
RE: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Abraham, Danny 19:21
FW: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Abraham, Danny 19:23
Re: FW: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Adrian Klaver 19:31
Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) David G. Johnston 19:34
RE: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Abraham, Danny 20:40
Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Adrian Klaver 20:45
Re: Interesting case of IMMUTABLE significantly hurting performance Laurenz Albe 20:50
Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Adrian Klaver 20:59
Re: Interesting case of IMMUTABLE significantly hurting performance David G. Johnston 21:06
Re: Interesting case of IMMUTABLE significantly hurting performance Nico Williams 21:21
Re: Interesting case of IMMUTABLE significantly hurting performance Adrian Klaver 21:43
RE: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Abraham, Danny 21:53
Re: Interesting case of IMMUTABLE significantly hurting performance Tom Lane 22:08

April 10, 2025

Thread Author Time
Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Amitabh Kant 05:25
Re: Interesting case of IMMUTABLE significantly hurting performance Olleg Samoylov 05:33
Meson and Numa: C header not found Daniel Westermann (DWE) 06:00
Re: Meson and Numa: C header not found Tomas Vondra 09:22
Re: Meson and Numa: C header not found Daniel Westermann (DWE) 09:53
Re: Meson and Numa: C header not found Tomas Vondra 10:07
pg_restore causing ENOSPACE on the WAL partition Dimitrios Apostolou 11:19
Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Francisco Olarte 11:30
Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade assumes it) Francisco Olarte 11:36
Re: pg_restore causing ENOSPACE on the WAL partition Dimitrios Apostolou 12:11
Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Achilleas Mantzios 12:17
Capturing both IP address and hostname in the log Tefft, Michael J 12:22
Archive logging not cleaning up pg_wal directory Justin Swanhart 12:28
psql meta command Marc Millas 12:29
Re: psql meta command Laurenz Albe 12:46
Re: Archive logging not cleaning up pg_wal directory Laurenz Albe 12:48
Re: Archive logging not cleaning up pg_wal directory Ron Johnson 12:48
Re: Archive logging not cleaning up pg_wal directory Justin Swanhart 13:12
Re: Interesting case of IMMUTABLE significantly hurting performance David G. Johnston 14:01
Re: Meson and Numa: C header not found Tom Lane 14:33
Re: Capturing both IP address and hostname in the log Adrian Klaver 15:22
Re: Interesting case of IMMUTABLE significantly hurting performance Adrian Klaver 15:38
Re: Meson and Numa: C header not found Daniel Westermann (DWE) 15:48
Re: Interesting case of IMMUTABLE significantly hurting performance Nico Williams 15:48
Re: Interesting case of IMMUTABLE significantly hurting performance David G. Johnston 15:59
Re: Interesting case of IMMUTABLE significantly hurting performance Adrian Klaver 16:00
Re: Capturing both IP address and hostname in the log Tom Lane 16:00
Re: Meson and Numa: C header not found Tom Lane 16:10
Re: Meson and Numa: C header not found Daniel Westermann (DWE) 16:26
Re: Capturing both IP address and hostname in the log David G. Johnston 16:33
Re: Capturing both IP address and hostname in the log David G. Johnston 16:35
Re: Meson and Numa: C header not found Tom Lane 16:39
Re: Meson and Numa: C header not found Daniel Westermann (DWE) 17:18
Re: Meson and Numa: C header not found Tom Lane 17:45
Re: psql meta command Pavel Luzanov 19:03
Re: psql meta command Christoph Moench-Tegeder 22:41

April 11, 2025

Thread Author Time
Re: Interesting case of IMMUTABLE significantly hurting performance Merlin Moncure 03:18
Re: Interesting case of IMMUTABLE significantly hurting performance Tom Lane 03:51
Re: Meson and Numa: C header not found Daniel Westermann (DWE) 03:57
Re: Interesting case of IMMUTABLE significantly hurting performance David G. Johnston 04:13
Re: Interesting case of IMMUTABLE significantly hurting performance Laurenz Albe 05:15
Re: Interesting case of IMMUTABLE significantly hurting performance Nico Williams 05:30
Re: Interesting case of IMMUTABLE significantly hurting performance Dominique Devienne 07:59
Re: pg_restore causing ENOSPACE on the WAL partition Dimitrios Apostolou 11:38
Re: To take backup of Postgresql Database without large objects [email protected] 12:55
Re: To take backup of Postgresql Database without large objects Ron Johnson 13:29
Re: To take backup of Postgresql Database without large objects Adrian Klaver 15:01
Re: Interesting case of IMMUTABLE significantly hurting performance Merlin Moncure 23:31

April 12, 2025

Thread Author Time
Clarification on the docs Igor Korot 01:48
Re: Clarification on the docs David G. Johnston 02:03
Re: Clarification on the docs Igor Korot 03:08
Re: Clarification on the docs David G. Johnston 03:22
Re: To take backup of Postgresql Database without large objects [email protected] 05:06
Re: To take backup of Postgresql Database without large objects David G. Johnston 05:14
Re: To take backup of Postgresql Database without large objects [email protected] 05:34
Re: To take backup of Postgresql Database without large objects Christophe Pettus 05:37
Re: To take backup of Postgresql Database without large objects Adrian Klaver 06:00
Re: To take backup of Postgresql Database without large objects David G. Johnston 06:05
Re: To take backup of Postgresql Database without large objects [email protected] 07:11
Re: To take backup of Postgresql Database without large objects Adrian Klaver 15:22
Re: Clarification on the docs Tom Lane 17:44
Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Brent Wood 21:21

April 13, 2025

Thread Author Time
Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Achilleas Mantzios 05:13
sorry to bother , this is a test email 📎 贾明伟 13:03
Re: sorry to bother , this is a test email Adrian Klaver 15:24

April 14, 2025

Thread Author Time
ICU Collations and Collation Updates Thomas Michael Engelke 08:28
Event-Triggers for DB owners instead of just SUPERUSER Dominique Devienne 08:50
Re: Event-Triggers for DB owners instead of just SUPERUSER Wolfgang Walther 10:09
Re: Interesting case of IMMUTABLE significantly hurting performance Wolfgang Walther 10:18
TRUNCATE ONLY with foreign keys and triggers disabled Dimitrios Apostolou 10:57
Re: ICU Collations and Collation Updates Laurenz Albe 11:05
Re: Event-Triggers for DB owners instead of just SUPERUSER Dominique Devienne 11:08
Re: ICU Collations and Collation Updates Tom Lane 14:36
Re: TRUNCATE ONLY with foreign keys and triggers disabled Tom Lane 14:45
Re: TRUNCATE ONLY with foreign keys and triggers disabled Dimitrios Apostolou 14:53
Re: TRUNCATE ONLY with foreign keys and triggers disabled Dimitrios Apostolou 15:05
Re: TRUNCATE ONLY with foreign keys and triggers disabled Laurenz Albe 15:07
Re: TRUNCATE ONLY with foreign keys and triggers disabled Adrian Klaver 15:13
Re: TRUNCATE ONLY with foreign keys and triggers disabled Dimitrios Apostolou 15:20
CREATE SCHEMA AUTHORIZATION and ALTER SCHEMA OWNER TO Dominique Devienne 15:21
Re: TRUNCATE ONLY with foreign keys and triggers disabled Adrian Klaver 15:32
Re: TRUNCATE ONLY with foreign keys and triggers disabled Dimitrios Apostolou 16:09
Re: ICU Collations and Collation Updates Jehan-Guillaume de Rorthais 17:18
Re: ICU Collations and Collation Updates Paul Foerster 17:24
Re: ICU Collations and Collation Updates Laurenz Albe 17:36
Re: ICU Collations and Collation Updates Paul Foerster 17:53

April 15, 2025

Thread Author Time
Help with PhD Dissertation Osmel Brito-Bigott 01:27
Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately vijay patil 10:44
Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately KENAN ÇİFTÇİ 11:14
Re: Help with PhD Dissertation Karsten Hilbert 11:20
Re: Help with PhD Dissertation Greg Sabino Mullane 14:31
Identify system databases Igor Korot 14:48
Re: Identify system databases David G. Johnston 14:56
Re: Identify system databases Adrian Klaver 15:07
Re: Help with PhD Dissertation Karsten Hilbert 15:25
Re: Help with PhD Dissertation Osmel Brito-Bigott 15:26
Re: Help with PhD Dissertation Karsten Hilbert 15:28
Fwd: Identify system databases Igor Korot 16:21
Fwd: Identify system databases Igor Korot 16:21
Re: Identify system databases Tom Lane 16:29

Browse Archives

Prev | Next