DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
	b=0s2EU8CtXiamwCsFqG6YCM0jSH/tm7pWi3shQhvBY7PcyTRANIQnkf3e7jzkZBd/hL/mz09TequO4lO8ATNveMG7RQDvZ2o1IVMT3sdqa+sJXQJKkM5gAvrwFx3MJAg73TGiQG05MRLwLo4tu63iXvkWletBaFH+oR2TLpvJ+4g=
	;
Message-ID: <20060511184659.61496.qmail@web50304.mail.yahoo.com>
Date: Thu, 11 May 2006 11:46:59 -0700 (PDT)
From: <ogjunk-pgjedan@yahoo.com>
Subject: Re: Help with a seq scan on multi-million row table
To: pgsql-sql@postgresql.org
In-Reply-To: <20060511171808.GB9089@phlogiston.dyndns.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Hello Andrew, Markus, and Tom - thanks for all the help!  You've just helped a large Simpy community! :) I'll try to post some performance charts to http://blog.simpy.com/ shortly.  In short, this immediately dropped the load from 2-3-4-5-6-7+ to circa 0.25.

Thanks!
Otis

----- Original Message ----
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Sent: Thursday, May 11, 2006 1:18:08 PM
Subject: Re: [SQL] Help with a seq scan on multi-million row table

On Thu, May 11, 2006 at 10:09:44AM -0700, ogjunk-pgjedan@yahoo.com wrote:
> Hi Markus & Tom,
> 
> Higher statistics for this column.... hm, I'd love to try changing
> it to see how that changes things, but I'm afraid I don't know how
> to do that.  How can I change the statistics target value for this
> column?
> 
> Ah, I think I found the place:

No.  Just ALTER TABLE [name] ALTER [column] SET STATISTICS.  See
http://www.postgresql.org/docs/8.1/interactive/sql-altertable.html
for more.  You'll need to ANALYSE afterwards.

A
-- 
Andrew Sullivan  | ajs@crankycanuck.ca