Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Greg Smith
On Wed, 12 Sep 2007, Phoenix Kiula wrote: Just to confirm -- why do you say "[Opteron] will have 2X as many disks"? In the dual-Opteron setup above I have 2 hard disks with RAID1, whereas in the single-Xeon quad-core setup I have 4 disks with RAID 10. What I was trying to suggest was that the

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Andrej Ricnik-Bay
On 9/12/07, Phoenix Kiula <[EMAIL PROTECTED]> wrote: > Just to confirm -- why do you say "[Opteron] will have 2X as many > disks"? In the dual-Opteron setup above I have 2 hard disks with > RAID1, whereas in the single-Xeon quad-core setup I have 4 disks with > RAID 10. He didn't say that. Read hi

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Phoenix Kiula
On 12/09/2007, Greg Smith <[EMAIL PROTECTED]> wrote: > On Wed, 12 Sep 2007, Phoenix Kiula wrote: > > > Scenario 1, SATAII: > > - Server: Asus RS120-E4/PA4 Dedicated Server > > - CPU: Single -- Intel Quad Core Xeon Processor x3210 Processor 2.13Ghz > > - RAM: 4Gb DDR2 Memory 667Mhz > > - Hard disk:

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Greg Smith
On Wed, 12 Sep 2007, Phoenix Kiula wrote: Scenario 1, SATAII: - Server: Asus RS120-E4/PA4 Dedicated Server - CPU: Single -- Intel Quad Core Xeon Processor x3210 Processor 2.13Ghz - RAM: 4Gb DDR2 Memory 667Mhz - Hard disk: 4 x Seagate ES SATAII HardDrive 7200RPM 250Gb (Total 500Gb) - Raid 10: 3Wa

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Scott Marlowe
On 9/11/07, Phoenix Kiula <[EMAIL PROTECTED]> wrote: > Thanks Greg. > Scenario 1, SATAII: > > - Server: Asus RS120-E4/PA4 Dedicated Server > - CPU: Single -- Intel Quad Core Xeon Processor x3210 Processor 2.13Ghz > - RAM: 4Gb DDR2 Memory 667Mhz > - Hard disk: 4 x Seagate ES SATAII HardDrive 7200RPM

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/11/07 12:02, Phoenix Kiula wrote: > On 12/09/2007, Ron Johnson <[EMAIL PROTECTED]> wrote: >> How (on average) large are the records you need to insert, and how >> evenly spread across the 24 hour day do the inserts occur? > > > There will be ar

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Phoenix Kiula
On 12/09/2007, Ron Johnson <[EMAIL PROTECTED]> wrote: > How (on average) large are the records you need to insert, and how > evenly spread across the 24 hour day do the inserts occur? There will be around 15,000 inserts in a day. Each insert will have several TEXT columns, so it is difficult to p

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/11/07 11:26, Phoenix Kiula wrote: > Thanks Greg. > > >> You're not going to get a particularly useful answer here without giving >> some specifics about the two disk controllers you're comparing, how much >> cache they have, and whether they in

Re: [SPAM] Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Franz . Rasper
>Scenario 1, SATAII: > >- Server: Asus RS120-E4/PA4 Dedicated Server >- CPU: Single -- Intel Quad Core Xeon Processor x3210 Processor 2.13Ghz >- RAM: 4Gb DDR2 Memory 667Mhz >- Hard disk: 4 x Seagate ES SATAII HardDrive 7200RPM 250Gb (Total 500Gb) >- Raid 10: 3Ware Raid 9650SE: http://www.acnc.com/0

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Phoenix Kiula
Thanks Greg. > You're not going to get a particularly useful answer here without giving > some specifics about the two disk controllers you're comparing, how much > cache they have, and whether they include a battery backup. > Scenario 1, SATAII: - Server: Asus RS120-E4/PA4 Dedicated Server -

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Franz . Rasper
>The point people are trying to make to you is that the differences between >RAID controllers can be as big as that between RAID architectures in cases >like yours. Which controller you're using and how the cache is setup can >have a larger impact on INSERT performance than how many/what type o

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Greg Smith
On Tue, 11 Sep 2007, Phoenix Kiula wrote: I'll have a raid controller in both scenarios, but which RAID should be better: RAID1 or RAID10? The point people are trying to make to you is that the differences between RAID controllers can be as big as that between RAID architectures in cases lik

Re: [SPAM] Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Franz . Rasper
>This one will be a hugely INSERT thing, very low on UPDATEs. The >INSERTS will have many TEXT fields as they are free form data. So the >database will grow very fast. Size will grow pretty fast too. >> You should use a hardware raid controller with battery backup write cache >> (write cache shoul

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/11/07 07:55, Phoenix Kiula wrote: > On 11/09/2007, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> It depends what you want to do with your database. >> >> Do you have many reads (select) or a lot of writes (update,insert) ? > > > This one will

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Phoenix Kiula
On 11/09/2007, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > It depends what you want to do with your database. > > Do you have many reads (select) or a lot of writes (update,insert) ? This one will be a hugely INSERT thing, very low on UPDATEs. The INSERTS will have many TEXT fields as they are

Re: [GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Franz . Rasper
have ? How big is your database, tables ... ? Greetings, -Franz -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Phoenix Kiula Gesendet: Dienstag, 11. September 2007 13:49 An: Postgres General Betreff: [GENERAL] Hardware recommendation: which

[GENERAL] Hardware recommendation: which is best

2007-09-11 Thread Phoenix Kiula
Hello We're trying to look for the most optimal config for a heavy duty production server, and the following two are falling in the same price range from our supplier: Option 1: 2 x 300GB SCSI (10k rpm) with SAS and RAID 1 Option 2: 4 x 300GB SATA2 (7200 rpm, server grade) with RAID 10 I am not