[go: up one dir, main page]

pgsql-general - November 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

Nov. 1, 2024

Thread Author Time
Re: What to do with a PAAS-pg server Bruce Momjian 03:42
Re: What to do with a PAAS-pg server Ian Lawrence Barwick 06:07
Re: pg_wal folder high disk usage Muhammad Usman Khan 06:40
Re: Plans for partitioning of inheriting tables thiemo 08:41
Re: pg_wal folder high disk usage Greg Sabino Mullane 13:10
Re: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed user 14:35
Re: Plans for partitioning of inheriting tables Achilleas Mantzios - cloud 15:15
Re: Plans for partitioning of inheriting tables Adrian Klaver 16:47
Re: Plans for partitioning of inheriting tables thiemo 17:21
Re: Plans for partitioning of inheriting tables Adrian Klaver 18:01
Re: Plans for partitioning of inheriting tables Torsten Förtsch 18:43
Re: Plans for partitioning of inheriting tables thiemo 19:14
Re: Plans for partitioning of inheriting tables thiemo 19:16
Re: Plans for partitioning of inheriting tables Adrian Klaver 19:38
Re: Used memory calculation in containers - docker stats and file cache Peter J. Holzer 19:56
Re: Plans for partitioning of inheriting tables Thiemo Kellner 20:47
Re: Plans for partitioning of inheriting tables Adrian Klaver 20:57
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 22:20
Re: Using Expanded Objects other than Arrays from plpgsql 📎 Tom Lane 22:27
Re: Plans for partitioning of inheriting tables thiemo 23:10
Re: Plans for partitioning of inheriting tables Adrian Klaver 23:53

Nov. 2, 2024

Thread Author Time
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 00:50
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 00:53
Re: Plans for partitioning of inheriting tables Thiemo Kellner 07:13
Re: Random memory related errors on live postgres 14.13 instance on Ubuntu 22.04 LTS Ian J Cottee 07:19

Nov. 3, 2024

Thread Author Time
Re: pg_wal folder high disk usage Koen De Groote 13:59
Re: Random memory related errors on live postgres 14.13 instance on Ubuntu 22.04 LTS Vijaykumar Jain 21:27

Nov. 4, 2024

Thread Author Time
Why not do distinct before SetOp ma lz 09:52
Re: Why not do distinct before SetOp David Rowley 11:09
Re: pg_wal folder high disk usage Paul Brindusa 11:53
Re: Used memory calculation in containers - docker stats and file cache Costa Alexoglou 13:35
Re: Why not do distinct before SetOp Tom Lane 15:18
Column name beginning with underscore ("_")? Jim Rosenberg 20:02
Re: Column name beginning with underscore ("_")? Tom Lane 20:10
Re: Column name beginning with underscore ("_")? Adrian Klaver 20:33
Re: Used memory calculation in containers - docker stats and file cache Peter J. Holzer 20:45
nth_value out of more than n values returns null Guyren Howe 23:17
Re: nth_value out of more than n values returns null Adrian Klaver 23:36
Re: nth_value out of more than n values returns null Erik Wienhold 23:36
Re: nth_value out of more than n values returns null Guyren Howe 23:38
Re: nth_value out of more than n values returns null David G. Johnston 23:44
Re: nth_value out of more than n values returns null Guyren Howe 23:46
Re: nth_value out of more than n values returns null David G. Johnston 23:53

Nov. 5, 2024

Thread Author Time
Re: nth_value out of more than n values returns null Tom Lane 00:49
Postgres listens on random port Kal 13:45
Re: Postgres listens on random port Greg Sabino Mullane 14:11
Re: Postgres listens on random port Kal 14:22
Re: Postgres listens on random port Saul Perdomo 14:26
Re: Postgres listens on random port Kal 14:34
Re: Postgres listens on random port Ron Johnson 14:40
Re: Postgres listens on random port Erik Wienhold 14:43
Postgres 12.21? Mark Hill 15:21
Re: Postgres listens on random port Saul Perdomo 15:25
Re: Postgres 12.21? David G. Johnston 15:30
Re: Postgres listens on random port Adrian Klaver 15:46
Switching to NOINHERIT user triggers #XX000 error Dominique Devienne 17:10
Re: Switching to NOINHERIT user triggers #XX000 error Tom Lane 17:42
Re: Switching to NOINHERIT user triggers #XX000 error Dominique Devienne 18:21
Re: Switching to NOINHERIT user triggers #XX000 error Tom Lane 18:25
Re: Switching to NOINHERIT user triggers #XX000 error Dominique Devienne 18:29
adsrc Matt Zagrabelny 21:45
Re: Why not do distinct before SetOp David Rowley 22:11
Re: adsrc Christoph Moench-Tegeder 22:22
Re: adsrc David G. Johnston 22:31
Re: adsrc Ron Johnson 22:44
Re: adsrc Matt Zagrabelny 22:47
Re: Why not do distinct before SetOp Tom Lane 23:09
Re: Why not do distinct before SetOp David Rowley 23:38

Nov. 6, 2024

Thread Author Time
About the stability of COPY BINARY data Dominique Devienne 16:20
Performance Issue with Hash Partition Query Execution in PostgreSQL 16 📎 Ramakrishna m 17:13
Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 Laurenz Albe 18:23
Trouble using pg_rewind to undo standby promotion Craig McIlwee 18:47
Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 David Mullineux 22:11

Nov. 7, 2024

Thread Author Time
Re: Index Partition Size Double of its Table Partition? Don Seiler 03:41
Re: Trouble using pg_rewind to undo standby promotion Torsten Förtsch 09:46
Re: Trouble using pg_rewind to undo standby promotion Craig McIlwee 13:26
Re: About the stability of COPY BINARY data Adrian Klaver 16:37
Advice on cluster architecture for two related, but distinct, use cases Matthias Leisi 16:43
Re: About the stability of COPY BINARY data Dominique Devienne 17:14
Re: About the stability of COPY BINARY data Daniel Verite 17:39
Re: About the stability of COPY BINARY data Dominique Devienne 17:55
Re: About the stability of COPY BINARY data Adrian Klaver 18:04
Re: About the stability of COPY BINARY data Dominique Devienne 18:10
How to recover correctly master and replica using backup made by pg_basebackup? 📎 Evgeniy Ratkov 19:19
Re: Trouble using pg_rewind to undo standby promotion Craig McIlwee 19:42
Advice on cluster architecture for two related, but distinct, use cases Matthias Leisi 21:06
Re: Advice on cluster architecture for two related, but distinct, use cases Zahid Rahman 23:49

Nov. 8, 2024

Thread Author Time
Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 ravi k 03:07
Why plpython functions increase transaction counter much more then plpgsql functions? Michał Albrycht 07:58
Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 David Mullineux 13:39
Re: Why plpython functions increase transaction counter much more then plpgsql functions? Ron Johnson 14:03
Re: Why plpython functions increase transaction counter much more then plpgsql functions? Tom Lane 14:39
Re: Why plpython functions increase transaction counter much more then plpgsql functions? Michał Albrycht 17:44
Can we directly upgrade postgresql from 13 to 15.4 jayesh thakare 18:12
Re: Can we directly upgrade postgresql from 13 to 15.4 Christophe Pettus 18:16
Re: Can we directly upgrade postgresql from 13 to 15.4 Adrian Klaver 20:23

Nov. 9, 2024

Thread Author Time
Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 ravi k 03:45
pgsql_tmp consuming most of the space. jayesh thakare 04:40
Re: pgsql_tmp consuming most of the space. Ron Johnson 05:04
Re: Can we directly upgrade postgresql from 13 to 15.4 Achilleas Mantzios 05:46
Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 David Mullineux 10:10
Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 ravi k 12:02
Bash function from psql (v14) Murthy Nunna 17:41
Re: Bash function from psql (v14) Efrain J. Berdecia 18:02
Re: Bash function from psql (v14) Vijaykumar Jain 18:22

Nov. 10, 2024

Thread Author Time
Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed user 13:18
Re: Bash function from psql (v14) Greg Sabino Mullane 14:55
postgresql-17.0-1 Application - silent installation Issue JOLAPARA Urvi (SAFRAN) 15:11
RE: Bash function from psql (v14) Murthy Nunna 15:21
Re: adsrc Greg Sabino Mullane 16:34
Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed Adrian Klaver 19:07
Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed user 19:52
Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed Adrian Klaver 22:16
Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed Tom Lane 23:44

Nov. 11, 2024

Thread Author Time
Duplicate key error yudhi s 05:40
CREATE SCHEMA ... CREATE M.V. support Kirill Reshke 08:06
Re: Duplicate key error Achilleas Mantzios - cloud 08:27
Re: CREATE SCHEMA ... CREATE M.V. support Alvaro Herrera 10:09
Question About Native Support for SQL:2011 Temporal Tables in PostgreSQL David Lynam 11:23
Re: Advice on cluster architecture for two related, but distinct, use cases Greg Sabino Mullane 14:27
Re: Advice on cluster architecture for two related, but distinct, use cases sunyucong@gmail.com 14:46
Re: postgresql-17.0-1 Application - silent installation Issue Adrian Klaver 16:18
Re: Duplicate key error yudhi s 18:50
Re: Duplicate key error Peter Geoghegan 20:04
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 21:27
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 21:34
create policy statement USING clause Mark Phillips 23:10

Nov. 12, 2024

Thread Author Time
RE: postgresql-17.0-1 Application - silent installation Issue JOLAPARA Urvi (SAFRAN) 06:09
Re: create policy statement USING clause Laurenz Albe 08:48
PostgreSQL logical replication Jayadevan M 10:46
BitmapOr node not used in plan for ANY/IN but is for sequence of ORs ... Jim Vanns 12:43
Re: PostgreSQL logical replication Ron Johnson 14:16
Re: postgresql-17.0-1 Application - silent installation Issue Adrian Klaver 16:35
Re: create policy statement USING clause Mark Phillips 18:54
Re: Duplicate key error yudhi s 20:38
Re: Duplicate key error Peter Geoghegan 20:43

Nov. 13, 2024

Thread Author Time
A million users Kaare Rasmussen 06:45
Fwd: A million users Vijaykumar Jain 07:13
Re: PostgreSQL logical replication Jayadevan M 08:45
Re: Fwd: A million users Alvaro Herrera 10:29
Re: Fwd: A million users Dominique Devienne 10:52
Re: Fwd: A million users Achilleas Mantzios - cloud 11:12
Re: Fwd: A million users Vijaykumar Jain 11:30
Re: Fwd: A million users Vijaykumar Jain 11:40
Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed Alvaro Herrera 11:49
Re: Fwd: A million users Kaare Rasmussen 12:41
Re: Fwd: A million users Alvaro Herrera 13:40
Extract values from XML content celati Laurent 14:58
DB wal file disabled --_Query jayakumar s 16:15
Re: DB wal file disabled --_Query David G. Johnston 16:21
Re: DB wal file disabled --_Query Adrian Klaver 16:24
Re: Fwd: A million users walther 18:01
Re: Extract values from XML content David G. Johnston 18:13
Help with restoring database from old version of PostgreSQL Catherine Frock 18:50
work_mem RAM Accounting in PostgreSQL Alexandru Lazarev 19:09
Re: Help with restoring database from old version of PostgreSQL Ron Johnson 19:47
Re: Extract values from XML content shammat 20:07
Re: Help with restoring database from old version of PostgreSQL Adrian Klaver 20:42

Nov. 14, 2024

Thread Author Time
Row level security policy Mark Phillips 01:33
Re: Row level security policy David G. Johnston 01:36
Re: Row level security policy Mark Phillips 02:13
Re: Row level security policy Mark Phillips 05:05
Retrieve filename within a script Patrick FICHE 08:42
Re: question on audit columns Johannes Lochmann 08:58
RE: postgresql-17.0-1 Application - silent installation Issue JOLAPARA Urvi (SAFRAN) 09:05
Re: DB wal file disabled --_Query jayakumar s 09:14
Re: Row level security policy Laurenz Albe 09:57
Re: Row level security policy Mark Phillips 12:04
Re: DB wal file disabled --_Query David G. Johnston 14:02
Re: work_mem RAM Accounting in PostgreSQL Laurenz Albe 14:40
Re: Help with restoring database from old version of PostgreSQL 📎 Catherine Frock 15:00
Re: postgresql-17.0-1 Application - silent installation Issue Rob Sargent 15:20
Re: Help with restoring database from old version of PostgreSQL Ron Johnson 15:38
Re: question on audit columns Greg Sabino Mullane 16:32
Re: postgresql-17.0-1 Application - silent installation Issue Adrian Klaver 16:45
Re: Help with restoring database from old version of PostgreSQL Adrian Klaver 17:02
Validating check constraints without a table scan? Philip Couling 21:33

Nov. 15, 2024

Thread Author Time
Re: Validating check constraints without a table scan? Laurenz Albe 08:44
DB Files Andy Hartman 14:27
Re: Validating check constraints without a table scan? Torsten Förtsch 15:28
Re: DB Files Adrian Klaver 15:47
Re: Retrieve filename within a script Adrian Klaver 15:48
Re: DB Files Torsten Förtsch 15:49
Re: DB Files Andy Hartman 15:49
Re: Retrieve filename within a script Vincent Veyron 16:29
Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped) Bharani SV-forum 19:46
Re: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped) David G. Johnston 19:56
Re: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped) Adrian Klaver 21:13

Nov. 16, 2024

Thread Author Time
Getting error 42P02, despite query parameter being sent 📎 Max Ulidtko 10:55
Re: Getting error 42P02, despite query parameter being sent Achilleas Mantzios 11:15
Re: Validating check constraints without a table scan? Philip Couling 11:25
Re: Getting error 42P02, despite query parameter being sent Adrian Klaver 16:09
Re: Getting error 42P02, despite query parameter being sent Tom Lane 16:51

Nov. 17, 2024

Thread Author Time
Re: Getting error 42P02, despite query parameter being sent Max Ulidtko 10:09
Re: Getting error 42P02, despite query parameter being sent Adrian Klaver 17:05
Re: Getting error 42P02, despite query parameter being sent David G. Johnston 17:18
Re: Getting error 42P02, despite query parameter being sent Achilleas Mantzios 19:44
Re: Getting error 42P02, despite query parameter being sent Adrian Klaver 22:02

Nov. 18, 2024

Thread Author Time
Re : Credcheck extension 張宸瑋 09:03
Re: Re : Credcheck extension Julien Rouhaud 09:36

Browse Archives

Prev | Next