Re: 8.4 to 9.2 migration performance

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

 



On Mon, Jul 8, 2013 at 9:21 AM, Tom Harkaway <tomh@xxxxxxxx> wrote:
The ‘explain’ output for the query is very different between the two systems.

You ran ANALYZE after loading the data?  Can you post the query and EXPLAIN ANALYZE output?
Also, some tips on getting answers with (potentially) less ping pong discussion can be found here: https://wiki.postgresql.org/wiki/Slow_Query_Questions

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

  Powered by Linux