Re: [HACKERS] Slow count(*) again... - Mailing list pgsql-performance

From Jeremy Harris
Subject Re: [HACKERS] Slow count(*) again...
Date
Msg-id 4D4B4D30.2060007@wizmail.org
Whole thread Raw
In response to Re: [HACKERS] Slow count(*) again...  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Responses Re: [HACKERS] Slow count(*) again...
List 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

pgsql-performance by date:

Previous
From: Jeremy Harris
Date:
Subject: Re: [HACKERS] Slow count(*) again...
Next
From: Grant Johnson
Date:
Subject: Re: [HACKERS] Slow count(*) again...