Re: PG Statistics

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tim,

When I have done ODBC load tests with stats_block_level enabled on (20
mins. per test), I've seen about 3-4% performance hit. Your mileage may
vary.

Steve Poe

On Mon, 2006-03-13 at 18:49 -0500, mcelroy, tim wrote:
> Good evening,
> 
> Does anyone know how much of a performance hit turning
> stats_block_level and  stats_row_level on will incur?  Do both need to
> be on to gather cache related statistics?  I know the
> annotated_conf_80 document states to only turn them on for debug but
> if they're not that performance intensive I cannot see the harm.
> 
> Thank you, 
> Tim McElroy
> 



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux