pgsql-general since 2022-08-18 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

Aug. 18, 2022

Thread Author Time
Different execution plan between PostgreSQL 8.2 and 12.5 gzh 03:01
Re: Different execution plan between PostgreSQL 8.2 and 12.5 Tom Lane 03:32
Re: Different execution plan between PostgreSQL 8.2 and 12.5 David Rowley 03:38
Re: Different execution plan between PostgreSQL 8.2 and 12.5 Adrian Klaver 04:18
Re: Setting up streaming replication on large database (20+ TB) for the first time Ron 05:53
Unable to Create or Drop Index Concurrently Abdul Qoyyuum 05:57
Re: Unable to Create or Drop Index Concurrently Christophe Pettus 06:05
Is it possible to keep indexes on different disk location? W.P. 06:39
Re: Setting up streaming replication on large database (20+ TB) for the first time Vijaykumar Jain 06:43
Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time Ivan N. Ivanov 07:32
Re: Is it possible to keep indexes on different disk location? hubert depesz lubaczewski 08:58
Re: Unable to Create or Drop Index Concurrently hubert depesz lubaczewski 09:00
Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time Vijaykumar Jain 09:10
Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5 gzh 09:50
ERROR: catalog is missing 3 attribute(s) for relid 150243 milist ujang 10:33
Data caching Anant ngo 10:42
Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5 gzh 11:59
Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5 gzh 12:07
Re: Re: Different execution plan between PostgreSQL 8.2 and 12.5 Torsten Krah 12:22
Re: [(catch-ext)] Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time Ivan N. Ivanov 12:35
Re: Data caching Bruce Momjian 13:57
Re: Is it possible to keep indexes on different disk location? Laurenz Albe 14:46
Re: Different execution plan between PostgreSQL 8.2 and 12.5 Adrian Klaver 14:53
Fwd: Data caching Anant ngo 16:39
Re: Fwd: Data caching Adrian Klaver 19:49
Re: Is it possible to keep indexes on different disk location? W.P. 19:54
SIReadLock vs hot_standby_feedback Christophe Pettus 20:28
Re: ERROR: catalog is missing 3 attribute(s) for relid 150243 milist ujang 22:55

Aug. 19, 2022

Thread Author Time
Re: Is it possible to keep indexes on different disk location? Ron 00:48
Re: Unable to Create or Drop Index Concurrently Abdul Qoyyuum 02:46
Re: ERROR: catalog is missing 3 attribute(s) for relid 150243 Julien Rouhaud 04:02
Re: ERROR: catalog is missing 3 attribute(s) for relid 150243 milist ujang 04:27
Re: ERROR: catalog is missing 3 attribute(s) for relid 150243 Tom Lane 04:42
Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5 gzh 04:42
Monitoring multixact members growth Vido Vlahinic 05:16
Re:Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5 gzh 07:14
RE: Monitoring multixact members growth Vido Vlahinic 07:52
recovery_command has precedence over phisical slots? Giovanni Biscontini 14:54
High Availability PostgresDB on K8s Marco Schmucki 15:09
Re: High Availability PostgresDB on K8s Sumit Sengupta 15:51
Re: recovery_command has precedence over phisical slots? Laurenz Albe 16:37
Re: High Availability PostgresDB on K8s Jan Kohnert 18:09
Re: Monitoring multixact members growth Peter Geoghegan 19:15
Re: Monitoring multixact members growth Jeremy Schneider 23:31

Aug. 20, 2022

Thread Author Time
Support for dates before 4713 BC Watzinger, Alexander 14:05
With Recursive / Recursive View question Perry Smith 22:42

Aug. 21, 2022

Thread Author Time
Re: With Recursive / Recursive View question Christophe Pettus 00:38
Re: ***SPAM*** Re: With Recursive / Recursive View question Perry Smith 02:02
Re: ***SPAM*** Re: With Recursive / Recursive View question Perry Smith 02:48
Re: With Recursive / Recursive View question Peter J. Holzer 17:03
Re: Support for dates before 4713 BC Adrian Klaver 17:15
Re: Support for dates before 4713 BC Peter J. Holzer 17:54
Re: Support for dates before 4713 BC Tom Lane 18:04

Aug. 22, 2022

Thread Author Time
Re: Can I get the number of results plus the results with a single query? Wim Bertels 07:17
Re: Creating constraint dynamically [email protected] 07:29
Re: Creating constraint dynamically Wim Bertels 07:39
Re: Creating constraint dynamically JITEN KUMAR SHAH 08:23
Re: Creating constraint dynamically Francisco Olarte 08:45
Re: Support for dates before 4713 BC stefan eichert 10:14
Re: Creating constraint dynamically jian he 10:23
Re: Support for dates before 4713 BC Alvaro Herrera 10:42
Re: Support for dates before 4713 BC Tom Browder 10:59

Aug. 23, 2022

Thread Author Time
Re: Unable to start replica after failover Kyotaro Horiguchi 06:07
Re: Support for dates before 4713 BC Simon Riggs 09:25
Db log error eswar reddy 10:43
RE: Unable to start replica after failover Lahnov, Igor 12:31
Re: Support for dates before 4713 BC Peter J. Holzer 12:38
Re: Db log error Tom Lane 13:01
Re: Support for dates before 4713 BC Erik Wienhold 14:13
Possible values of DATESTYLE / PGDATESTYLE Sebastien Flaesch 17:08
Re: Possible values of DATESTYLE / PGDATESTYLE Christoph Moench-Tegeder 17:32
Re: Possible values of DATESTYLE / PGDATESTYLE Tom Lane 17:35
Corrupted Postgresql Microsoft Binaries Hillary Masha 18:58
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 19:27
Re: Setting up a server with previous day data Stephen Frost 19:43
Question regarding failover behavior Koen De Groote 23:09

Aug. 24, 2022

Thread Author Time
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario Bryn Llewellyn 00:12
Re: Setting up a server with previous day data Ron 00:15
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario David G. Johnston 00:21
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario Bryn Llewellyn 02:32
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario David G. Johnston 02:50
Re: recovery_command has precedence over phisical slots? Kyotaro Horiguchi 05:18
Re: Unable to start replica after failover Alexander Kukushkin 05:25
Re: Setting up a server with previous day data Peter J. Holzer 06:42
Re: recovery_command has precedence over phisical slots? Laurenz Albe 11:00
RE: Unable to start replica after failover Lahnov, Igor 11:37
Re: Setting up a server with previous day data Ron 13:51
Re: Question regarding failover behavior Koen De Groote 16:17
Re: Corrupted Postgresql Microsoft Binaries Hillary Masha 16:17
Re: recovery_command has precedence over phisical slots? Giovanni Biscontini 16:18
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 18:40
Re: Corrupted Postgresql Microsoft Binaries Hillary Masha 19:22
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 19:57
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 20:09
Two questions about "pg_constraint" Bryn Llewellyn 20:11
Re: Two questions about "pg_constraint" Adrian Klaver 20:17
Re: Two questions about "pg_constraint" Adrian Klaver 20:19
Re: Two questions about "pg_constraint" Adrian Klaver 20:29
Re: Two questions about "pg_constraint" Bryn Llewellyn 20:43
Re: Two questions about "pg_constraint" Tom Lane 20:57
Re: Corrupted Postgresql Microsoft Binaries Hillary Masha 21:01
Re: Corrupted Postgresql Microsoft Binaries Thomas Kellerer 21:23
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 21:24
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 21:36
Re: Two questions about "pg_constraint" Adrian Klaver 22:55
Greg Sabino Mullane ? Re: Two questions about "pg_constraint" Bryn Llewellyn 23:27

Aug. 25, 2022

Thread Author Time
pg_dump without setting search_path gzh 02:50
Re: pg_dump without setting search_path Tom Lane 03:07
Re:Re: pg_dump without setting search_path gzh 03:39
Re: pg_dump without setting search_path David G. Johnston 03:54
Re: pg_dump without setting search_path Adrian Klaver 04:19
Re: Unable to start replica after failover Alexander Kukushkin 05:23
Re:Re: pg_dump without setting search_path gzh 05:56
Re: Two questions about "pg_constraint" Bryn Llewellyn 06:50
Restriction on table partition expressions James Vanns 15:08
Re: Restriction on table partition expressions David Rowley 15:25
Re: Restriction on table partition expressions David Rowley 15:31
Information_schema.table_constraints Ravi Krishna 20:53
Re: Information_schema.table_constraints Adrian Klaver 22:03
Re: Information_schema.table_constraints Ravi Krishna 23:30

Aug. 26, 2022

Thread Author Time
Re: Two questions about "pg_constraint" Bryn Llewellyn 04:43
In a partition why 1st time encounter NULL then call minvfunc jian he 05:40
Re: Two questions about "pg_constraint" Christophe Pettus 05:49
Re: In a partition why 1st time encounter NULL then call minvfunc David G. Johnston 06:28
Re: Restriction on table partition expressions James Vanns 08:50
RE: Unable to start replica after failover Lahnov, Igor 11:43
How to select based on the condition of a column exists Shaozhong SHI 14:01
Re: How to select based on the condition of a column exists David G. Johnston 14:05
Re: Restriction on table partition expressions Ron 14:47
Re: Two questions about "pg_constraint" Bryn Llewellyn 22:33
Re: Two questions about "pg_constraint" Christophe Pettus 23:12

Aug. 27, 2022

Thread Author Time
Re: Two questions about "pg_constraint" Bryn Llewellyn 01:47
Re: Two questions about "pg_constraint" Christophe Pettus 02:02
Re: Two questions about "pg_constraint" Tom Lane 02:19
Re: Two questions about "pg_constraint" Bryn Llewellyn 17:57

Aug. 29, 2022

Thread Author Time
Re: Support logical replication of DDLs 📎 Ajin Cherian 06:14
questions about snapshot building logic Вадим Самохин 11:29
Re: Corrupted Postgresql Microsoft Binaries Hillary Masha 14:50
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 15:09

Aug. 30, 2022

Thread Author Time
RE: Unable to archive logs in standby server Meera Nair 05:22
Re: Unable to start replica after failover Alexander Kukushkin 09:04
Missing query plan for auto_explain. Matheus Martin 10:38
Re: Missing query plan for auto_explain. Alvaro Herrera 11:16
Re: Missing query plan for auto_explain. Julien Rouhaud 12:30
Re: Missing query plan for auto_explain. Matheus Martin 16:26
Re: Missing query plan for auto_explain. Matheus Martin 16:28
Re: Missing query plan for auto_explain. Alvaro Herrera 16:45
Re: Missing query plan for auto_explain. Tom Lane 17:07

Aug. 31, 2022

Thread Author Time
CREATE SUBSCRIPTION not picking up .pgpass while psql does Kristjan Mustkivi 13:03
Re: CREATE SUBSCRIPTION not picking up .pgpass while psql does hubert depesz lubaczewski 13:07
Re: CREATE SUBSCRIPTION not picking up .pgpass while psql does Kristjan Mustkivi 13:26
Re: CREATE SUBSCRIPTION not picking up .pgpass while psql does hubert depesz lubaczewski 13:27
Re: CREATE SUBSCRIPTION not picking up .pgpass while psql does Kristjan Mustkivi 13:39
View definition changes after reloading pg_dump export Wesley Schwengle 18:53

Sept. 1, 2022

Thread Author Time
Feature request for count_estimate(samplesize) aggregate or SAMPLE keyword Torge 01:07
Re: Feature request for count_estimate(samplesize) aggregate or SAMPLE keyword Tom Lane 01:47
Re: Feature request for count_estimate(samplesize) aggregate or SAMPLE keyword Torge 01:49
Vacuum Full is not returning space to OS Sushant Postgres 09:47
Re: Vacuum Full is not returning space to OS Ron 11:57
Re: Vacuum Full is not returning space to OS Daniel Gustafsson 12:01
Re: Vacuum Full is not returning space to OS Ron 12:37
Re: View definition changes after reloading pg_dump export Tom Lane 14:08
Re: View definition changes after reloading pg_dump export Wesley Schwengle 14:35
Re: View definition changes after reloading pg_dump export Ron 14:36
Diffs in PG output vs WAL V 17:14
Re: Diffs in PG output vs WAL Christophe Pettus 17:19
Re: Missing query plan for auto_explain. Matheus Martin 19:20
Bind Parameter is Too Big Kluzak, Matthew C. 20:34
Re: Bind Parameter is Too Big Adrian Klaver 20:46
Re: Bind Parameter is Too Big Tom Lane 20:48
RE: Bind Parameter is Too Big Kluzak, Matthew C. 20:51
Re: Bind Parameter is Too Big Adrian Klaver 20:54
Re: Bind Parameter is Too Big Tom Lane 21:03
How to make PostreSQL utilities honor home directories? Jeffrey Walton 22:01
Re: How to make PostreSQL utilities honor home directories? Adrian Klaver 22:06
Re: How to make PostreSQL utilities honor home directories? Tom Lane 22:16
Re: How to make PostreSQL utilities honor home directories? Adrian Klaver 22:58
Re: How to make PostreSQL utilities honor home directories? Peter 23:04

Sept. 2, 2022

Thread Author Time
Re: How to make PostreSQL utilities honor home directories? Peter J. Holzer 00:23
Re: How to make PostreSQL utilities honor home directories? Jeffrey Walton 00:49
Re: How to make PostreSQL utilities honor home directories? Tom Lane 00:51
Re: How to make PostreSQL utilities honor home directories? Jeffrey Walton 01:31
Re: How to make PostreSQL utilities honor home directories? Ken Tanzer 02:59
Re: How to make PostreSQL utilities honor home directories? Adrian Klaver 04:10
RE: Unable to archive logs in standby server Meera Nair 04:41
Re: Missing query plan for auto_explain. Julien Rouhaud 04:48
Re: Missing query plan for auto_explain. Matheus Martin 09:58
Re: Missing query plan for auto_explain. Peter J. Holzer 11:16
Re: How to make PostreSQL utilities honor home directories? Peter J. Holzer 11:27
Re: How to make PostreSQL utilities honor home directories? Peter J. Holzer 11:34
Re: Unable to archive logs in standby server Christophe Pettus 14:12
Re: How to make PostreSQL utilities honor home directories? Jeffrey Walton 14:55
RE: Unable to archive logs in standby server Meera Nair 16:47
Determine if a user and database are available Jeffrey Walton 21:22
Re: Determine if a user and database are available Christophe Pettus 21:42
Re: Determine if a user and database are available David G. Johnston 22:00
Re: Determine if a user and database are available Tom Lane 22:21

Sept. 3, 2022

Thread Author Time
Re: Determine if a user and database are available Ron 00:33
Re: Determine if a user and database are available Adrian Klaver 00:44
Re: Determine if a user and database are available Tom Lane 00:55

Browse Archives

Prev | Next