From: | Francisco Reyes <lists(at)stringsutils(dot)com> |
---|---|
To: | G?briel ?kos <akos(dot)gabriel(at)i-logic(dot)hu> |
Cc: | Michael Stone <mstone+postgres(at)mathom(dot)us>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Inserts optimization? |
Date: | 2006-04-15 13:26:46 |
Message-ID: | cone.1145107606.91317.47312.1000@zoraida.natserv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Gábriel Ákos writes:
> you are right. raid5 is definitely not suitable for database activities.
That is not entirely true. :-)
Right now the new server is not ready and the ONLY place I could put the DB
for Bacula was a machine with RAID 5. So far it is holding fine. HOWEVER...
only one bacula job at a time so far and the machine doesn't do anything
else. :-)
> it is good for file servers, though.
Even for a DB server, from what I have read and what I have experienced so
far for mostly read DBs RAID5 should be ok. Specially if you have enough
memory.
As I add more clients to Bacula and the jobs bump into each other I will
better know how the DB holds up. I am doing each FULL backup at a time so
hopefully by the time I do multiple backups from multiple machines less
records will need to be inserted to the DB and there will be a more balanced
operation between reads and writes. Right now there are lots of inserts
going on.
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Reyes | 2006-04-15 13:34:45 | Re: Inserts optimization? |
Previous Message | Francisco Reyes | 2006-04-15 13:16:15 | Re: Inserts optimization? |