| From: | Markus Schaber <schabios(at)logi-track(dot)com> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | PostgreSQL Performance List <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Automagic tuning |
| Date: | 2005-01-31 14:54:10 |
| Message-ID: | 41FE4692.6080104@logi-track.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi, Cristopher,
Christopher Kings-Lynne schrieb:
>> Are there any tools that help with postgres/postgis performance tuning?
>>
>> So they measure the acutal tuple costs and cpu power, or suggest optimal
>> values for the index sample counts?
>
> Have you turned on the stat_* settings in postgresql.conf and then
> examined the pg_stat_* system views?
As far as I examined, those views only count several things like fetched
rows and pages, and cache hits.
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?
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios(at)logi-track(dot)com | www.logi-track.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Darley | 2005-01-31 15:06:50 | Re: Possibly slow query |
| Previous Message | Manfred Koizar | 2005-01-31 11:06:01 | Re: Possibly slow query |