pgsql-general since 2024-07-09 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 9, 2024

Thread Author Time
RE: [EXTERNAL] Re: SSPI Feature Request 📎 Buoro, John 03:35
Logical Replication - PG_Wall size is too big, What can I do ? Jaurès FOUTE KUETE 06:05
Re: Logical Replication - PG_Wall size is too big, What can I do ? Laurenz Albe 07:42
Re: SQL: Chaining versus Pipelining Laurenz Albe 07:48
autovacuum_vacuum_cost_delay Shenavai, Manuel 11:38
Re: autovacuum_vacuum_cost_delay Muhammad Ikram 13:42
Re: autovacuum_vacuum_cost_delay Christoph Moench-Tegeder 16:23
Finding error in long input file Rich Shepard 22:14
Re: Finding error in long input file Ray O'Donnell 22:26
Re: Finding error in long input file Adrian Klaver 22:29
Re: Finding error in long input file Rich Shepard 22:33
Re: Finding error in long input file Rich Shepard 22:40
Re: Finding error in long input file Rich Shepard 22:46
Re: Finding error in long input file Adrian Klaver 22:52

July 10, 2024

Thread Author Time
Re: Finding error in long input file Craig McIlwee 00:46
can stored procedures with computational sql queries improve API performance? Krishnakant Mane 00:58
Re: can stored procedures with computational sql queries improve API performance? Guyren Howe 01:14
Re: can stored procedures with computational sql queries improve API performance? Krishnakant Mane 01:21
Re: can stored procedures with computational sql queries improve API performance? Guyren Howe 02:38
Re: Finding error in long input file Adrian Klaver 04:58
Re: Finding error in long input file Alban Hertroys 06:57
Postgres :- Could not open R2DBC Connection vimal va 07:48
Re: Postgres :- Could not open R2DBC Connection Kashif Zeeshan 07:52
Re: Postgres :- Could not open R2DBC Connection Matthias Apitz 07:55
Re: Finding error in long input file Rich Shepard 12:30
Re: Finding error in long input file 📎 Rich Shepard 12:52
Re: Finding error in long input file David G. Johnston 12:59
Re: Finding error in long input file Hans Schou 13:01
Re: Finding error in long input file Hans Schou 13:03
Re: can stored procedures with computational sql queries improve API performance? Rob Sargent 13:13
Re: Finding error in long input file Rich Shepard 13:32
Re: Finding error in long input file Rich Shepard 13:33
Re: [EXTERNAL] Re: SSPI Feature Request Peter J. Holzer 14:10
Re: [EXTERNAL] Re: SSPI Feature Request Ian Harding 14:27
Re: can stored procedures with computational sql queries improve API performance? Peter J. Holzer 14:33
Re: [EXTERNAL] Re: SSPI Feature Request Peter J. Holzer 15:03
Re: Finding error in long input file Adrian Klaver 15:05
Re: Finding error in long input file David G. Johnston 15:11
Re: Finding error in long input file Rich Shepard 15:26
Calendar Table 📎 Anthony Apollis 15:38
Re: Calendar Table David G. Johnston 15:48
Detecting PostgreSQL client library Igor Korot 16:05
Re: Detecting PostgreSQL client library Pavel Stehule 16:10
Re: Detecting PostgreSQL client library Igor Korot 16:25
Re: [EXTERNAL] Re: SSPI Feature Request Ian Harding 16:37
Re: Finding error in long input file Rich Shepard 17:06
Re: can stored procedures with computational sql queries improve API performance? Olivier Gautherot 17:33
Dropping column from big table sud 20:13
Re: can stored procedures with computational sql queries improve API performance? Ron Johnson 20:17
Re: can stored procedures with computational sql queries improve API performance? Juan Rodrigo Alejandro Burgos Mella 20:37
Re: Dropping column from big table Adrian Klaver 21:22

July 11, 2024

Thread Author Time
Query on partitioned table needs memory n_partitions * work_mem Dimitrios Apostolou 01:19
Postgresql range_agg() Return empty list 📎 Han Tang 01:37
Re: Query on partitioned table needs memory n_partitions * work_mem David Rowley 02:17
Re: Dropping column from big table sud 03:28
Re: Postgresql range_agg() Return empty list Paul A Jungwirth 04:46
Re: Dropping column from big table Ron Johnson 07:15
Re: Dropping column from big table sud 07:40
Re: Dropping column from big table Laurenz Albe 08:06
Re: Dropping column from big table Ron Johnson 12:36
Re: Dropping column from big table Alvaro Herrera 13:05
Re: Query on partitioned table needs memory n_partitions * work_mem Dimitrios Apostolou 14:08
Re: Query on partitioned table needs memory n_partitions * work_mem Tom Lane 14:43
Running psql in a docker container H 14:57
Re: Postgresql range_agg() Return empty list PetSerAl 15:02
Re: Running psql in a docker container Adrian Klaver 15:06
Re: Query on partitioned table needs memory n_partitions * work_mem Dimitrios Apostolou 15:19
Re: Query on partitioned table needs memory n_partitions * work_mem David G. Johnston 15:22
Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34. Dmitry O Litvintsev 16:57
page is not marked all-visible but visibility map bit is set in relation "pg_statistic" Gus Spier 17:21
Re: Running psql in a docker container H 18:14
Re: Running psql in a docker container Tom Lane 18:20
Re: Running psql in a docker container David G. Johnston 18:24
Re: Running psql in a docker container H 18:28
Re: Running psql in a docker container Adrian Klaver 19:31
Re: Running psql in a docker container Tom Lane 19:48
Re: Running psql in a docker container H 20:25
Re: Running psql in a docker container H 20:28
Re: page is not marked all-visible but visibility map bit is set in relation "pg_statistic" Tomas Vondra 20:38

July 12, 2024

Thread Author Time
Regarding tables detach concurrently with run_maintenance_proc() Durgamahesh Manne 06:45
Semantic cache capability for Postgresql db pradeep t 13:18
Re: Running psql in a docker container felix.quintgz 13:52
Replication lag in Postgres Mukesh Tanuku 15:11
Re: Replication lag in Postgres Laurenz Albe 15:43

July 13, 2024

Thread Author Time
Re: Replication lag in Postgres Mukesh Tanuku 06:02
Re: Replication lag in Postgres Muhammad Imtiaz 09:34
pg_rewind Issue: Trying to read Incorrect WAL file for checkpoint record azeem subhani 11:33
Re: Dropping column from big table Peter J. Holzer 22:05

July 15, 2024

Thread Author Time
Re: Dropping column from big table Laurenz Albe 11:53
How does this FK constraint error happen? Ron Johnson 14:04
Re: Dropping column from big table Peter J. Holzer 14:27
Re: How does this FK constraint error happen? Peter J. Holzer 14:35
Monitoring DB size Shenavai, Manuel 14:42
Re: How does this FK constraint error happen? Ron Johnson 14:53
Re: How does this FK constraint error happen? Adrian Klaver 15:06
Re: How does this FK constraint error happen? Ron Johnson 15:18
Re: Monitoring DB size Muhammad Imtiaz 15:26
Re: How does this FK constraint error happen? Adrian Klaver 15:37
Re: How does this FK constraint error happen? Ron Johnson 16:21
Re: How does this FK constraint error happen? Adrian Klaver 16:47
Re: Monitoring DB size Torsten Förtsch 16:59
Re: How does this FK constraint error happen? Ron Johnson 17:14
Re: How does this FK constraint error happen? Adrian Klaver 17:48
PostgreSQL Active-Active Clustering Sarkar, Subhadeep 19:06
Re: PostgreSQL Active-Active Clustering David G. Johnston 19:20
Re: PostgreSQL Active-Active Clustering Christophe Pettus 19:28
Re: PostgreSQL Active-Active Clustering Ron Johnson 19:55
Re: Dropping column from big table sud 20:30
re-novice coming back to pgsql: porting an SQLite update statement to postgres Dan Kortschak 20:31
Re: PostgreSQL Active-Active Clustering Christoph Moench-Tegeder 21:54

July 16, 2024

Thread Author Time
Re: Dropping column from big table Peter J. Holzer 00:37
Re: PostgreSQL Active-Active Clustering Ron Johnson 02:26
Re: Dropping column from big table sud 04:26
Re: Dropping column from big table David G. Johnston 04:52
Re: Dropping column from big table David G. Johnston 04:56
Re: Dropping column from big table sud 05:04
Re: PostgreSQL Active-Active Clustering Achilleas Mantzios 05:26
Re: PostgreSQL Active-Active Clustering Christophe Pettus 05:38
Re: Dropping column from big table David G. Johnston 05:42
RE: Monitoring DB size Shenavai, Manuel 11:37
RE: Monitoring DB size Shenavai, Manuel 11:38
Code does Not Read in FY 2025 Data 📎 Anthony Apollis 12:53
Re: Code does Not Read in FY 2025 Data Adrian Klaver 14:45
Re: Code does Not Read in FY 2025 Data Anthony Apollis 14:59
Re: Code does Not Read in FY 2025 Data Ray O'Donnell 15:09
Re: Code does Not Read in FY 2025 Data Adrian Klaver 15:13
Re: Code does Not Read in FY 2025 Data Adrian Klaver 15:26
Re: Code does Not Read in FY 2025 Data Adrian Klaver 15:28
Re: Code does Not Read in FY 2025 Data 📎 Anthony Apollis 15:28
Re: Semantic cache capability for Postgresql db Kashif Zeeshan 15:31
Re: Code does Not Read in FY 2025 Data Anthony Apollis 15:34
Re: Code does Not Read in FY 2025 Data Adrian Klaver 15:39
Re: Semantic cache capability for Postgresql db pradeep t 15:49
Re: Code does Not Read in FY 2025 Data Anthony Apollis 15:57
Re: Code does Not Read in FY 2025 Data Adrian Klaver 16:05
Re: Code does Not Read in FY 2025 Data David G. Johnston 16:25

July 17, 2024

Thread Author Time
Qualifying use of separate TABLESPACES (performance/functionality) Imndlf8r 04:45
Re: Qualifying use of separate TABLESPACES (performance/functionality) Christophe Pettus 04:57
Re: Qualifying use of separate TABLESPACES (performance/functionality) Imndlf8r 09:45
Support of Postgresql 15 for Sles15Sp6 Akram Hussain 10:37
PgbackRest and EDB Query KK CHN 12:30
Re: PgbackRest and EDB Query azeem subhani 13:17
Re: Support of Postgresql 15 for Sles15Sp6 Adrian Klaver 14:34
Re: Support of Postgresql 15 for Sles15Sp6 Tom Lane 14:50
Issue with configuration parameter "require_auth" Gaisford, Phillip 15:09
Re: Issue with configuration parameter "require_auth" Tom Lane 15:23
Re: Issue with configuration parameter "require_auth" David G. Johnston 15:27
Re: PgbackRest and EDB Query Kashif Zeeshan 15:37
Re: Issue with configuration parameter "require_auth" Gaisford, Phillip 16:17
Re: Support of Postgresql 15 for Sles15Sp6 Matthias Apitz 16:26
Re: Semantic cache capability for Postgresql db Ron Johnson 16:29
Re: Semantic cache capability for Postgresql db Christophe Pettus 16:52
Re: Issue with configuration parameter "require_auth" Tom Lane 17:11
Planet Postgres and the curse of AI Greg Sabino Mullane 17:21
Re: Planet Postgres and the curse of AI Pavel Stehule 17:41
Re: Planet Postgres and the curse of AI Kashif Zeeshan 17:43
Re: Issue with configuration parameter "require_auth" Gaisford, Phillip 18:58
Re: Planet Postgres and the curse of AI Adrian Klaver 20:48
Re: Query on partitioned table needs memory n_partitions * work_mem David Rowley 22:27
Re: Support of Postgresql 14 for Sles15Sp6 Akram Hussain 22:43
Re: Support of Postgresql 14 for Sles15Sp6 Adrian Klaver 23:08

July 18, 2024

Thread Author Time
Searching for libpq5-13 and libpq5-devel-13 for CentOS/RHEL 7 H 00:36
Re: Searching for libpq5-13 and libpq5-devel-13 for CentOS/RHEL 7 H 00:52
Re: Searching for libpq5-13 and libpq5-devel-13 for CentOS/RHEL 7 Adrian Klaver 00:58
Re: Searching for libpq5-13 and libpq5-devel-13 for CentOS/RHEL 7 H 01:34
psql sslmode behavior and trace_connection_negotiation in PG17 Hao Zhang 04:12
Re: psql sslmode behavior and trace_connection_negotiation in PG17 Tom Lane 04:48
Regarding vacuum freeze locking mechanism Durgamahesh Manne 05:27
Re: Regarding vacuum freeze locking mechanism Kashif Zeeshan 05:28
Re: Regarding vacuum freeze locking mechanism David G. Johnston 05:53
Re: Regarding vacuum freeze locking mechanism David G. Johnston 05:58
Re: Planet Postgres and the curse of AI Laurenz Albe 07:00
Re. Select with where condition times out [email protected] 09:38
Re: Re. Select with where condition times out Kashif Zeeshan 09:42
Re: Regarding vacuum freeze locking mechanism Durgamahesh Manne 10:10
Re: Re. Select with where condition times out Francisco Olarte 11:53
Re: Planet Postgres and the curse of AI Laurenz Albe 12:31
Re: PgbackRest and EDB Query KK CHN 13:19
Re: Planet Postgres and the curse of AI David Rowley 13:33
Re: PgbackRest and EDB Query Ruben Morais 14:03
Re: Planet Postgres and the curse of AI Greg Sabino Mullane 14:25
Re: PgbackRest and EDB Query azeem subhani 17:29

July 19, 2024

Thread Author Time
Re: PgbackRest and EDB Query Kashif Zeeshan 05:05
Re: PgbackRest and EDB Query azeem subhani 05:53
Re: Planet Postgres and the curse of AI Laurenz Albe 07:22
Fwd: Regarding tables detach concurrently with run_maintenance_proc() Durgamahesh Manne 12:48
Re: PgbackRest and EDB Query KK CHN 13:08
Re: Query on partitioned table needs memory n_partitions * work_mem Dimitrios Apostolou 13:31
Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() Christoph Berg 14:25
Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() Durgamahesh Manne 14:56
Re: Fwd: lost master password Afa Jamal 15:59
Re: Query on partitioned table needs memory n_partitions * work_mem Dimitrios Apostolou 19:33

July 20, 2024

Thread Author Time
Regarding publish_via_partiton_root with pglogical Durgamahesh Manne 07:01
Re: Re. Select with where condition times out [email protected] 11:44
Re: Re. Select with where condition times out Ron Johnson 11:58
Re: Re. Select with where condition times out Francisco Olarte 17:24
Re: Re. Select with where condition times out Michael Nolan 19:21
Bloated pg_catalog.pg_largeobjects postgresql 22:45

July 21, 2024

Thread Author Time
Re: Bloated pg_catalog.pg_largeobjects Priancka Chatz 07:16
Windows installation problem at post-install step 📎 Ertan Küçükoglu 16:16

Browse Archives

Prev | Next