pgsql-general - July 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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 21 22 23 24 25 26 28 29 30 31

July 1, 2025

Thread Author Time
Re: Simulate a PITR in postgresql 16 raphi 04:35
The same query_id for different queries 📎 Maksim Gorkov 07:24
Re: The same query_id for different queries Michael Paquier 08:16
Re: The same query_id for different queries Maksim Gorkov 15:08
Fwd: Anomalous behavior between two Aurora Postgres RDS clusters Amritanshu Joshi 19:48

July 2, 2025

Thread Author Time
PLPGSQL - store fetched records in array of record Durumdara 12:21
Re: PLPGSQL - store fetched records in array of record David G. Johnston 13:23
Re: PLPGSQL - store fetched records in array of record Ron Johnson 13:29
Re: PLPGSQL - store fetched records in array of record Durumdara 14:26
Re: Simulate a PITR in postgresql 16 Franklin Anderson de Oliveira Souza 14:32
Postgresql support for Windows Server 2025 Gaurav Aradhya 14:42
Re: Postgresql support for Windows Server 2025 David G. Johnston 15:38
Re: Postgresql support for Windows Server 2025 Adrian Klaver 15:42
Re: Postgresql support for Windows Server 2025 Laurenz Albe 16:01
Re: PLPGSQL - store fetched records in array of record Adrian Klaver 16:25
Foreign Data Wrapper from Oracle to Postgres 16 Santhosh S 18:28

July 3, 2025

Thread Author Time
Re: Foreign Data Wrapper from Oracle to Postgres 16 Laurenz Albe 06:50
Corrupt btree index includes rows that don't match Erik Johnston 17:07

July 4, 2025

Thread Author Time
Re: Emitting JSON to file using COPY TO 📎 jian he 05:27
Re: Corrupt btree index includes rows that don't match shammat 09:50
Re: Corrupt btree index includes rows that don't match Ron Johnson 10:05
Re: Corrupt btree index includes rows that don't match shammat 10:07
Re: Foreign Data Wrapper from Oracle to Postgres 16 DINESH NAIR 13:44
Re: Corrupt btree index includes rows that don't match Erik Johnston 13:49
Re: Corrupt btree index includes rows that don't match Ron Johnson 14:38
Re: Corrupt btree index includes rows that don't match Erik Johnston 14:59
Re: Corrupt btree index includes rows that don't match Tom Lane 15:41

July 5, 2025

Thread Author Time
pg_upgrade: can I use same binary for old & new? Pierre Fortin 16:52
Re: pg_upgrade: can I use same binary for old & new? David G. Johnston 17:00
Re: pg_upgrade: can I use same binary for old & new? Tom Lane 17:04
Re: pg_upgrade: can I use same binary for old & new? pf 18:05
Re: pg_upgrade: can I use same binary for old & new? Adrian Klaver 18:11
Re: pg_upgrade: can I use same binary for old & new? Ron Johnson 18:19
Re: pg_upgrade: can I use same binary for old & new? pf 18:24
Re: pg_upgrade: can I use same binary for old & new? Tom Lane 18:30
Re: pg_upgrade: can I use same binary for old & new? Ron Johnson 19:10
Re: pg_upgrade: can I use same binary for old & new? Pierre Fortin 19:19
Re: pg_upgrade: can I use same binary for old & new? Tom Lane 19:27
Re: pg_upgrade: can I use same binary for old & new? Ron Johnson 19:29
Re: pg_upgrade: can I use same binary for old & new? Adrian Klaver 19:58
Re: pg_upgrade: can I use same binary for old & new? Adrian Klaver 20:06
Re: pg_upgrade: can I use same binary for old & new? Adrian Klaver 20:23
Re: pg_upgrade: can I use same binary for old & new? Pierre Fortin 21:11

July 6, 2025

Thread Author Time
Logical Replication 08P01 invalid memory alloc request size 1095736448 Soni M 09:40
Re: Logical Replication 08P01 invalid memory alloc request size 1095736448 Soni M 12:41
Re: Logical Replication 08P01 invalid memory alloc request size 1095736448 Tom Lane 15:12
Re: Logical Replication 08P01 invalid memory alloc request size 1095736448 Soni M 15:15

July 7, 2025

Thread Author Time
Re: analyze-in-stages post upgrade questions Mircea Cadariu 12:43

July 8, 2025

Thread Author Time
error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin abrahim abrahao 17:54

July 9, 2025

Thread Author Time
Re: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin Shlok Kyal 06:49
Re: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin Shlok Kyal 08:27
RE: analyze-in-stages post upgrade questions Zechman, Derek S 11:30
Password Encryption and Connection Issues Alpaslan AKDAĞ 13:56
PostgresSQL Setup error Jordan Adams 14:06
Re: Password Encryption and Connection Issues David G. Johnston 14:06
Re: Password Encryption and Connection Issues Greg Sabino Mullane 14:58
Re: Password Encryption and Connection Issues Ron Johnson 15:09
Re: Password Encryption and Connection Issues Adrian Klaver 15:11
Re: Password Encryption and Connection Issues Ron Johnson 15:17
Re: Password Encryption and Connection Issues David G. Johnston 15:25
Re: analyze-in-stages post upgrade questions Laurenz Albe 15:26
Re: Password Encryption and Connection Issues Laurenz Albe 15:28
Re: Password Encryption and Connection Issues Ron Johnson 15:50
Re: PostgresSQL Setup error Laurenz Albe 16:03
Re: PostgresSQL Setup error Adrian Klaver 16:12
Re: analyze-in-stages post upgrade questions Mircea Cadariu 16:37
Re: Password Encryption and Connection Issues Greg Sabino Mullane 17:02
Re: Corrupt btree index includes rows that don't match Erik Johnston 17:02
Re: analyze-in-stages post upgrade questions Laurenz Albe 17:22
Re: Corrupt btree index includes rows that don't match Peter Geoghegan 18:31

July 10, 2025

Thread Author Time
RE: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin Hayato Kuroda (Fujitsu) 02:18
Aggregate versions of hashing functions (md5, sha1, etc...) Dominique Devienne 11:48
Lock timeout in commit Steve Baldwin 12:01
Re: PostgresSQL Setup error DINESH NAIR 14:22
Re: Lock timeout in commit Tom Lane 15:28
Re: analyze-in-stages post upgrade questions Mircea Cadariu 16:20
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Adrian Klaver 16:25
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Ron Johnson 17:11
Re: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin abrahim abrahao 17:33
having temp_tablespaces on less reliable storage Dimitrios Apostolou 17:58
Re: having temp_tablespaces on less reliable storage David G. Johnston 18:04
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Merlin Moncure 19:02
optimizing number of workers Greg Hennessy 19:39
Re: Lock timeout in commit Steve Baldwin 20:32

July 11, 2025

Thread Author Time
RE: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin Hayato Kuroda (Fujitsu) 02:09
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Dominique Devienne 08:49
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Dominique Devienne 09:00
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Dominique Devienne 09:10
Re: analyze-in-stages post upgrade questions 📎 Laurenz Albe 09:51
Re: analyze-in-stages post upgrade questions Mircea Cadariu 10:42
Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication Kiran K V 11:38
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Ron Johnson 11:46
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Dominique Devienne 12:11
Question Regarding COPY Command Handling of Line Breaks in PostgreSQL gzh 12:20
Re: Question Regarding COPY Command Handling of Line Breaks in PostgreSQL Ron Johnson 13:07
Re: having temp_tablespaces on less reliable storage Dimitrios Apostolou 14:46
Re: having temp_tablespaces on less reliable storage Ron Johnson 15:08
Re: Question Regarding COPY Command Handling of Line Breaks in PostgreSQL Adrian Klaver 15:14
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Adrian Klaver 15:27
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Florents Tselai 16:03
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Adrian Klaver 16:15
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Dominique Devienne 16:16
I have a suspicious query Edmundo Robles 17:12
Re: I have a suspicious query Adrian Klaver 17:23
Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication Kiran K V 17:39
Re: optimizing number of workers Weck, Luis 18:11
Re: I have a suspicious query Greg Sabino Mullane 18:43
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Merlin Moncure 20:30
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Adrian Klaver 21:00
Re: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin abrahim abrahao 21:55
Re: Aggregate versions of hashing functions (md5, sha1, etc...) Merlin Moncure 22:57
Re: I have a suspicious query Merlin Moncure 22:59

July 12, 2025

Thread Author Time
Re: I have a suspicious query Matthias Apitz 13:23
Re: I have a suspicious query Ron Johnson 14:23

July 14, 2025

Thread Author Time
Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Amol Inamdar 05:49
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Laurenz Albe 12:20
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Amol Inamdar 12:29
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Laurenz Albe 12:44
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Amol Inamdar 13:02
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Tom Lane 14:07
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Laurenz Albe 14:41
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Peter J. Holzer 18:20
Re: optimizing number of workers Greg Hennessy 18:25
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Tom Lane 18:30
Re: optimizing number of workers Tom Lane 18:54
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Benjamin Wang 19:02
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) David G. Johnston 19:08
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Tom Lane 19:10
Syntax error needs explanation Rich Shepard 19:12
Re: Syntax error needs explanation David G. Johnston 19:14
Re: Syntax error needs explanation [RESOLVED] Rich Shepard 19:19
Re: Syntax error needs explanation Adrian Klaver 19:36
Re: Syntax error needs explanation Adrian Klaver 19:45
Performance of JSON type in postgres veem v 19:51
Re: Performance of JSON type in postgres Adrian Klaver 19:54
Re: Syntax error needs explanation David G. Johnston 19:56
Re: Syntax error needs explanation Rich Shepard 19:59
Re: Performance of JSON type in postgres David G. Johnston 20:00
Re: Syntax error needs explanation David G. Johnston 20:07
Re: Syntax error needs explanation [RESOLVED] Rich Shepard 20:13

July 15, 2025

Thread Author Time
RE: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin Hayato Kuroda (Fujitsu) 03:09
Re: Syntax error needs explanation [RESOLVED] Laurenz Albe 05:46
Re: Syntax error needs explanation [RESOLVED] David G. Johnston 05:55
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Laurenz Albe 06:02
Regarding query optimisation (select for update) Durgamahesh Manne 10:10
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Amol Inamdar 11:35
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Amol Inamdar 11:36
Re: Syntax error needs explanation [RESOLVED] Rich Shepard 12:40
Re: Regarding query optimisation (select for update) Laurenz Albe 12:43
Re: Regarding query optimisation (select for update) Durgamahesh Manne 12:56
Re: Regarding query optimisation (select for update) Andy Huang 13:05
Re: Regarding query optimisation (select for update) Laurenz Albe 14:06
Re: Regarding query optimisation (select for update) Tom Lane 14:45
Re: query_id: jumble names of temp tables for better pg_stat_statement UX Alexander Kukushkin 14:48
Re: Regarding query optimisation (select for update) Greg Sabino Mullane 14:51
Re: optimizing number of workers Greg Hennessy 17:07
Removing terminal period from varchar string in table column Rich Shepard 17:30
Re: Performance of JSON type in postgres Merlin Moncure 17:32
Re: Removing terminal period from varchar string in table column Jeff Ross 17:43
Re: Removing terminal period from varchar string in table column Thom Brown 17:46
Re: Removing terminal period from varchar string in table column Rich Shepard 17:59
Re: Removing terminal period from varchar string in table column Rich Shepard 18:02
Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication DINESH NAIR 18:13
Re: Removing terminal period from varchar string in table column Thom Brown 18:19
Re: Removing terminal period from varchar string in table column Rich Shepard 20:15
Re: query_id: jumble names of temp tables for better pg_stat_statement UX Michael Paquier 23:39

July 16, 2025

Thread Author Time
Re: Query regarding support of test_decoding and PGReplicationStream with Standby Logical Replication Kiran K V 00:53
Re: query_id: jumble names of temp tables for better pg_stat_statement UX Alexander Kukushkin 06:20
PgBouncer-Postgres : un supported startup parameter statement_timeout KK CHN 07:22
Re: PgBouncer-Postgres : un supported startup parameter statement_timeout Achilleas Mantzios 07:40
Re: PgBouncer-Postgres : un supported startup parameter statement_timeout Robert Sjöblom 07:47
Re: PgBouncer-Postgres : un supported startup parameter statement_timeout Achilleas Mantzios 08:30
Re:Question Regarding COPY Command Handling of Line Breaks in PostgreSQL gzh 13:02
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Amol Inamdar 13:24
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Ron Johnson 14:17
Re: PgBouncer-Postgres : un supported startup parameter statement_timeout Adrian Klaver 15:29
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Laurenz Albe 15:48

July 17, 2025

Thread Author Time
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Greg Sabino Mullane 00:41
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Amol Inamdar 04:52
Re: query_id: jumble names of temp tables for better pg_stat_statement UX Lukas Fittl 05:06
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Tom Lane 05:14
Re: Bypassing Directory Ownership Check in PostgreSQL 16.6 with Secure z/OS NFS (AT-TLS) Ron Johnson 13:13
PostgreSQL on S3-backed Block Storage with Near-Local Performance Pierre Barre 22:57

July 18, 2025

Thread Author Time
Should we document the cost of pg_database_size()? Alternatives? Craig Ringer 00:54
Re: Should we document the cost of pg_database_size()? Alternatives? Craig Ringer 02:10
Re: Should we document the cost of pg_database_size()? Alternatives? Ron Johnson 03:34
Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance Laurenz Albe 04:40
Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance Pierre Barre 09:59
Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance Seref Arikan 10:42
Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance Pierre Barre 10:57
Regarding logical replication issues with PostgreSQL versions 16 and above yexiu-glory 11:08
Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance Pierre Barre 12:31
PgBouncer Prepared Statement ERROR KK CHN 12:52
Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance Seref Arikan 12:55
Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance Pierre Barre 13:11
Re: PgBouncer Prepared Statement ERROR Greg Sabino Mullane 13:32
Re: PgBouncer Prepared Statement ERROR Laurenz Albe 13:34
Re: Regarding logical replication issues with PostgreSQL versions 16 and above Laurenz Albe 13:40
Possible causes of high_replay lag, given replication settings? Jon Zeppieri 20:29

July 19, 2025

Thread Author Time
Re: Performance of JSON type in postgres veem v 20:39

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 21 22 23 24 25 26 28 29 30 31