overhead for statistics collector

From: "Wright, George" <George(dot)Wright(at)infimatic(dot)com>
To: "PostgreSQL List - Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: overhead for statistics collector
Date: 2009-01-27 15:25:19
Message-ID: 51548D6D5BEB57468163194A8C1A0E980161ABBE@MAGPTCPEXC02.na.mag-ias.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

The statistics collector documentation says:

"The parameter stats_start_collector
<http://www.postgresql.org/docs/8.1/interactive/runtime-config-statistic
s.html#GUC-STATS-START-COLLECTOR> must be set to true for the
statistics collector to be launched at all. This is the default and
recommended setting, but it may be turned off if you have no interest in
statistics and want to squeeze out every last drop of overhead. (The
savings is likely to be small, however.) Note that this option cannot be
changed while the server is running. "

Is there a way to quantify what 'likely to be small' is?

Browse pgsql-novice by date

  From Date Subject
Next Message Lukas 2009-01-27 15:28:36 Re: Select START and MAXVALUE from Sequence
Previous Message A. Kretschmer 2009-01-27 14:21:59 Re: Select START and MAXVALUE from Sequence