Postgres Pro
Downloads
Home   >   mailing lists

Re: select count(*) performance - Mailing list pgsql-performance

From Detlef Rudolph
Subject Re: select count(*) performance
Date
Msg-id 5i64cvF3mnmcsU1@mid.individual.net
Whole thread Raw
In response to select count(*) performance  (runic <runic@gmx.de>)
Responses Re: select count(*) performance
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Relyea, Mike"
Date:
Subject: Help optimize view
Next
From: Robert D Oden
Date:
Subject: Raid Configurations