Re: [GENERAL] advice on buying sun hardware to run postgres

1999-05-05 Thread Michael Davis
: pgsql-general @ postgreSQL.org@SMTP@EXCHANGE Subject:Re: [GENERAL] advice on buying sun hardware to run postgres Bruce Momjian wrote: There is. Linux/*BSD use only a big kernel lock, or several big kernel locks. I think

Re: [GENERAL] advice on buying sun hardware to run postgres

1999-05-04 Thread Bruce Momjian
Bruce Momjian wrote: There is. Linux/*BSD use only a big kernel lock, or several big kernel locks. I think you're talking silly. BSD has one big lock, but my count there are around 60 locks in Linux 2.2. Solaris has thousands of locks. OK, *BSD has one, Linux has 60, and

Re: [GENERAL] advice on buying sun hardware to run postgres

1999-04-27 Thread Chris Bitmead
Dustin Sallings wrote: Works != works as well as SCSI. I've yet to find an example where IDE works as well as SCSI in real life (vs. benchmarks). My real life scenarios rarely involve telling a machine to be still so we can do a disk read, then again for a disk write. Modern

Re: [GENERAL] advice on buying sun hardware to run postgres

1999-04-27 Thread Maarten Boekhold
Never lost a file to Linux in 5 years. Haha, just lost my home directory this weekend. But then again, I was in win98 when my rabbit chewed through a 220V cable and the whole room went black. Might just have something to do with it (but on the other hand, win98 shouldn't even be touching that

Re: [GENERAL] advice on buying sun hardware to run postgres

1999-04-27 Thread Chris Bitmead
Maarten Boekhold wrote: Never lost a file to Linux in 5 years. Haha, just lost my home directory this weekend. But then again, I was in win98 when my rabbit chewed through a 220V cable and the whole room went black. Might just have something to do with it (but on the other hand, win98

Re: [GENERAL] advice on buying sun hardware to run postgres

1999-04-27 Thread Dustin Sallings
On Tue, 27 Apr 1999, Chris Bitmead wrote: # Modern operating systems don't ask the disk to do something and then # just wait for the answer. That's what interrupts are for. Anyway, modern # disks have caches. You can only cache so much. At some point, you're going to actually want to

Re: [GENERAL] advice on buying sun hardware to run postgres

1999-04-26 Thread Statistical Solutions
On Sun, 25 Apr 1999, Eric Enockson wrote: I am going to buying a sun server to run postgres on as a backend database server for a www site. Does anyone have suggestions on what to buy? Does anyone have advice on running postgres on solaris or suggestions not to? Several posters have

Re: [GENERAL] advice on buying sun hardware to run postgres

1999-04-26 Thread Bruce Momjian
Works != works as well as SCSI. I've yet to find an example where IDE works as well as SCSI in real life (vs. benchmarks). My real life scenarios rarely involve telling a machine to be still so we can do a disk read, then again for a disk write. Probably true. IDE can not access

Re: [GENERAL] advice on buying sun hardware to run postgres

1999-04-26 Thread Adriaan Joubert
Jim Jennis wrote: A DEC (sorry Compaq) Alpha running Linux is a mean combination. Used Alpha's can be had fairly cheap and they really scream. If cost is an issue, I would look for an older one used e.g. a DEC 2100/A500MP (was marketed as a "Sable") Put Linux on the beast and watch the