Re: Slow COUNT

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Slow COUNT
Date: 2005-12-02 06:28:36
Message-ID: 87zmnkf1wr.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Poul Møller Hansen <freebsd(at)pbnet(dot)dk> writes:

> My questions is, which statements can use to count the rows faster ?
> 32 secs compared to 10 ms !

Try starting a transaction in one window updating one of those records and see
how long it takes your count(*) to complete in the other window while that
update is still pending.

--
greg

In response to

  • Slow COUNT at 2005-12-01 20:51:15 from Poul Møller Hansen

Browse pgsql-general by date

  From Date Subject
Next Message essay182@gmail.com 2005-12-02 06:43:49 Re: lo_import permissions problem
Previous Message Brendan Duddridge 2005-12-02 05:49:50 Fast FrontBase to PostgreSQL converter?