Re: How much expensive are row level statistics?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Carlos Benkendorf <carlosbenkendorf(at)yahoo(dot)com(dot)br>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How much expensive are row level statistics?
Date: 2005-12-11 19:44:43
Message-ID: 20051211194442.GA97174@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sun, Dec 11, 2005 at 11:53:36AM +0000, Carlos Benkendorf wrote:
> I would like to use autovacuum but is not too much expensive
> collecting row level statistics?

The cost depends on your usage patterns. I did tests with one of
my applications and saw no significant performance difference for
simple selects, but a series of insert/update/delete operations ran
about 30% slower when block- and row-level statistics were enabled
versus when the statistics collector was disabled.

--
Michael Fuhr

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-12-11 20:36:25 Re: Join the same row
Previous Message Carlos Benkendorf 2005-12-11 11:53:36 How much expensive are row level statistics?