Re: stats_command_string default? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: stats_command_string default?
Date
Msg-id 005601c2d624$60658d70$6500a8c0@fhp.internal
Whole thread Raw
In response to stats_command_string default?  (Kevin Brown <kevin@sysexperts.com>)
Responses Re: stats_command_string default?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Averaging over three trials on an unloaded system, I got 21.0 seconds
> with stats_command_string off, 27.7 with it on, or about 32% overhead.
>
> My conclusion is that stats_command_string overhead is non-negligible
> for simple commands.  So I stand by my previous opinion that it should
> not be turned on without the DBA taking explicit action to turn it on.
> Do you want it on in every future benchmark, for example?

How about with the stats_collector on?  ie. Recording block and row level
stats?

Chris



pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: location of the configuration files
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Hard problem with concurrency