Re: after upgrade 8.4->9.3 query is slow not using index scan

From: Victor Yegorov <vyegorov(at)gmail(dot)com>
To: Matúš Svrček <svrcek(at)plaintext(dot)sk>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: after upgrade 8.4->9.3 query is slow not using index scan
Date: 2014-09-26 19:03:17
Message-ID: CAGnEbog7fMvFuy7_=+FjHCqiTkM2qS5Ano1U3EEmvBYkN7X5PA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2014-09-26 17:04 GMT+03:00 Matúš Svrček <svrcek(at)plaintext(dot)sk>:

> I am having a performance issue after upgrade from 8.4.20-1 -> 9.3.5.

First, make sure you have your statistics up to date — execute manual
`VACUUM ANALYZE`.

And then provide `EXPLAIN analyze` for 8.4 and `EXPLAIN (analyze, buffers)`
for 9.3 output.

--
Victor Y. Yegorov

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Burgess, Freddie 2014-09-26 20:07:11 Re: Very slow postgreSQL 9.3.4 query
Previous Message Burgess, Freddie 2014-09-26 16:17:12 Re: Very slow postgreSQL 9.3.4 query