Re: Help with a seq scan on multi-million row table

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(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)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(at)yahoo(dot)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(at)crankycanuck(dot)ca