On Mon, 2025-04-07 at 15:48 +0100, Simon Windsor wrote: > After upgrading a Db from Pg13 (Centos) to Pg16(Ubuntu) some queries > on a simple, large table (200M rows) are very slow
If you used "pg_upgrade", did you ANALYZE the database? If that is not the problem, we can't guess what your problem might be unless you provide EXPLAIN (ANALYZE, BUFFERS, SETTINGS) output for auch a slow query. Ideally, add the same information for the fast v13 case. Yours, Laurenz Albe