Re: query slowdown after 9.0 -> 9.4 migration - Mailing list pgsql-performance

From Filip Rembiałkowski
Subject Re: query slowdown after 9.0 -> 9.4 migration
Date
Msg-id CAP_rwwmXxqASHJApuKQkfzEMfMv7xWDsBnOY5Ybe1i6J9qreRg@mail.gmail.com
Whole thread Raw
In response to Re: query slowdown after 9.0 -> 9.4 migration  (Andreas Kretschmer <akretschmer@spamfence.net>)
Responses Re: query slowdown after 9.0 -> 9.4 migration  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-performance

On Thu, Oct 27, 2016 at 7:38 AM, Andreas Kretschmer <akretschmer@spamfence.net> wrote:
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)?


Does it make sense to ask on postgis-users list?


​Thanks,
Filip

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: limit 1 on view never finishes
Next
From: "Warner, Gary, Jr"
Date:
Subject: Big Memory Boxes and pgtune