Re: Slow COUNT

From: Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slow COUNT
Date: 2005-12-04 13:02:10
Message-ID: B253A33C-E9F5-4017-A757-501CC585B054@pharmaline.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2005-12-04 13:40:49 Re: Slow COUNT
Previous Message Anton Nikiforov 2005-12-04 12:21:47 Re: int to inet conversion