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

Browse Archives

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

March 1, 2024

Thread Author Time
Re: walreceiver fails on asynchronous replica [EXTERNAL] [SEC=UNOFFICIAL] Kyotaro Horiguchi 01:37
Re: Content for talk on Postgres Type System at PostgresConf Laurenz Albe 09:18
Re: FW: SUSE repositories not longer available Devrim Gündüz 10:57
RE: Unable to get PostgreSQL 15 with Kerberos (GSS) working Matthew Dennison 11:16
Re: Excel Source [24]] Error: System.Exception: SqlTruncateException: Numeric arithmetic causes felix.quintgz 13:15
Re: Content for talk on Postgres Type System at PostgresConf Adrian Klaver 16:14
Re: Content for talk on Postgres Type System at PostgresConf grimy.outshine830 19:27
Re: Content for talk on Postgres Type System at PostgresConf Adrian Klaver 20:15
Re: Content for talk on Postgres Type System at PostgresConf Tom Lane 20:25
How to clone a database? normandavis1990 20:29
Re: High Availability and Replication normandavis1990 20:36
Re: High Availability and Replication Israel Brewster 20:44
Re: High Availability and Replication Abdul Sayeed 21:54

March 2, 2024

Thread Author Time
Re: High Availability and Replication normandavis1990 06:48
Re: High Availability and Replication normandavis1990 06:50
Guarantees/Semantics of pg_stats Baziotis, Stefanos 07:41
Re: High Availability and Replication Abdul Sayeed 09:16
Re: Guarantees/Semantics of pg_stats Laurenz Albe 10:28
Re: Content for talk on Postgres Type System at PostgresConf Laurenz Albe 10:32
Re: Content for talk on Postgres Type System at PostgresConf grimy.outshine830 19:58
Re: Guarantees/Semantics of pg_stats Baziotis, Stefanos 22:29

March 3, 2024

Thread Author Time
Thoughts on user-defined types for talk at Postgres conference? Guyren Howe 00:40
postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek 09:34
Re: postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek 13:16
Re: postgres_fdw aggregate pushdown for group by with expressions Adrian Klaver 16:19
Re: postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek 17:04
Re: postgres_fdw aggregate pushdown for group by with expressions Tom Lane 17:42
Re: postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek 18:02
How to add columns faster yudhi s 19:06
Re: How to add columns faster Christophe Pettus 19:13
Re: How to add columns faster Ron Johnson 19:16
Re: How to add columns faster yudhi s 19:40
Re: How to add columns faster Christophe Pettus 20:00
Re: How to add columns faster Christophe Pettus 20:03
When manual analyze is needed veem v 20:03
Re: Orphan files filling root partition after crash Peter J. Holzer 23:04

March 4, 2024

Thread Author Time
Re: Orphan files filling root partition after crash Laurenz Albe 04:07
Re: When manual analyze is needed Laurenz Albe 04:12
Re: Guarantees/Semantics of pg_stats Laurenz Albe 04:14
Re: When manual analyze is needed Tom Lane 04:31
Re: When manual analyze is needed veem v 04:46
Re: When manual analyze is needed veem v 05:23
Re: postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek 06:46
Re: postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek 07:09
Re: When manual analyze is needed Laurenz Albe 08:40
Inconsistent results in timestamp/interval comparison albrecht.dress 12:09
Re: postgres_fdw aggregate pushdown for group by with expressions Michał Kłeczek 12:35
Re: Inconsistent results in timestamp/interval comparison Francisco Olarte 12:45
Re: Inconsistent results in timestamp/interval comparison Alban Hertroys 13:04
Re: Inconsistent results in timestamp/interval comparison albrecht.dress 13:06
Re: Inconsistent results in timestamp/interval comparison Francisco Olarte 15:04
Re: postgres_fdw aggregate pushdown for group by with expressions Tom Lane 15:22
Support for dates before 4713 BC Koschicek-Krombholz, Bernhard 16:01
Re: When manual analyze is needed Greg Sabino Mullane 16:15
Is partition pruning impacted by data type sud 19:39
Re: When manual analyze is needed veem v 20:01
CTEs and concurrency Brecht De Rooms 21:44

March 5, 2024

Thread Author Time
Re: Is partition pruning impacted by data type sud 05:20
Sv: Support for dates before 4713 BC Andreas Joseph Krogh 07:37
pgBadger: Cannot find any log entries from systemd-journald Frank Lanitz 08:13
Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy M Tarkeshwar Rao 11:07
Recall: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy M Tarkeshwar Rao 11:07
Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy M Tarkeshwar Rao 11:08
Re: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy Matthias Apitz 11:29
RE: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy M Tarkeshwar Rao 11:37
Re: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy Laurenz Albe 11:54
Re: CTEs and concurrency Brecht De Rooms 12:21
Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working Stephen Frost 18:16
Re: pgBadger: Cannot find any log entries from systemd-journald grimy.outshine830 18:21
Re: When manual analyze is needed Greg Sabino Mullane 18:22
Re: Is partition pruning impacted by data type Lok P 19:05
Re: Is partition pruning impacted by data type sud 19:29

March 6, 2024

Thread Author Time
Re: pgBadger: Cannot find any log entries from systemd-journald Frank Lanitz 10:39
Re: pgBadger: Cannot find any log entries from systemd-journald Greg Sabino Mullane 15:40
Re: Feature Request: log_line_prefix %h Counterpart Greg Sabino Mullane 15:55
Re: Feature Request: log_line_prefix %h Counterpart Greg Sabino Mullane 16:02
Re: Thoughts on user-defined types for talk at Postgres conference? Stephen Frost 17:45
Re: Thoughts on user-defined types for talk at Postgres conference? Guyren Howe 20:57
extract ddl to devops pipeline Lorusso Domenico 21:18
Re: extract ddl to devops pipeline Christophe Pettus 21:22

March 7, 2024

Thread Author Time
v11.5- v15.3 upgrade (linux) David Gauthier 00:19
Re: extract ddl to devops pipeline Adrian Klaver 00:41
Re: v11.5- v15.3 upgrade (linux) Adrian Klaver 01:55
Re: v11.5- v15.3 upgrade (linux) Bruce Momjian 02:41
Re: v11.5- v15.3 upgrade (linux) Ron Johnson 05:53
Re: Thoughts on user-defined types for talk at Postgres conference? Stephen Frost 06:39
Re: Thoughts on user-defined types for talk at Postgres conference? Tom Lane 07:12
pl/pgsql outside the DB, (i.e. on the terminal) possible ? Achilleas Mantzios - cloud 14:56
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Karsten Hilbert 15:13
Re: v11.5- v15.3 upgrade (linux) Ron Johnson 15:56
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Christophe Pettus 15:57
Re: v11.5- v15.3 upgrade (linux) Adrian Klaver 16:16
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Pavel Stehule 16:25
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Adrian Klaver 16:33
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Markur Sens 16:38
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Robert Treat 16:44
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Achilleas Mantzios 18:04
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Achilleas Mantzios 18:10
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Achilleas Mantzios 18:13
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Karsten Hilbert 18:17
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Adrian Klaver 19:29
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Achilleas Mantzios 20:20
Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? Adrian Klaver 20:36
Re: Is partition pruning impacted by data type sud 20:37
Re: Thoughts on user-defined types for talk at Postgres conference? Peter J. Holzer 21:16

March 8, 2024

Thread Author Time
Re: Thoughts on user-defined types for talk at Postgres conference? Tom Lane 00:51
Question related to partitioning with pg_partman sud 08:23
update to 16.2 Matthias Apitz 08:53
Re: update to 16.2 Christophe Pettus 08:56
Re: update to 16.2 Daniel Gustafsson 08:58
Re: update to 16.2 Matthias Apitz 10:00
Re: update to 16.2 Ron Johnson 14:03
Re: update to 16.2 Greg Sabino Mullane 14:09
Windows service randomly stops with no indication why Jay Madren 14:17
Re: Windows service randomly stops with no indication why Ron Johnson 14:32
Re: Windows service randomly stops with no indication why Greg Sabino Mullane 14:45
Re: Windows service randomly stops with no indication why Ray O'Donnell 15:42
Re: Windows service randomly stops with no indication why Adrian Klaver 16:06
creating a subset DB efficiently ? David Gauthier 16:22
Re: v11.5- v15.3 upgrade (linux) Yogesh Sharma 16:28
Re: v11.5- v15.3 upgrade (linux) David Gauthier 16:57
Re: update to 16.2 Adrian Klaver 17:02
Re: creating a subset DB efficiently ? Ron Johnson 17:05
Re: v11.5- v15.3 upgrade (linux) Adrian Klaver 17:09
Re: v11.5- v15.3 upgrade (linux) Adrian Klaver 17:12
Re: Emitting JSON to file using COPY TO Andrey M. Borodin 17:28
Re: Windows service randomly stops with no indication why Jay Madren 17:48
Re: Emitting JSON to file using COPY TO Joe Conway 18:01
Re: v11.5- v15.3 upgrade (linux) David Gauthier 18:24
Re: Question related to partitioning with pg_partman sud 18:45
Help diagnosing replication (copy) error Steve Baldwin 21:50
Re: Help diagnosing replication (copy) error Adrian Klaver 21:56
Re: Help diagnosing replication (copy) error Steve Baldwin 22:04
Re: Question related to partitioning with pg_partman Adrian Klaver 22:11
Re: Help diagnosing replication (copy) error Adrian Klaver 22:13
Re: Help diagnosing replication (copy) error Adrian Klaver 22:32
Re: Help diagnosing replication (copy) error Steve Baldwin 22:42

March 9, 2024

Thread Author Time
Re: Help diagnosing replication (copy) error Jeff Ross 00:06
Re: Emitting JSON to file using COPY TO jian he 01:13
Seeing high query planning time on Azure Postgres Single Server version 11. hassan rafi 04:19
Re: Help diagnosing replication (copy) error Steve Baldwin 06:26
Getting error while upgrading omkar narkar 08:33
Re: Seeing high query planning time on Azure Postgres Single Server version 11. Ron Johnson 12:28
Re: Seeing high query planning time on Azure Postgres Single Server version 11. hassan rafi 12:44
Re: Seeing high query planning time on Azure Postgres Single Server version 11. Robert Treat 14:27
Re: creating a subset DB efficiently ? hector vass 14:56
Insert with Jsonb column hangs kuldeep singh 15:02
Fwd: Getting error while upgrading hector vass 15:16
Re: Seeing high query planning time on Azure Postgres Single Server version 11. hassan rafi 15:18
Re: Insert with Jsonb column hangs hector vass 15:31
Re: Insert with Jsonb column hangs kuldeep singh 16:00
Re: Insert with Jsonb column hangs Adrian Klaver 16:10
Re: Insert with Jsonb column hangs hector vass 16:14
Re: Help diagnosing replication (copy) error Adrian Klaver 16:15
Re: Insert with Jsonb column hangs hector vass 16:27
Re: Insert with Jsonb column hangs kuldeep singh 16:34
Re: creating a subset DB efficiently ? Adrian Klaver 17:02
Re: Seeing high query planning time on Azure Postgres Single Server version 11. Tom Lane 18:00
Re: creating a subset DB efficiently ? Shaheed Haque 18:44
Re: Seeing high query planning time on Azure Postgres Single Server version 11. hassan rafi 18:57
Query plans not identical for `id in(1,2,3)` and `(id=1 or id=2 or id=3)` Ilya Basin 19:08
Re: Help diagnosing replication (copy) error Steve Baldwin 21:05
Re: creating a subset DB efficiently ? Peter J. Holzer 21:34

March 10, 2024

Thread Author Time
Re: Insert with Jsonb column hangs Rob Sargent 00:18
Re: Query plans not identical for `id in(1,2,3)` and `(id=1 or id=2 or id=3)` Laurenz Albe 11:51
Re: Query plans not identical for `id in(1,2,3)` and `(id=1 or id=2 or id=3)` Thomas Kellerer 11:58
Re: Question related to partitioning with pg_partman sud 12:12
walsender RAM increases by 500 MB while data is 80 MB Avi Weinberg 15:33
Re: Question related to partitioning with pg_partman Adrian Klaver 17:01
Re: Seeing high query planning time on Azure Postgres Single Server version 11. Greg Sabino Mullane 17:33
Re: Question related to partitioning with pg_partman sud 17:51
Re: Question related to partitioning with pg_partman Adrian Klaver 18:01
Re: Seeing high query planning time on Azure Postgres Single Server version 11. Ron Johnson 18:13
Re: Question related to partitioning with pg_partman sud 18:34
Re: Question related to partitioning with pg_partman Adrian Klaver 20:25
Re: Query plans not identical for `id in(1,2,3)` and `(id=1 or id=2 or id=3)` Ilya Basin 20:51

March 11, 2024

Thread Author Time
Re: Seeing high query planning time on Azure Postgres Single Server version 11. hassan rafi 06:30
Re: walsender RAM increases by 500 MB while data is 80 MB Masahiko Sawada 08:38
Implementing product-aggregate Jan Kohnert 09:16
Performance (and general) considerations between views and functions Wiwwo Staff 10:07
Re: could not open file "global/pg_filenode.map": Operation not permitted Nick Renders 10:11
About rsync Rama Krishnan 10:22
Fwd: Performance (and general) considerations between views and functions Tony Shelver 10:27
Re: About rsync Stephen Frost 10:36
Pgxs - How to reference another extension Michał Kłeczek 10:41
Re: could not open file "global/pg_filenode.map": Operation not permitted Laurenz Albe 11:10
Create a standby server normandavis1990 11:51
Re: could not open file "global/pg_filenode.map": Operation not permitted Stephen Frost 11:56
Re: Create a standby server Mateusz Henicz 12:09
Re: Create a standby server Stephen Frost 12:13
Re: Pgxs - How to reference another extension Michał Kłeczek 12:26
Re: Create a standby server normandavis1990 12:32
Re: Create a standby server normandavis1990 12:33
alter table xxx alter column yyy set (n_distinct=nnnn ); Tefft, Michael J 12:36
Re: Pgxs - How to reference another extension Artur Zakirov 13:08
Re: alter table xxx alter column yyy set (n_distinct=nnnn ); Laurenz Albe 13:20
Re: Pgxs - How to reference another extension Michał Kłeczek 13:48
Re: Pgxs - How to reference another extension Joe Conway 13:52
Re: Pgxs - How to reference another extension Pavel Stehule 14:00
Re: Create a standby server Stephen Frost 14:19

Browse Archives

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