pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedto_jsonb performance on array aggregated correlated subqueries
2022-08-12 18:49 UTC Nico Heller <nico.heller@posteo.de>
` Re: to_jsonb performance on array aggregated correlated subqueries
2022-08-12 18:56 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: to_jsonb performance on array aggregated correlated subqueries
2022-08-12 19:02 UTC Nico Heller <nico.heller@posteo.de>
` Re: to_jsonb performance on array aggregated correlated subqueries
2022-08-12 19:07 UTC Nico Heller <nico.heller@posteo.de>
` Re: to_jsonb performance on array aggregated correlated subqueries
2022-08-12 19:10 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: to_jsonb performance on array aggregated correlated subqueries
2022-08-12 19:15 UTC Andres Freund <andres@anarazel.de>
` Re: to_jsonb performance on array aggregated correlated subqueries
2022-08-12 19:18 UTC Nico Heller <nico.heller@posteo.de>
` Re: to_jsonb performance on array aggregated correlated subqueries
2022-08-12 19:48 UTC Nico Heller <nico.heller@posteo.de>
` Re: to_jsonb performance on array aggregated correlated subqueries
2022-08-12 20:17 UTC Rick Otten <rottenwindfish@gmail.com>
[9+ messages in thread]
Postgresql 14 partitioning advice
2022-07-27 12:55 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Postgresql 14 partitioning advice
2022-07-27 13:38 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Postgresql 14 partitioning advice
2022-07-27 17:17 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Postgresql 14 partitioning advice
2022-07-29 21:44 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Postgresql 14 partitioning advice
2022-07-30 07:48 UTC Nathan Ward <lists+postgresql@daork.net>
` Re: Postgresql 14 partitioning advice
2022-08-01 14:16 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Postgresql 14 partitioning advice
2022-08-02 12:54 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Postgresql 14 partitioning advice
2022-08-08 22:45 UTC Slava Mudry <slava44@gmail.com>
` Re: Postgresql 14 partitioning advice
2022-08-08 22:55 UTC Justin Pryzby <pryzby@telsasoft.com>
[9+ messages in thread]
pg_wal filling up while running huge updates
2022-08-05 12:30 UTC aditya desai <admad123@gmail.com>
` Re: pg_wal filling up while running huge updates
2022-08-05 13:56 UTC Don Seiler <don@seiler.us>
` Re: pg_wal filling up while running huge updates
2022-08-05 14:04 UTC Justin Pryzby <pryzby@telsasoft.com>
[3+ messages in thread]
Postgresql 13 partitioning advice
2022-08-02 07:48 UTC Ameya Bidwalkar <bidwalkar.ameya10@gmail.com>
` Re: Postgresql 13 partitioning advice
2022-08-02 10:16 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Postgresql 13 partitioning advice
2022-08-03 11:05 UTC Ameya Bidwalkar <bidwalkar.ameya10@gmail.com>
[3+ messages in thread]
PgSQL 14 - Logical Rep - Single table multiple publications?
2022-08-02 13:57 UTC Robert Blayzor <rblayzor.bulk@inoc.net>
` Re: PgSQL 14 - Logical Rep - Single table multiple publications?
2022-08-02 14:57 UTC Rory Campbell-Lange <rory@campbell-lange.net>
` Re: PgSQL 14 - Logical Rep - Single table multiple publications?
2022-08-02 16:09 UTC Robert Blayzor <rblayzor.bulk@inoc.net>
` Re: PgSQL 14 - Logical Rep - Single table multiple publications?
2022-08-02 19:18 UTC Rory Campbell-Lange <rory@campbell-lange.net>
[4+ messages in thread]
alter table xxx set unlogged take long time
2022-07-26 08:53 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: alter table xxx set unlogged take long time
2022-07-26 12:21 UTC Jim Mlodgenski <jimmy76@gmail.com>
` RE: alter table xxx set unlogged take long time
2022-07-26 12:41 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: alter table xxx set unlogged take long time
2022-07-26 12:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: alter table xxx set unlogged take long time
2022-07-26 12:45 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: alter table xxx set unlogged take long time
2022-07-26 12:52 UTC Jim Mlodgenski <jimmy76@gmail.com>
` RE: alter table xxx set unlogged take long time
2022-07-26 12:59 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: alter table xxx set unlogged take long time
2022-07-26 15:03 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: alter table xxx set unlogged take long time
2022-07-27 14:35 UTC Joe Conway <mail@joeconway.com>
` Re: alter table xxx set unlogged take long time
2022-07-27 14:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: alter table xxx set unlogged take long time
2022-07-27 15:01 UTC Joe Conway <mail@joeconway.com>
` Re: alter table xxx set unlogged take long time
2022-07-28 04:56 UTC Kyotaro Horiguchi <horikyota.ntt@gmail.com>
` RE: alter table xxx set unlogged take long time
2022-07-28 07:47 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: alter table xxx set unlogged take long time
2022-07-28 12:21 UTC Joe Conway <mail@joeconway.com>
[14+ messages in thread]
data consolidation: logical replication design considerations
2022-07-16 16:07 UTC Rory Campbell-Lange <rory@campbell-lange.net>
` Re: data consolidation: logical replication design considerations
2022-07-17 20:39 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: data consolidation: logical replication design considerations
2022-07-18 14:23 UTC Rory Campbell-Lange <rory@campbell-lange.net>
` Re: data consolidation: logical replication design considerations
2022-07-23 08:40 UTC Rory Campbell-Lange <rory@campbell-lange.net>
[4+ messages in thread]
Occasional performance issue after changing table partitions
2022-07-10 04:55 UTC Nathan Ward <lists+postgresql@daork.net>
` Re: Occasional performance issue after changing table partitions
2022-07-10 14:05 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Occasional performance issue after changing table partitions
2022-07-11 03:21 UTC Nathan Ward <lists+postgresql@daork.net>
` Re: Occasional performance issue after changing table partitions
2022-07-11 04:05 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Occasional performance issue after changing table partitions
2022-07-11 06:20 UTC Nathan Ward <lists+postgresql@daork.net>
` Re: Occasional performance issue after changing table partitions
2022-07-12 15:13 UTC Nathan Ward <lists+postgresql@daork.net>
` Re: Occasional performance issue after changing table partitions
2022-07-12 15:43 UTC Justin Pryzby <pryzby@telsasoft.com>
[7+ messages in thread]
Oracle_FDW table performance issue
2022-07-11 12:08 UTC aditya desai <admad123@gmail.com>
` Re: Oracle_FDW table performance issue
2022-07-11 12:13 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Oracle_FDW table performance issue
2022-07-11 12:22 UTC aditya desai <admad123@gmail.com>
` Re: Oracle_FDW table performance issue
2022-07-11 15:26 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Oracle_FDW table performance issue
2022-07-11 17:37 UTC aditya desai <admad123@gmail.com>
[5+ messages in thread]
functionality difference-performance postgreSQLv14-GCC-llvm-clang
2022-07-11 07:49 UTC arjun shetty <arjunshetty955@gmail.com>
partition pruning only works for select but update
2022-06-28 13:15 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: partition pruning only works for select but update
2022-06-28 13:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: partition pruning only works for select but update
2022-06-28 13:34 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` RE: partition pruning only works for select but update
2022-07-01 08:30 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: partition pruning only works for select but update
2022-07-01 13:13 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: partition pruning only works for select but update
2022-07-01 13:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: partition pruning only works for select but update
2022-07-01 14:06 UTC James Pang (chaolpan) <chaolpan@cisco.com>
[7+ messages in thread]
Fluctuating performance of updates on small table with trigger
2022-06-29 19:31 UTC Mikkel Lauritsen <renard@tala.dk>
` Re: Fluctuating performance of updates on small table with trigger
2022-06-29 19:52 UTC Justin Pryzby <pryzby@telsasoft.com>
[2+ messages in thread]
reindex option for tuning load large data
2022-06-17 05:34 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: reindex option for tuning load large data
2022-06-18 03:48 UTC Vitalii Tymchyshyn <vit@tym.im>
` RE: reindex option for tuning load large data
2022-06-18 04:00 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: reindex option for tuning load large data
2022-06-18 20:01 UTC Jeff Janes <jeff.janes@gmail.com>
` RE: reindex option for tuning load large data
2022-06-19 07:16 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: reindex option for tuning load large data
2022-06-19 08:46 UTC I. V. <ianchov@gmail.com>
[6+ messages in thread]
Missed query planner optimization: `n in (select q)` -> `n in (q)`
2022-06-11 23:50 UTC Josh <postgres@sirjosh3917.com>
` Re: Missed query planner optimization: `n in (select q)` -> `n in (q)`
2022-06-12 23:17 UTC David G. Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
Strange behavior of limit clause in complex query
2022-06-08 08:44 UTC Paulo Silva <paulojjs@gmail.com>
` Re: Strange behavior of limit clause in complex query
2022-06-08 11:40 UTC Ranier Vilela <ranier.vf@gmail.com>
` Re: Strange behavior of limit clause in complex query
2022-06-08 14:07 UTC Paulo Silva <paulojjs@gmail.com>
` Re: Strange behavior of limit clause in complex query
2022-06-08 14:32 UTC Justin Pryzby <pryzby@telsasoft.com>
[4+ messages in thread]
Adding non-selective key to jsonb query @> reduces performance?
2022-06-08 10:55 UTC Marcin Krupowicz <ma@rcin.me>
` Re: Adding non-selective key to jsonb query @> reduces performance?
2022-06-08 14:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Query is taking too long i intermittent
2022-06-06 09:58 UTC Mayank Kandari <mayank.kandari@gmail.com>
` Re: Query is taking too long i intermittent
2022-06-06 10:35 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Query is taking too long i intermittent
2022-06-06 14:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query is taking too long i intermittent
2022-06-06 17:13 UTC Mayank Kandari <mayank.kandari@gmail.com>
[4+ messages in thread]
rows selectivity overestimate for @> operator for arrays
2022-05-27 13:39 UTC Alexey Ermakov <alexey.ermakov@dataegret.com>
` Re: rows selectivity overestimate for @> operator for arrays
2022-05-27 18:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: rows selectivity overestimate for @> operator for arrays
2022-06-02 03:33 UTC Jeff Janes <jeff.janes@gmail.com>
[3+ messages in thread]
REINDEXdb performance degrading gradually PG13.4
2022-05-31 15:14 UTC Praneel Devisetty <devisettypraneel@gmail.com>
` REINDEXdb performance degrading gradually PG13.4
2022-05-31 15:42 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: REINDEXdb performance degrading gradually PG13.4
2022-06-01 04:37 UTC Michael Paquier <michael@paquier.xyz>
` Re: REINDEXdb performance degrading gradually PG13.4
2022-06-01 07:06 UTC Praneel Devisetty <devisettypraneel@gmail.com>
` Re: REINDEXdb performance degrading gradually PG13.4
2022-06-01 17:41 UTC Jeff Janes <jeff.janes@gmail.com>
[5+ messages in thread]
Logical reads
2022-05-31 16:56 UTC Goti <aryan.goti@gmail.com>
postgres backend process hang on " D " state
2022-05-29 13:20 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: postgres backend process hang on " D " state
2022-05-29 13:30 UTC Ranier Vilela <ranier.vf@gmail.com>
` Re: postgres backend process hang on " D " state
2022-05-29 15:01 UTC Justin Pryzby <pryzby@telsasoft.com>
` RE: postgres backend process hang on " D " state
2022-05-30 01:19 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` Re: postgres backend process hang on " D " state
2022-05-30 02:19 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: postgres backend process hang on " D " state
2022-05-30 02:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: postgres backend process hang on " D " state
2022-05-30 02:58 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` RE: postgres backend process hang on " D " state
2022-05-30 02:59 UTC James Pang (chaolpan) <chaolpan@cisco.com>
` RE: postgres backend process hang on " D " state
2022-05-31 02:08 UTC James Pang (chaolpan) <chaolpan@cisco.com>
[9+ messages in thread]
How to monitor Postgres real memory usage
2022-05-24 16:25 UTC 徐志宇徐 <xuzhiyuster@gmail.com>
` Re: How to monitor Postgres real memory usage
2022-05-24 17:40 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: How to monitor Postgres real memory usage
2022-05-26 15:36 UTC 徐志宇徐 <xuzhiyuster@gmail.com>
` Re: How to monitor Postgres real memory usage
2022-05-26 15:47 UTC 徐志宇徐 <xuzhiyuster@gmail.com>
` Re: How to monitor Postgres real memory usage
2022-05-26 16:05 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: How to monitor Postgres real memory usage
2022-05-26 17:39 UTC 徐志宇徐 <xuzhiyuster@gmail.com>
` Re: How to monitor Postgres real memory usage
2022-05-26 23:35 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: How to monitor Postgres real memory usage
2022-05-27 17:40 UTC 徐志宇徐 <xuzhiyuster@gmail.com>
` Re: How to monitor Postgres real memory usage
2022-05-27 17:56 UTC Justin Pryzby <pryzby@telsasoft.com>
[9+ messages in thread]
Fwd: Array of integer indexed nested-loop semi join
2022-04-27 12:18 UTC Mickael van der Beek <mickael.van.der.beek@gmail.com>
` Re: Array of integer indexed nested-loop semi join
2022-04-27 14:28 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Array of integer indexed nested-loop semi join
2022-04-27 14:54 UTC Mickael van der Beek <mickael.van.der.beek@gmail.com>
` Re: Array of integer indexed nested-loop semi join
2022-05-20 10:42 UTC Mickael van der Beek <mickael.van.der.beek@gmail.com>
` Re: Array of integer indexed nested-loop semi join
2022-05-23 02:45 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Array of integer indexed nested-loop semi join
2022-05-23 07:57 UTC Mickael van der Beek <mickael.van.der.beek@gmail.com>
` Re: Array of integer indexed nested-loop semi join
2022-05-23 14:10 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Array of integer indexed nested-loop semi join
2022-05-23 14:46 UTC Mickael van der Beek <mickael.van.der.beek@gmail.com>
[8+ messages in thread]
Selecting RAM and CPU based on max_connections
2022-05-20 08:27 UTC aditya desai <admad123@gmail.com>
` Re: Selecting RAM and CPU based on max_connections
2022-05-20 10:15 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Selecting RAM and CPU based on max_connections
2022-05-20 10:31 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Selecting RAM and CPU based on max_connections
2022-05-20 15:40 UTC aditya desai <admad123@gmail.com>
` Re: Selecting RAM and CPU based on max_connections
2022-05-20 17:59 UTC Ganesh Korde <ganeshakorde@gmail.com>
[5+ messages in thread]
Need help on Query Tunning and Not using the Index Scan
2022-05-20 07:37 UTC Kumar, Mukesh <MKumar@peabodyenergy.com>
` Re: Need help on Query Tunning and Not using the Index Scan
2022-05-20 10:37 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[2+ messages in thread]
[next (older)]
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox