Re: counting rows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgboy(at)guthrie(dot)charm(dot)net
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: counting rows
Date: 2003-08-06 14:52:42
Message-ID: 18459.1060181562@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

pgboy(at)guthrie(dot)charm(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel Seichter 2003-08-06 15:01:48 Re: Postgresql slow on XEON 2.4ghz/1gb ram
Previous Message Matt Clark 2003-08-06 14:39:45 Re: Postgresql slow on XEON 2.4ghz/1gb ram