Postgres Pro
Downloads
Home   >   mailing lists

Re: Abysmal hash join - Mailing list pgsql-performance

From Gregory Stark
Subject Re: Abysmal hash join
Date
Msg-id 87k649q4w4.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Abysmal hash join  (Florian Weimer <fweimer@bfk.de>)
List pgsql-performance
Tree view 
Florian Weimer <fweimer@bfk.de> writes:

> I've done that.  Fortunately, ANALYZE time didn't increase by that
> much, compared to the default (by just a factor of 10).

With really high stats times you also have to keep an eye on planning time.
The extra data in the stats table can cause planning to take longer.


--
greg

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Configuring System for Speed
Next
From: "Merlin Moncure"
Date:
Subject: Re: Performance problem with Sarge compared with Woody