Re: Slow COUNT - Mailing list pgsql-general

From Greg Stark
Subject Re: Slow COUNT
Date
Msg-id 87zmnkf1wr.fsf@stark.xeocode.com
Whole thread Raw
In response to Slow COUNT  (Poul Møller Hansen <freebsd@pbnet.dk>)
List pgsql-general
Poul Møller Hansen <freebsd@pbnet.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

pgsql-general by date:

Previous
From: Brendan Duddridge
Date:
Subject: Fast FrontBase to PostgreSQL converter?
Next
From: "essay182@gmail.com"
Date:
Subject: Re: lo_import permissions problem