Quick Links

Re: select count(*) performance

From:	Detlef Rudolph <runic(at)gmx(dot)de>
To:	pgsql-performance(at)postgresql(dot)org
Subject:	Re: select count(*) performance
Date:	2007-08-11 15:54:41
Message-ID:	5i64cvF3mnmcsU1@mid.individual.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

Hello Group,

I've tried the VACUUM ANALYSE, that doesn't help
much, but VACUUM FULL improves Performance down
from about 40 secs to 8. I think in future I would
use the reltuples value from pg_class for the table.

Thanks a lot for your answers and a good Sunday,
Det

In response to

select count(*) performance at 2007-08-08 13:01:25 from runic

Responses

Re: select count(*) performance at 2007-08-13 11:38:09 from valgog
Re: select count(*) performance at 2007-08-18 01:14:01 from Scott Marlowe

Browse pgsql-performance by date

	From	Date	Subject
Next Message	valgog	2007-08-13 11:38:09	Re: select count(*) performance
Previous Message	Kevin Grittner	2007-08-11 15:32:08	Re: select count(*) performance