Re: [PERFORM] PG Statistics

2006-03-14 Thread mcelroy, tim
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

Re: [PERFORM] PG Statistics

2006-03-14 Thread mcelroy, tim
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

Re: [PERFORM] PG Statistics

2006-03-13 Thread Michael Fuhr
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

Re: [PERFORM] PG Statistics

2006-03-13 Thread Steve Poe
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