Horton

Re: [HACKERS] Slow count(*) again...

Jeremy Harris <jgh@wizmail.org>

View thread
From: Jeremy Harris <jgh@wizmail.org>
To: pgsql-performance@postgresql.org
Date: 2011-02-04T00:49:52Z
Lists: pgsql-hackers, pgsql-performance 
On 2011-02-03 21:51, Mark Kirkwood wrote:
> The cases I've seen in production typically involve "outgrowing" optimizer parameter settings: (e.g work_mem, effective_cache_size) as the application dataset gets bigger over time.

An argument in favour of the DBMS maintaining a running estimate of such things.
-- 
Jeremy