Re: [PERFORM] pg_autoconfig.pl

2003-11-24 Thread Nick Barr
- Original Message - 
From: "Josh Berkus" <[EMAIL PROTECTED]>
To: "Nick Barr" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, November 22, 2003 5:19 PM
Subject: Re: pg_autoconfig.pl


> 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?

Yep that rights.$sys is the array name. And there are loads of different
keys for the hash. I will try and get a listing out of the script sometime.


Nick



---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [PERFORM] pg_autoconfig.pl

2003-11-22 Thread Josh Berkus
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

---(end of broadcast)---
TIP 8: explain analyze is your friend