Hi Adrian, On 10/10/2022 20:59, Adrian Klaver wrote:
Information needed: 1) The query and its EXPLAIN ANALYZE for both slow/fast cases. 2) Postgres version. 3) What database are the developers workstation pointing at? 4) What is the test db and is it the same as 3)? 5) What clients are you using to run the query?
Thanks for the interest. I was just looking for pointers on what to look at next. Got that from Tom (table bloat) and Imre (different random sample of analyze).
Regards kostas
