Postgres Pro
Downloads
Home   >   mailing lists

Re: counting rows - Mailing list pgsql-admin

From Tom Lane
Subject Re: counting rows
Date
Msg-id 18459.1060181562@sss.pgh.pa.us
Whole thread Raw
In response to counting rows  (pgboy@guthrie.charm.net)
List pgsql-admin
Tree view 
pgboy@guthrie.charm.net writes:
> so, i am wondering if analyze also does a table scan,

It does not --- it does a statistical sampling, and it's quite possible
that the estimate will be badly off.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Matt Clark"
Date:
Subject: Re: Postgresql slow on XEON 2.4ghz/1gb ram
Next
From: "Daniel Seichter"
Date:
Subject: Re: Postgresql slow on XEON 2.4ghz/1gb ram