Re: [PERFORM] separate drives for WAL or pgdata files

2005-12-20 Thread Jim C. Nasby
On Mon, Dec 19, 2005 at 07:20:56PM -0800, David Lang wrote: > for persistant storage you can replicate from your ram-based system to a > disk-based system, and as long as your replication messages hit disk > quickly you can allow the disk-based version to lag behind in it's updates > during your

Re: [PERFORM] separate drives for WAL or pgdata files

2005-12-19 Thread David Lang
On Mon, 19 Dec 2005, David Lang wrote: this is getting dangerously close to being able to fit in ram. I saw an article over the weekend that Samsung is starting to produce 8G DIMM's, that can go 8 to a controller (instead of 4 per as is currently done), when motherboards come out that support

Re: [PERFORM] separate drives for WAL or pgdata files

2005-12-19 Thread David Lang
On Mon, 19 Dec 2005, Anjan Dave wrote: I am not sure if there's an obvious answer to this...If there's a choice of an external RAID10 (Fiber Channel 6 or 8 15Krpm drives) enabled drives, what is more beneficial to store on it, the WAL, or the Database files? One of the other would go on the loca

[PERFORM] separate drives for WAL or pgdata files

2005-12-19 Thread Anjan Dave
Hi,   I am not sure if there’s an obvious answer to this…If there’s a choice of an external RAID10 (Fiber Channel 6 or 8 15Krpm drives) enabled drives, what is more beneficial to store on it, the WAL, or the Database files? One of the other would go on the local RAID10 (4 drives, 15Krpm)