Re: PG Statistics

Thanks you Steve. As mentioned in my other reply to Michael Fuhr I'll post
the results from tests to be performed this week.

Tim

-----Original Message-----
From: Steve Poe [mailto:spoe(at)sfnet(dot)cc]
Sent: Monday, March 13, 2006 7:38 PM
To: mcelroy, tim
Cc: 'pgsql-performance(at)postgresql(dot)org'
Subject: Re: [PERFORM] PG Statistics

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
>