PostgreSQL calibration

From: Chris Gamache <cgg007(at)yahoo(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: PostgreSQL calibration
Date: 2003-06-18 16:54:01
Message-ID: 20030618165401.35016.qmail@web13807.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

What's your thought on creating some type of calibration applet that will
divine proper settings for the PostgreSQL performance related variables by
taking into consideration the speed of the machine, amount of RAM, access time
of the filesystem, and the speed of various queries on a standardized (perhaps
non-standardized?) dataset under different conditions?

Is this possible, do-able, or even wanted? Where would one begin constructing
the tests?

I imagine it would automate the tasks that every PostgreSQL administrator goes
through to calibrate his or her installation with the best possible performance
settings...

CG

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2003-06-18 16:55:38 Re: PostgreSQL calibration
Previous Message scott.marlowe 2003-06-18 15:13:13 Re: checking currval

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-06-18 16:55:38 Re: PostgreSQL calibration
Previous Message Bruce Momjian 2003-06-18 16:52:33 Re: Linux supports hot-swappable hardware? [was Re: