Re: [GENERAL] Hardware optimising

1999-08-26 Thread Bruce Momjian
> P.S. From previous posts, I'm starting to think that > there is a VAST misconception that a single-threaded > database engine (which is what Oracle was until some > version 7 releases, I believe, called Oracle MTS > appeared) can only handle ONE query at a time, and > does > not exec() a child

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Andy Lewis
Thanks for the info! Much appreciated! Andy On Thu, 26 Aug 1999, Mike Mascari wrote: > --- Andy Lewis <[EMAIL PROTECTED]> wrote: > > What scheduler are we speaking of here? > > > > Andy > > > > On Thu, 26 Aug 1999, Bruce Momjian wrote: > > > > > > as for the processor, this will see an incr

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Mike Mascari
--- Andy Lewis <[EMAIL PROTECTED]> wrote: > What scheduler are we speaking of here? > > Andy > > On Thu, 26 Aug 1999, Bruce Momjian wrote: > > > > as for the processor, this will see an increase, > of course. note, > > > however, that since PostgreSQL is _not_ > multithreaded, that it will run

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Bruce Momjian
> What scheduler are we speaking of here? > > Andy > > On Thu, 26 Aug 1999, Bruce Momjian wrote: > > > > as for the processor, this will see an increase, of course. note, > > > however, that since PostgreSQL is _not_ multithreaded, that it will run > > > only on one of the processors. (i'm abou

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Andy Lewis
What scheduler are we speaking of here? Andy On Thu, 26 Aug 1999, Bruce Momjian wrote: > > as for the processor, this will see an increase, of course. note, > > however, that since PostgreSQL is _not_ multithreaded, that it will run > > only on one of the processors. (i'm about to assume you ar

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Bruce Momjian
> as for the processor, this will see an increase, of course. note, > however, that since PostgreSQL is _not_ multithreaded, that it will run > only on one of the processors. (i'm about to assume you are using linux > here... 'scuse me if i'm wrong) however, the good news is that you can > encoura

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Aaron J. Seigo
hi... > 128 MB 100 MHz SDRAM > AMD K6-2/300 CPU > 10 GB 7200RPM 9.0ms IBM IDE HDD > > It will, over the next few months, as money becomes available, be upgraded to: > > 256 MB 100 MHz SDRAM > Dual Athlon 500 CPUs > 10 GB UltraII Wide SCSI drive > > The database will contain several million rec

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Bruce Momjian
> Hi > > I am about to upgrade a server that is about to be running a large and busy > postgresql database > currently it has > > 128 MB 100 MHz SDRAM > AMD K6-2/300 CPU > 10 GB 7200RPM 9.0ms IBM IDE HDD > > It will, over the next few months, as money becomes available, be upgraded to: > > 25

Re: [GENERAL] Hardware optimising

1999-08-26 Thread Roderick A. Anderson
On Thu, 26 Aug 1999, Michael wrote: > Hi > > I am about to upgrade a server that is about to be running a large and busy > postgresql database > currently it has > > 128 MB 100 MHz SDRAM > AMD K6-2/300 CPU > 10 GB 7200RPM 9.0ms IBM IDE HDD > >From experience I'd say the biggest performance i

Re: [GENERAL] Hardware optimising

1999-08-26 Thread amy cheng
if in doubt, memory first -- although it depends your app and hits. processor/disk: check your cpu use. amy >From: Michael <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: [GENERAL] Hardware optimising >Date: Thu, 26 Aug 1999 11:19:39 +010

[GENERAL] Hardware optimising

1999-08-26 Thread Michael
Hi I am about to upgrade a server that is about to be running a large and busy postgresql database currently it has 128 MB 100 MHz SDRAM AMD K6-2/300 CPU 10 GB 7200RPM 9.0ms IBM IDE HDD It will, over the next few months, as money becomes available, be upgraded to: 256 MB 100 MHz SDRAM Dual At