| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Michael Fuhr <mike(at)fuhr(dot)org>, Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, pgsql-performance(at)postgresql(dot)org, Carlos Benkendorf <carlosbenkendorf(at)yahoo(dot)com(dot)br> |
| Subject: | Re: How much expensive are row level statistics? |
| Date: | 2005-12-17 02:44:19 |
| Message-ID: | 200512170244.jBH2iJV11094@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches pgsql-performance |
Tom Lane wrote:
> Michael Fuhr <mike(at)fuhr(dot)org> writes:
> > Further tests show that for this application
> > the killer is stats_command_string, not stats_block_level or
> > stats_row_level.
>
> I tried it with pgbench -c 10, and got these results:
> 41% reduction in TPS rate for stats_command_string
Woh, 41%. That's just off the charts! What are we doing internally
that would cause that?
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-12-17 04:10:43 | Re: Automatic function replanning |
| Previous Message | Mark Kirkwood | 2005-12-17 02:15:01 | Re: Which qsort is used |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-12-17 16:20:19 | Re: Win32 gettimeofday() comment patch |
| Previous Message | Alvaro Herrera | 2005-12-16 23:07:36 | Re: Single-Transaction Utility options |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-12-17 04:28:02 | Re: Should Oracle outperform PostgreSQL on a complex |
| Previous Message | Kyle Cordes | 2005-12-17 01:42:30 | Re: Overriding the optimizer |