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
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
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:
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
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
-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
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
-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
>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
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
-
>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
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
>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
-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
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
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
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
17 matches
Mail list logo