Home > mailing lists

Re: after upgrade 8.4->9.3 query is slow not using index scan - Mailing list pgsql-performance

From	Victor Yegorov
Subject	Re: after upgrade 8.4->9.3 query is slow not using index scan
Date	September 26, 2014 22:03:23
Msg-id	CAGnEbog7fMvFuy7_=+FjHCqiTkM2qS5Ano1U3EEmvBYkN7X5PA@mail.gmail.com Whole thread Raw
In response to	after upgrade 8.4->9.3 query is slow not using index scan (Matúš Svrček <svrcek@plaintext.sk>)
List	pgsql-performance

2014-09-26 17:04 GMT+03:00 Matúš Svrček <svrcek@plaintext.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

From: "Burgess, Freddie"
Date: 26 September 2014, 19:20:50
Subject: Re: Very slow postgreSQL 9.3.4 query

From: "Burgess, Freddie"
Date: 26 September 2014, 23:07:19
Subject: Re: Very slow postgreSQL 9.3.4 query