| From: | Steve Poe <spoe(at)sfnet(dot)cc> |
|---|---|
| To: | "mcelroy, tim" <tim(dot)mcelroy(at)bostonstock(dot)com> |
| Cc: | "'pgsql-performance(at)postgresql(dot)org'" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: PG Statistics |
| Date: | 2006-03-14 00:37:51 |
| Message-ID: | 1142296671.11790.28.camel@amd64-gentoo-laptop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris | 2006-03-14 00:40:11 | import performance |
| Previous Message | Michael Fuhr | 2006-03-14 00:18:53 | Re: PG Statistics |