From: Steve Poe
Subject: Re: PG Statistics
Date: ,
Msg-id: 1142296671.11790.28.camel@amd64-gentoo-laptop
(view: Whole thread, Raw)
In response to: PG Statistics  ("mcelroy, tim")
List: pgsql-performance

Tree view

PG Statistics  ("mcelroy, tim", )
 Re: PG Statistics  (Michael Fuhr, )
 Re: PG Statistics  (Steve Poe, )
 Re: PG Statistics  ("mcelroy, tim", )
 Re: PG Statistics  ("mcelroy, tim", )

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
>



pgsql-performance by date:

From: Chris
Date:
Subject: Re: import performance
From: "andremachado"
Date:
Subject: firebird X postgresql 8.1.2 windows, performance comparison