Skip site navigation (1) Skip section navigation (2)

Re: pg_autoconfig.pl

From: "Nick Barr" <nicky(at)chuckie(dot)co(dot)uk>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: pg_autoconfig.pl
Date: 2003-11-24 11:24:47
Message-ID: 000c01c3b27d$91b4fec0$0300a8c0@hare (view raw or flat)
Thread:
Lists: pgsql-performance
----- Original Message ----- 
From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Nick Barr" <nicky(at)chuckie(dot)co(dot)uk>; <pgsql-performance(at)postgresql(dot)org>
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



In response to

pgsql-performance by date

Next:From: Bill MoranDate: 2003-11-24 13:38:31
Subject: Re: Maximum Possible Insert Performance?
Previous:From: Shridhar DaithankarDate: 2003-11-24 05:50:36
Subject: Re: Maximum Possible Insert Performance?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group