Title: RE: [PERFORM] PG Statistics
Thank you for the insight Michael. I'll be performing some tests with the various setting on/off this week and will post the results.
Tim
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 13, 2006 7:19 PM
Title: RE: [PERFORM] 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:[EMAIL PROTECTED]]
Sent: Monday, March 13, 2006 7:38 PM
To: mcelroy, tim
On Mon, Mar 13, 2006 at 06:49:39PM -0500, mcelroy, tim wrote:
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
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