Home > mailing lists

count(*) optimization - Mailing list pgsql-sql

From	Nikola Ivacic
Subject	count(*) optimization
Date	January 8, 2003 14:04:33
Msg-id	024d01c2b72f$a6a7dcc0$1100a8c0@rspi Whole thread Raw
Responses	Re: count(*) optimization (Bruno Wolff III <bruno@wolff.to>)
List	pgsql-sql

I have trouble executing count(*) statement.

On a large dataset it takes quite a while to return result.

Is there any other way to get number of tupples in relation

or is the only way to optimize count() function to index it?

thanks

Nikola

From: "Rajesh Kumar Mallah."
Date: 08 January 2003, 13:32:05
Subject: Re: Search and Replace

From: Bruno Wolff III
Date: 08 January 2003, 14:12:05
Subject: Re: count(*) optimization