Re: Abysmal hash join

From: Gregory Stark <gsstark(at)mit(dot)edu>
To: Florian Weimer <fweimer(at)bfk(dot)de>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Abysmal hash join
Date: 2006-09-12 00:56:27
Message-ID: 87k649q4w4.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Florian Weimer <fweimer(at)bfk(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2006-09-12 01:53:28 Re: Performance problem with Sarge compared with Woody
Previous Message Luke Lonergan 2006-09-11 23:37:36 Re: Configuring System for Speed