[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] query slowdown after 9.0 -> 9.4 migration
From:       Filip_Rembiałkowski <filip.rembialkowski () gmail ! com>
Date:       2016-10-28 1:37:19
Message-ID: CAP_rwwmXxqASHJApuKQkfzEMfMv7xWDsBnOY5Ybe1i6J9qreRg () mail ! gmail ! com
[Download RAW message or body]

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
​

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Oct 27, \
2016 at 7:38 AM, Andreas Kretschmer <span dir="ltr">&lt;<a \
href="mailto:akretschmer@spamfence.net" \
target="_blank">akretschmer@spamfence.net</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><span class="m_-2875237426679147277gmail-">Tomas \
Vondra &lt;<a href="mailto:tomas.vondra@2ndquadrant.com" \
target="_blank">tomas.vondra@2ndquadrant.com</a>&gt; wrote:<br> </span><span \
class="m_-2875237426679147277gmail-"></span><span \
class="m_-2875237426679147277gmail-"><br> &gt;<br>
&gt; Perhaps the table is organized / sorted differently, or something like<br>
&gt; that. How did you do the upgrade?<br>
<br></span></blockquote><div><br><div style="font-family:monospace,monospace" \
class="gmail_default">Nothing special, dump + reload. The table in question is tiny - \
280 kB, 859 rows.<br></div><br>  </div><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><span class="m_-2875237426679147277gmail-"> \
</span>Maybe table-bloat? Filip, check if autovacuum runs properly.<br> \
<br></blockquote><div><div style="font-family:monospace,monospace;display:inline" \
class="gmail_default">​<br>Yes, it does. Just to be sure I ran VACUUM FULL, ANALZYE \
and REINDEX on all tables and indexes - no change :-(<br><br>Any other ideas (before \
drawing on heavy tools like strace)?<br><br></div><div \
style="font-family:monospace,monospace;display:inline" class="gmail_default"><br>Does \
it make sense to ask on postgis-users list?<br><br></div><div \
style="font-family:monospace,monospace;display:inline" \
class="gmail_default">​</div><br><div style="font-family:monospace,monospace" \
class="gmail_default">​Thanks,<br></div><div \
style="font-family:monospace,monospace" \
class="gmail_default">Filip<br>​</div><br></div></div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]