Skip site navigation (1) Skip section navigation (2)

Re: Automagic tuning

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 (view raw or flat)
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

In response to

Responses

pgsql-performance by date

Next:From: Peter DarleyDate: 2005-01-31 15:06:50
Subject: Re: Possibly slow query
Previous:From: Manfred KoizarDate: 2005-01-31 11:06:01
Subject: Re: Possibly slow query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group