> 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