| From: | Hans-Jürgen Schönig <postgres(at)cybertec(dot)at> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Script to compute randon page cost |
| Date: | 2002-09-09 08:16:14 |
| Message-ID: | 3D7C58CE.2030002@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Christopher Kings-Lynne wrote:
>Assuming it's giving out correct information, there seems to be a lot of
>evidence for dropping the default random_page_cost to 1...
>
>Chris
>
>
Some time ago Joe Conway suggest a tool based on a genetic algorithm
which tries to find the best parameter settings.
As input the user could use a set of SQL statements. The algorithm will
try to find those settings which lead to the lowest execution time based
on the set of SQL.
What about something like that?
This way people could tune the database theirselves.
Hans
--
*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at
<http://cluster.postgresql.at>, www.cybertec.at
<http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Curt Sampson | 2002-09-09 10:52:46 | Re: Script to compute random page cost |
| Previous Message | Christopher Kings-Lynne | 2002-09-09 08:08:37 | Re: Script to compute randon page cost |