On Mon, Jul 8, 2013 at 9:21 AM, Tom Harkaway <tomh(at)hvpa(dot)com> 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