From: Markus Schaber <schabi@logix-tt.com>
To: ogjunk-pgjedan@yahoo.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Help with a seq scan on multi-million row table
Date: Thu, 11 May 2006 12:33:55 +0200
Message-ID: <44631313.1020100@logix-tt.com> (raw)
In-Reply-To: <20060511034711.46266.qmail@web50305.mail.yahoo.com>
References: <20060511034711.46266.qmail@web50305.mail.yahoo.com>
Hi, Otis,
ogjunk-pgjedan@yahoo.com wrote:
> I'm not sure which numbers you are referring to when you said the estimate is off, but here are some numbers:
> The whole table has 6-7 M rows.
> That query matches about 2500 rows.
>
> If there are other things I can play with and help narrow this down, please let me know.
Did you try to set higher statistics targets for this columns?
For experimenting, I'd try to set it to 100 or even higher, then ANALYZE
the table, and then retest the query.
HTH,
Marks
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
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: schabi@logix-tt.com, ogjunk-pgjedan@yahoo.com
Subject: Re: Help with a seq scan on multi-million row table
In-Reply-To: <44631313.1020100@logix-tt.com>
* 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