Re: Automagic tuning - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Automagic tuning
Date
Msg-id 41066485.7080502@familyhealth.com.au
Whole thread Raw
In response to Automagic tuning  (Markus Schaber <schabios@logi-track.com>)
Responses Re: Automagic tuning
List pgsql-performance
> 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?

Chris

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: best way to fetch next/prev record based on index
Next
From: Tom Lane
Date:
Subject: Re: best way to fetch next/prev record based on index