Date: Sat, 19 May 2007 00:35:29 +0200
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Subject: Re: CPU Intensive query
Message-ID: <20070518223529.GC17690@uio.no>
Mail-Followup-To: pgsql-performance@postgresql.org
References: <20070518164210.GA15372@uio.no>
	<545855.84387.qm@web57106.mail.re3.yahoo.com>
	<20070518223233.GB17690@uio.no>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <20070518223233.GB17690@uio.no>
User-Agent: Mutt/1.5.13 (2006-08-11)

On Sat, May 19, 2007 at 12:32:33AM +0200, Steinar H. Gunderson wrote:
> Did you ANALYZE your tables recently? If the joins are really between
> millions of rows and the planner thinks it's a couple thousands, the stats
> sound rather off... 

Sorry, I forgot your first e-mail where you said you had both vacuumed and
analyzed recently. The estimates are still off, though -- the WHERE query
might be difficult to estimate properly. (I'm not sure how Tom arrived on
his conclusion of expensive user-defined functions, but given the usual
precisions of his guesses, I'd check that too...)

/* Steinar */
-- 
Homepage: http://www.sesse.net/