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

[Victor Yegorov]

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