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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: after upgrade 8.4->9.3 query is slow not using index scan
From: Victor Yegorov <vyegorov@xxxxxxxxx>
Date: Fri, 26 Sep 2014 22:03:17 +0300
Cc: "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <702132002.23621411740248006.JavaMail.root@shiva>

2014-09-26 17:04 GMT+03:00 Matúš Svrček <svrcek@xxxxxxxxxxxx>:

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

References:
- after upgrade 8.4->9.3 query is slow not using index scan
  - From: Matúš Svrček

Prev by Date: Re: Very slow postgreSQL 9.3.4 query
Next by Date: Re: Very slow postgreSQL 9.3.4 query
Previous by thread: after upgrade 8.4->9.3 query is slow not using index scan
Next by thread: Re: after upgrade 8.4->9.3 query is slow not using index scan
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux