Hi
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 tooptimize count()
function to indexit?
thanks
Nikola
On Wed, Jan 08, 2003 at 17:04:40 +0100,
Nikola Ivacic [EMAIL PROTECTED] wrote:
Hi
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()
PM
Subject: Re: [SQL] count(*) optimization
On Wed, Jan 08, 2003 at 17:04:40 +0100,
Nikola Ivacic [EMAIL PROTECTED] wrote:
Hi
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
, January 08, 2003 5:20 PM
Subject: Re: [SQL] count(*) optimization
Bummer. I seem to remember PGAccess using the numbers generated by ANALYZE
to show the number of records. I noticed it was inaccurate until you ran a
vaccum. I guess pgAdmin chose accuracy over speed in this case.
Ian Harding
Nikola,
I am not sure pgAdmin uses count(*) and I didn't have time to check
phpPgAdmin also, I presumed it from similarly slow response I get in
psql
Well, pgAdmin and phpPgAdmin have their own mailing lists. I'd suggest
posting there. Ideally, these programs should have an option that