Re: Advantages and disadvantages of more than one dbserver - Mailing list pgsql-admin

From Daniel Seichter
Subject Re: Advantages and disadvantages of more than one dbserver
Date
Msg-id be373j$91t$1@main.gmane.org
Whole thread Raw
In response to Re: Advantages and disadvantages of more than one dbserver  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Advantages and disadvantages of more than one dbserver
List pgsql-admin
Hello Sam and Scott
> We'll be looking at more performance boosts once the system is mature.
> We already have the DB on a dedicated drive, on a dedicated controller.
> Moving to a RAID 1 config with another 120GB drive would be good. The DB
> on disk currently takes up about 35GB with only 1 quarters data, but
> growth with longer timespans should be minimal as the DB is very well
> normalised. RAID 5 not an option in the current box, as there are not
> enough bays in the (crappy RM desktop) case, and we'd have to use
> software RAID or buy a more epensive controller, and probably move to
> SCSI, which would be expensive enough to justify buying a small
> dedicated box instead, which would be better in many ways. When ones
> workstation is also supposed to be a high-availability server, certain
> things become difficult.
Is there any knowned rate in percent, how much faster a database will be if
I would put 1GB instead of 512MB into my server?
What RAID do you prefer? A 'simple' RAID1 should be enough or do you prefer
RAID5 or what else?

Daniel



pgsql-admin by date:

Previous
From: Sam Barnett-Cormack
Date:
Subject: Re: Advantages and disadvantages of more than one dbserver
Next
From: "Mendola Gaetano"
Date:
Subject: pg_dump trunc some rows