Re: Why does a simple query not use an obvious index? - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Why does a simple query not use an obvious index?
Date
Msg-id 1093817899.42199.63.camel@jester
Whole thread Raw
In response to Re: Why does a simple query not use an obvious index?  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
> People expect count(*) _without a where clause_ to be cached in a single
> global variable. Postgres can't do this, but the reason has everything to do

Someone should write an approx_count('table') function that reads
reltuples from pg_class and tell them to use it in combination with
autovac.

I've yet to see someone use count(*) across a table and not round the
result themselves (approx 9 million clients).



pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: Why does a simple query not use an obvious index?
Next
From: Russell Smith
Date:
Subject: Re: Query performance problem in 8.0.0beta1