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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
