Mailing lists [pgsql-performance]

1 June 2022

• 07:37   Re: REINDEXdb performance degrading gradually PG13.4 Michael Paquier
• 10:06   Re: REINDEXdb performance degrading gradually PG13.4 Praneel Devisetty
• 20:41   Re: REINDEXdb performance degrading gradually PG13.4 Jeff Janes

2 June 2022

• 06:33   Re: rows selectivity overestimate for @> operator for arrays Jeff Janes

6 June 2022

• 12:58   Query is taking too long i intermittent Mayank Kandari
• 13:35   Re: Query is taking too long i intermittent Justin Pryzby
• 17:11   Re: Query is taking too long i intermittent Tom Lane
• 20:13   Re: Query is taking too long i intermittent Mayank Kandari

8 June 2022

• 11:44   Strange behavior of limit clause in complex query Paulo Silva
• 13:55   Adding non-selective key to jsonb query @> reduces performance? Marcin Krupowicz
• 14:40   Re: Strange behavior of limit clause in complex query Ranier Vilela
• 17:07   Re: Strange behavior of limit clause in complex query Paulo Silva
• 17:32   Re: Adding non-selective key to jsonb query @> reduces performance? Tom Lane
• 17:32   Re: Strange behavior of limit clause in complex query Justin Pryzby

12 June 2022

• 02:50   Missed query planner optimization: `n in (select q)` -> `n in (q)` Josh

13 June 2022

• 02:17   Re: Missed query planner optimization: `n in (select q)` -> `n in (q)` David G. Johnston

17 June 2022

• 08:34   reindex option for tuning load large data  James Pang (chaolpan)

18 June 2022

• 06:48   Re: reindex option for tuning load large data Vitalii Tymchyshyn
• 07:00   RE: reindex option for tuning load large data James Pang (chaolpan)
• 23:01   Re: reindex option for tuning load large data Jeff Janes

19 June 2022

• 10:16   RE: reindex option for tuning load large data James Pang (chaolpan)
• 11:46   Re: reindex option for tuning load large data I. V.

28 June 2022

• 16:15   partition pruning only works for select but update  James Pang (chaolpan)
• 16:30   Re: partition pruning only works for select but update Tom Lane
• 16:34   RE: partition pruning only works for select but update James Pang (chaolpan)

29 June 2022

• 22:31   Fluctuating performance of updates on small table with trigger Mikkel Lauritsen
• 22:52   Re: Fluctuating performance of updates on small table with trigger Justin Pryzby