Chris Gamache wrote:
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 queri
On June 18, 2003 12:54 pm, Chris Gamache wrote:
> What's your thought on creating some type of calibration applet that
> will divine proper settings for the PostgreSQL performance related
Have you seen pg_autotune? It's aging... but might be something to play
with.
http://gborg.postgresql.org/pr
Precisely. Any hints from the real gurus out there as to how that might
be accomplished (or alternatively, reasons why it's hopeless)?
On Wed, 2003-06-18 at 18:42, scott.marlowe wrote:
> It would be nice to have something that could suggest settings for the
> different *cost* options.
>
> On 18
It would be nice to have something that could suggest settings for the
different *cost* options.
On 18 Jun 2003, matt wrote:
> Are there really any performance settings of much interest beyond the
> shared and non-shared memory settings? Beyond those the interactions
> get so complex that autom
Are there really any performance settings of much interest beyond the
shared and non-shared memory settings? Beyond those the interactions
get so complex that automation is probably impossible anyway, and
certain options like fsync = false should never be 'recommended'.
On the other hand, a way o
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Sure, it would be great if we could do it.
If the program actually derives reliable numbers, it would be great.
It could easily do more harm than good if it gives bogus results.
I think it will be very hard to get reliable rather than bogus results
:-( .
Sure, it would be great if we could do it.
---
Chris Gamache wrote:
> What's your thought on creating some type of calibration applet that will
> divine proper settings for the PostgreSQL performance related variables by
> t
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 (