Re: Slow COUNT - Mailing list pgsql-general

From Guido Neitzer
Subject Re: Slow COUNT
Date
Msg-id B253A33C-E9F5-4017-A757-501CC585B054@pharmaline.de
Whole thread Raw
In response to Re: Slow COUNT  (Jaime Casanova <systemguards@gmail.com>)
Responses Re: Slow COUNT
List pgsql-general
On 02.12.2005, at 20:02 Uhr, Jaime Casanova wrote:

> so the way to do it is create a trigger that record in a table the
> number of rows...

As there are SO MANY questions about the "count(*)" issue, I wonder
whether it makes sense to add a mechanism which does exactly the
method mentioned above in a default PostgreSQL installation (perhaps
switched of by default for other performance impacts)?!

cug

--
PharmaLine, Essen, GERMANY
Software and Database Development




Attachment

pgsql-general by date:

Previous
From: Anton Nikiforov
Date:
Subject: Re: int to inet conversion
Next
From: Tino Wildenhain
Date:
Subject: Re: Slow COUNT