On Thu, Oct 27, 2016 at 7:38 AM, Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> wrote:
Does it make sense to ask on postgis-users list?
Tomas Vondra <tomas.vondra@xxxxxxxxxxxxxxx> 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)?
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)?
Does it make sense to ask on postgis-users list?
Thanks,
Filip
