Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote: > > Perhaps the table is organized / sorted differently, or something like > that. How did you do the upgrade?
Nothing special, dump + reload. The table in question is tiny - 280 kB, 859 rows.
Maybe table-bloat? Filip, check if autovacuum runs properly.
Yes, it does. Just to be sure I ran VACUUM FULL, ANALZYE and REINDEX on all tables and indexes - no change :-(
Any other ideas (before drawing on heavy tools like strace)?