| From: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | josh(at)agliodbs(dot)com, Markus Schaber <schabios(at)logi-track(dot)com>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, PostgreSQL Performance List <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Automagic tuning |
| Date: | 2005-02-01 04:52:11 |
| Message-ID: | 20050201045211.GB32356@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Jan 31, 2005 at 03:26:12PM -0500, Tom Lane wrote:
> Josh Berkus <josh(at)agliodbs(dot)com> writes:
> >> I would like something that really measures values like random_page_cost
> >> or cpu_tuple_cost that are hardware dependent.
> >>
> >> I assume such thing does not exist?
>
> > Nope. You gotta whip out your calculator and run some queries.
>
> Preferably a whole lot of queries. All the measurement techniques I can
> think of are going to have a great deal of noise, so you shouldn't
> twiddle these cost settings based on just a few examples.
Are there any examples of how you can take numbers from pg_stats_* or
explain analize and turn them into configuration settings (such and
random page cost)?
--
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2005-02-01 04:56:45 | Re: High end server and storage for a PostgreSQL OLTP system |
| Previous Message | Lago, Bruno Almeida do | 2005-02-01 01:59:46 | Very important choice |