From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Help with a seq scan on multi-million row table
Date: Thu, 11 May 2006 13:18:08 -0400
Message-ID: <20060511171808.GB9089@phlogiston.dyndns.org> (raw)
In-Reply-To: <20060511170944.91199.qmail@web50302.mail.yahoo.com>
References: <44631313.1020100@logix-tt.com>
<20060511170944.91199.qmail@web50302.mail.yahoo.com>
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
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: Help with a seq scan on multi-million row table
In-Reply-To: <20060511171808.GB9089@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox