pgsql-general - September 2024

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

Sept. 1, 2024

Thread Author Time
Re: Upgrade Ubuntu 22 -> 24 may break PostgreSQL Justin Clift 02:32
Re: Partitioning and unique key veem v 03:06
Re: Partitioning and unique key David G. Johnston 03:43
Re: Partitioning and unique key veem v 04:33
Re: Partitioning and unique key veem v 06:08
Re: Partitioning and unique key veem v 12:14
Re: Upgrade Ubuntu 22 -> 24 may break PostgreSQL Adrian Klaver 16:08
Re: Postgres Logical Replication - how to see what subscriber is doing with received data? Shaheed Haque 16:22
Re: Upgrade Ubuntu 22 -> 24 may break PostgreSQL Adrian Klaver 16:22
How to grant role to other user Andrus 19:28
PG17 optimizations to vacuum Pavel Luzanov 21:44
Re: PG17 optimizations to vacuum Peter Geoghegan 22:00

Sept. 2, 2024

Thread Author Time
Could we go back in a replication slot? xiong ding 01:48
Re: Postgres Logical Replication - how to see what subscriber is doing with received data? Muhammad Ikram 06:08
Re: Postgres Logical Replication - how to see what subscriber is doing with received data? Shaheed Haque 07:42
Re: Postgres Logical Replication - how to see what subscriber is doing with received data? Muhammad Ikram 08:45
Issue with Restore dump with plpythonu, plpython3u installed on postgres16 Sam Son 11:37
Re: Postgres Logical Replication - how to see what subscriber is doing with received data? Shaheed Haque 13:27
Re: Partitioning and unique key Laurenz Albe 13:43
Re: Partitioning and unique key veem v 16:09
Re: PG17 optimizations to vacuum Melanie Plageman 17:28
Re: PG17 optimizations to vacuum Peter Geoghegan 17:47
Re: PG17 optimizations to vacuum Melanie Plageman 19:23
Re: PG17 optimizations to vacuum Peter Geoghegan 19:42
Re: Partitioning and unique key Laurenz Albe 19:44
Re: PG17 optimizations to vacuum Pavel Luzanov 20:35
Re: PG17 optimizations to vacuum Heikki Linnakangas 20:58
Re: PG17 optimizations to vacuum Peter Geoghegan 20:58
Re: PG17 optimizations to vacuum Peter Geoghegan 21:01
Re: PG17 optimizations to vacuum Heikki Linnakangas 21:11
Re: PG17 optimizations to vacuum Peter Geoghegan 21:17
Re: PG17 optimizations to vacuum Heikki Linnakangas 21:23

Sept. 3, 2024

Thread Author Time
Re: Partitioning and unique key veem v 05:09
Re: Partitioning and unique key Laurenz Albe 05:53
Re: PG17 optimizations to vacuum Pavel Luzanov 07:34
Re: PG17 optimizations to vacuum Heikki Linnakangas 10:04
Re: Monitoring logical replication Shaheed Haque 13:01
Re: How to grant role to other user Dominique Devienne 14:49
Re: How to grant role to other user Tom Lane 14:53
Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16 Adrian Klaver 15:16
Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16 Muhammad Usman Khan 16:25
Table and data comparison arun chirappurath 16:34
Re: Table and data comparison David Mullineux 16:36
Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16 Adrian Klaver 16:37
Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16 Adrian Klaver 17:01
Re: Table and data comparison Ron Johnson 17:31

Sept. 4, 2024

Thread Author Time
Help with "gpg -d ... | pg_restore ..." with unimportant pg_restore errors raf 01:32
Re: Help with "gpg -d ... | pg_restore ..." with unimportant pg_restore errors David G. Johnston 01:43
Re: Help with "gpg -d ... | pg_restore ..." with unimportant pg_restore errors raf 02:23
Re: Help with "gpg -d ... | pg_restore ..." with unimportant pg_restore errors Tom Lane 02:28
Re: Help with "gpg -d ... | pg_restore ..." with unimportant pg_restore errors raf 02:39
Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16 Sam Son 10:48
libpq15 with postgres server16 and scram-sha-256 MM 10:54
Re: libpq15 with postgres server16 and scram-sha-256 Laurenz Albe 11:24
question on audit columns yudhi s 12:49
Re: question on audit columns Muhammad Usman Khan 12:58
Re: question on audit columns yudhi s 13:10
Re: question on audit columns Khan Muhammad Usman 13:17
Re: question on audit columns Ron Johnson 14:31
Re: question on audit columns Adrian Klaver 14:36
Re: question on audit columns Tim Clarke 14:48
Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16 Adrian Klaver 15:04
Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16 Sam Son 17:46
Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16 Adrian Klaver 22:20

Sept. 5, 2024

Thread Author Time
Please remove plm@mipta.com from the List Peter L Martin 01:29
Remove from distribution list Peter L Martin 01:37
Re: Please remove plm@mipta.com from the List Adrian Klaver 02:29
Is there a way to change email for subscription ? Muhammad Ikram 04:09
Re: Is there a way to change email for subscription ? Abdul Qoyyuum 06:15
Re: Is there a way to change email for subscription ? Muhammad Ikram 06:30
Using left joins instead of inner joins as an optimization Xavier Solomon 16:58
Re: question on audit columns Vincent Veyron 17:32
Faster data load Lok P 20:14
Re: Faster data load Ron Johnson 21:45
Re: Faster data load Jeff Ross 22:21

Sept. 6, 2024

Thread Author Time
Re: Faster data load Muhammad Usman Khan 03:49
Re: Faster data load Lok P 04:42
Re: Faster data load Ron Johnson 05:12
Re: Is there a way to change email for subscription ? Arbol One 10:53
Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16 Sam Son 12:58
barman with postgres server/s postgr user 13:24
Re: Using left joins instead of inner joins as an optimization David Rowley 13:24
Re: Using left joins instead of inner joins as an optimization Greg Sabino Mullane 13:50
Re: Is there a way to change email for subscription ? Alvaro Herrera 15:19
Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16 Adrian Klaver 19:58

Sept. 7, 2024

Thread Author Time
Foreign Data Wrappers Gus Spier 00:55
Re: Foreign Data Wrappers Christophe Pettus 01:29
Re: Foreign Data Wrappers Ian Lawrence Barwick 01:32
Re: Foreign Data Wrappers Tom Lane 01:35
Re: Foreign Data Wrappers Gus Spier 01:41
Re: Foreign Data Wrappers Brent Wood 02:40
Re: barman with postgres server/s Muhammad Usman Khan 05:34
How effectively do the indexing in postgres in such cases sud 09:29

Sept. 8, 2024

Thread Author Time
How to cleanup transaction after statement_timeout aborts a query? Istvan Soos 10:56
Re: How to cleanup transaction after statement_timeout aborts a query? Laurenz Albe 11:18
Re: How to cleanup transaction after statement_timeout aborts a query? Istvan Soos 13:01
Re: How to cleanup transaction after statement_timeout aborts a query? Laurenz Albe 13:41
Re: How to cleanup transaction after statement_timeout aborts a query? Istvan Soos 14:02
Re: How to cleanup transaction after statement_timeout aborts a query? Laurenz Albe 14:18
Re: Faster data load Peter J. Holzer 17:45
Re: Faster data load Adrian Klaver 18:26
postgresql FDW vs dblink for DDL Achilleas Mantzios 20:04
Re: postgresql FDW vs dblink for DDL Adrian Klaver 20:46

Sept. 9, 2024

Thread Author Time
Re: Faster data load Dominique Devienne 07:25
Connection between PostgreSQL and SAP HANA database 07:53
Re: postgresql FDW vs dblink for DDL Achilleas Mantzios - cloud 10:24
ssh to DB server and su normal users very slow : KK CHN 11:20
Clarify this MERGE warning? "Only columns from the target table that attempt to match data_source rows should appear in join_condition." Philip Hazelden 13:02
Strange permission effect depending on DEFERRABILITY Achilleas Mantzios - cloud 13:14
Re: ssh to DB server and su normal users very slow : KK CHN 13:18
Re: ssh to DB server and su normal users very slow : Achilleas Mantzios - cloud 13:35
Re: Strange permission effect depending on DEFERRABILITY Tom Lane 14:21
Logical replication without direct link between publisher and subscriber? Koen De Groote 14:36
infinite loop in an update statement Fabrice Chapuis 14:55
Re: Strange permission effect depending on DEFERRABILITY Achilleas Mantzios - cloud 14:59
Re: infinite loop in an update statement Tom Lane 15:00
Re: infinite loop in an update statement Adrian Klaver 15:00
Re: Connection between PostgreSQL and SAP HANA database Adrian Klaver 15:06
Re: postgresql FDW vs dblink for DDL Adrian Klaver 15:31
Re: How effectively do the indexing in postgres in such cases Greg Sabino Mullane 15:33
Connection between PostgreSQL and SAP HANA database 15:35
Re: postgresql FDW vs dblink for DDL Tom Lane 15:40
Re: ssh to DB server and su normal users very slow : Thiemo Kellner 15:54
Re: Clarify this MERGE warning? "Only columns from the target table that attempt to match data_source rows should appear in join_condition." Adrian Klaver 16:17
Re: postgresql FDW vs dblink for DDL Achilleas Mantzios 16:56
Re: Strange permission effect depending on DEFERRABILITY Laurenz Albe 21:09

Sept. 10, 2024

Thread Author Time
Check used privilege in a statment Ahmed Ibrahim 04:22
Re: Check used privilege in a statment Tom Lane 06:08
Database schema for "custom fields" Matthias Leisi 06:57
Re: Database schema for "custom fields" Muhammad Usman Khan 07:08
Re: Database schema for "custom fields" Peter J. Holzer 09:11
Re: Strange permission effect depending on DEFERRABILITY Achilleas Mantzios - cloud 09:20
Re: Database schema for "custom fields" Shaheed Haque 12:08
Error:could not extend file " with FileFallocate(): No space left on device Pecsök Ján 13:11
Re: infinite loop in an update statement Adrian Klaver 14:57
Removing duplicate rows in table Rich Shepard 15:07
Re: Removing duplicate rows in table Christophe Pettus 15:10
Re: Removing duplicate rows in table Ron Johnson 15:16
Re: Removing duplicate rows in table Adrian Klaver 15:22
Re: Removing duplicate rows in table Andreas Kretschmer 15:28
Re: Removing duplicate rows in table Rich Shepard 15:29
Re: Removing duplicate rows in table Rich Shepard 15:32
Re: Removing duplicate rows in table Rich Shepard 15:33
Re: Removing duplicate rows in table Rich Shepard 15:35
Re: Removing duplicate rows in table Adrian Klaver 15:45
Re: Removing duplicate rows in table Francisco Olarte 16:03
Re: Removing duplicate rows in table Rich Shepard 16:38
Re: Removing duplicate rows in table Rich Shepard 16:46
Re: Strange permission effect depending on DEFERRABILITY Laurenz Albe 17:22
Re: Strange permission effect depending on DEFERRABILITY Achilleas Mantzios 17:41
Overlapping values (?) in multi-column partitioned tables Christophe Pettus 22:13
Re: Overlapping values (?) in multi-column partitioned tables Brent Wood 22:23
Re: Overlapping values (?) in multi-column partitioned tables Christophe Pettus 22:30
Re: Overlapping values (?) in multi-column partitioned tables Laurenz Albe 22:57
Re: Overlapping values (?) in multi-column partitioned tables David Rowley 23:02
Re: Overlapping values (?) in multi-column partitioned tables Christophe Pettus 23:05
Re: Overlapping values (?) in multi-column partitioned tables Christophe Pettus 23:05
Re: Test mail for pgsql-general Chris Miller 23:21
Re: Test mail for pgsql-general David G. Johnston 23:26
Re: Test mail for pgsql-general Adrian Klaver 23:27
Re: Removing duplicate rows in table Erik Wienhold 23:34

Sept. 11, 2024

Thread Author Time
Re: Test mail for pgsql-general Chris Miller 01:50
Re: Test mail for pgsql-general Chris Miller 01:51
Performance degrade on insert on conflict do nothing Durgamahesh Manne 05:05
Recommendations on improving the insert on conflict do nothing performance Durgamahesh Manne 08:53
Re: Error:could not extend file " with FileFallocate(): No space left on device 📎 Alvaro Herrera 09:55
Re: infinite loop in an update statement Fabrice Chapuis 10:14
Re: Error:could not extend file " with FileFallocate(): No space left on device Thomas Munro 10:44
RE: Error:could not extend file " with FileFallocate(): No space left on device Pecsök Ján 10:48
Re: infinite loop in an update statement Greg Sabino Mullane 12:29
Re: Error:could not extend file " with FileFallocate(): No space left on device Alvaro Herrera 12:39
Re: Ghost data from failed FDW transactions? Greg Sabino Mullane 12:57
Re: Logical replication without direct link between publisher and subscriber? Greg Sabino Mullane 13:19
Re: Database schema for "custom fields" Greg Sabino Mullane 13:24
RE: Error:could not extend file " with FileFallocate(): No space left on device Pecsök Ján 13:31
Re: Performance degrade on insert on conflict do nothing Greg Sabino Mullane 13:41
Backward compat issue with v16 around ROLEs Dominique Devienne 14:41
Re: Backward compat issue with v16 around ROLEs David G. Johnston 15:06
Re: Backward compat issue with v16 around ROLEs Adrian Klaver 15:09
Re: Backward compat issue with v16 around ROLEs Dominique Devienne 15:22
Re: Backward compat issue with v16 around ROLEs Dominique Devienne 15:28
Re: Backward compat issue with v16 around ROLEs Wolfgang Walther 19:17
Re: Backward compat issue with v16 around ROLEs David G. Johnston 19:21
Re: Backward compat issue with v16 around ROLEs Pavel Luzanov 20:20
Re: Error:could not extend file " with FileFallocate(): No space left on device Thomas Munro 21:36
Re: Backward compat issue with v16 around ROLEs Tom Lane 21:39
Re: Error:could not extend file " with FileFallocate(): No space left on device Thomas Munro 22:21

Sept. 12, 2024

Thread Author Time
Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC Andreas Joseph Krogh 03:41
Re: Removing duplicate rows in table Muhammad Usman Khan 04:06
Re: Recommendations on improving the insert on conflict do nothing performance Muhammad Usman Khan 04:35
Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC Tom Lane 04:36
Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC Brent Wood 04:48
Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC Andreas Joseph Krogh 04:51
RE: Error:could not extend file " with FileFallocate(): No space left on device Pecsök Ján 08:54
post-bootstrap init : permission denied pg_description François SIMON 10:58
Re: Backward compat issue with v16 around ROLEs Dominique Devienne 12:13
Re: Backward compat issue with v16 around ROLEs Dominique Devienne 12:40
Re: Removing duplicate rows in table Rich Shepard 12:41
Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC Greg Sabino Mullane 13:05
Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC Dominique Devienne 13:11

Browse Archives

Prev | Next