On Jun 20, 2016, at 1:36 PM, David G. Johnston
mailto:david.g.johns...@gmail.com>> wrote:
Please don't top-post.
Yes, using "[VACUUM] ANALYZE" is what was meant (the VACUUM doesn't hurt - and
possibly helps - but wasn't required). ANALYZE recomputes the statistics for
your database. The ap
between the query plan in the separate environments. Is this
what you meant, Tom, by making sure to ANALYZE? Or did you mean including
ANALYZE in EXPLAIN ANALYZE?
On 6/17/16, 11:17 AM, "Tom Lane" wrote:
>"Erdmann, Markus @ Bellevue" writes:
>> We¹re trying to debug
Hello,
We’re trying to debug a performance issue affecting our staging database, and
we’ve narrowed it down to a difference in the query optimizer in 9.5.2.
Upgrading to 9.5 is important for us because we need the ability to import
foreign schemas.
This is the query we’re running:
CREATE TEMP