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

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:

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 >

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 the

[PERFORM] PG Statistics

2006-03-13 Thread mcelroy, tim
Title: PG Statistics 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'