Обсуждение: pg_autoconfig.pl
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
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
----- 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