On 10/18/2010 3:58 AM, Vitalii Tymchyshyn wrote:
Hello.
Did you vacuum postgresql DB before the count(*). I ask this because
(unless table was created& loaded in same transaction) on the first
scan, postgresql has to write hint bits to the whole table. Second scan
may be way faster.
Best regards, Vitalii Tymchyshyn
Vitalli, yes I did vacuum before the count.
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance