Postgres Pro
Downloads
Home   >   mailing lists

Re: why sequential scan - Mailing list pgsql-general

From Tom Lane
Subject Re: why sequential scan
Date
Msg-id 9828.997973958@sss.pgh.pa.us
Whole thread Raw
In response to why sequential scan  (newsreader@mediaone.net)
Responses Re: why sequential scan  (newsreader@mediaone.net)
List pgsql-general
Tree view 
newsreader@mediaone.net writes:
> Can someone explain why pg is doing
> a sequential scan on table item with the following
> statement

Looks like a fairly reasonable plan to me, if the rows estimates are
accurate.  Are they?

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: The -o command line option of pg_dump for a database using foreign keys
Next
From: "Roderick A. Anderson"
Date:
Subject: Re: Roll Back dont roll back counters