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

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: ogjunk-pgjedan(at)yahoo(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Help with a seq scan on multi-million row table
Date: 2006-05-11 10:33:55
Message-ID: 44631313.1020100@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi, Otis,

ogjunk-pgjedan(at)yahoo(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christian Paul Cosinas 2006-05-11 12:00:11 ORDER BY question
Previous Message Michael Glaesemann 2006-05-11 03:55:19 Re: ORDER BY question