pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_autoconfig.pl
3+ messages / 2 participants
[nested] [flat]
* pg_autoconfig.pl
@ 2003-11-22 11:56 Nick Barr <nicky@chuckie.co.uk>
2003-11-22 17:19 ` Re: pg_autoconfig.pl Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 3+ messages in thread
From: Nick Barr @ 2003-11-22 11:56 UTC (permalink / raw)
To: josh@agliodbs.com; pgsql-performance
Heya,
Sorry for no updates on the old pg_autoconfig script thing, been rather
busy at work the last week or two :-( but i suppose it pays the bills. I
do have a few days off work now so I can spend some time on finishing
the first version off. The latest version can be found at
http://www.chuckie.co.uk/postgresql/pg_autoconfig.txt
Josh have you managed to put together the rest of the calculations yet?
Thanks,
Nick
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_autoconfig.pl
2003-11-22 11:56 pg_autoconfig.pl Nick Barr <nicky@chuckie.co.uk>
@ 2003-11-22 17:19 ` Josh Berkus <josh@agliodbs.com>
2003-11-24 11:24 ` Re: pg_autoconfig.pl Nick Barr <nicky@chuckie.co.uk>
0 siblings, 1 reply; 3+ messages in thread
From: Josh Berkus @ 2003-11-22 17:19 UTC (permalink / raw)
To: Nick Barr <nicky@chuckie.co.uk>; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_autoconfig.pl
2003-11-22 11:56 pg_autoconfig.pl Nick Barr <nicky@chuckie.co.uk>
2003-11-22 17:19 ` Re: pg_autoconfig.pl Josh Berkus <josh@agliodbs.com>
@ 2003-11-24 11:24 ` Nick Barr <nicky@chuckie.co.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Nick Barr @ 2003-11-24 11:24 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; pgsql-performance
----- Original Message -----
From: "Josh Berkus" <josh@agliodbs.com>
To: "Nick Barr" <nicky@chuckie.co.uk>; <pgsql-performance@postgresql.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-11-24 11:24 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-11-22 11:56 pg_autoconfig.pl Nick Barr <nicky@chuckie.co.uk>
2003-11-22 17:19 ` Josh Berkus <josh@agliodbs.com>
2003-11-24 11:24 ` Nick Barr <nicky@chuckie.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox