Re: [GENERAL] Help making tablespaces work for my application

2011-06-24 Thread Craig Ringer
On 06/23/2011 09:37 PM, Natusch, Paul wrote: I have an application for which data is being written to many disks simultaneously. I would like to use a postgres table space on each disk. If one of the disks crashes it is tolerable to lose that data, however, I must continue to write to the other d

Re: [GENERAL] Help making tablespaces work for my application

2011-06-24 Thread Greg Smith
On 06/23/2011 09:37 AM, Natusch, Paul wrote: I have an application for which data is being written to many disks simultaneously. I would like to use a postgres table space on each disk. If one of the disks crashes it is tolerable to lose that data, however, I must continue to write to the

Re: [GENERAL] Help making tablespaces work for my application

2011-06-23 Thread John R Pierce
If #1 was solved by using the raid approach, what happens if one of the disks containing one of my table spaces crashes. if you are using raid, your tablespaces are on raid volumes comprised of 2 or more drives, any one of those drives may fail, and the full data is still available. if you

[GENERAL] Help making tablespaces work for my application

2011-06-23 Thread Natusch, Paul
I have an application for which data is being written to many disks simultaneously. I would like to use a postgres table space on each disk. If one of the disks crashes it is tolerable to lose that data, however, I must continue to write to the other disks.My specific concerns are: 1.