Re: pg_autoconfig.pl - Mailing list pgsql-performance

From Josh Berkus
Subject Re: pg_autoconfig.pl
Date
Msg-id 200311220919.23695.josh@agliodbs.com
Whole thread Raw
In response to pg_autoconfig.pl  (Nick Barr <nicky@chuckie.co.uk>)
List pgsql-performance
Nick,

> Josh have you managed to put together the rest of the calculations yet?

Given that I spent most of November working on the PR for the 7.4 release,
I've just started to think about it.  As you can see, I'm thinking about
dovetailing pg_avd and pg_autoconf.

The difficult thing is to figure out settings for "bad" hardware setups.  Like
a 5GB database on a PIII500 + 256mb running 4 other pieces of major software
(I've acctually seen this).    Or a 500/minute OLTP database on a machine
with 1 fixed disk.

All the variables are going into a hash array, right?

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Nick Barr
Date:
Subject: pg_autoconfig.pl
Next
From: William Yu
Date:
Subject: Maximum Possible Insert Performance?