Ivan Voras wrote:
Joshua D. Drake wrote:
This scares me... You lose WAL you are a goner. Combine your OS and
WAL into a RAID 1.
Can someone elaborate on this? From the WAL concept and documentation at
http://www.postgresql.org/docs/8.3/interactive/wal-intro.html I'd say
the only data that sho
Joshua D. Drake wrote:
> This scares me... You lose WAL you are a goner. Combine your OS and
> WAL into a RAID 1.
Can someone elaborate on this? From the WAL concept and documentation at
http://www.postgresql.org/docs/8.3/interactive/wal-intro.html I'd say
the only data that should be lost are th
On Mon, Mar 3, 2008 at 8:48 AM, Mark Mielke <[EMAIL PROTECTED]> wrote:
> Matthew wrote:
> > On Sat, 1 Mar 2008, Craig James wrote:
> >> Right, I do understand that, but reliability is not a top priority in
> >> this system. The database will be replicated, and can be reproduced
> >> from the r
Matthew wrote:
On Mon, 3 Mar 2008, Mark Mielke wrote:
Has anybody been able to prove to themselves that RAID 0 vs RAID 1+0
is faster for these sorts of loads? My understanding is that RAID 1+0
*can* reduce latency for reads, but that it relies on random access,
whereas RAID 0 performs best for
On Mon, 3 Mar 2008, Mark Mielke wrote:
Has anybody been able to prove to themselves that RAID 0 vs RAID 1+0 is
faster for these sorts of loads? My understanding is that RAID 1+0 *can*
reduce latency for reads, but that it relies on random access, whereas RAID 0
performs best for sequential scan
Matthew wrote:
On Sat, 1 Mar 2008, Craig James wrote:
Right, I do understand that, but reliability is not a top priority in
this system. The database will be replicated, and can be reproduced
from the raw data.
So what you're saying is:
1. Reliability is not important.
2. There's zero write
Matthew wrote:
On Sat, 1 Mar 2008, Craig James wrote:
Right, I do understand that, but reliability is not a top priority in
this system. The database will be replicated, and can be reproduced
from the raw data.
So what you're saying is:
1. Reliability is not important.
2. There's zero write
On Sat, 1 Mar 2008, Craig James wrote:
Right, I do understand that, but reliability is not a top priority in this
system. The database will be replicated, and can be reproduced from the raw
data.
So what you're saying is:
1. Reliability is not important.
2. There's zero write traffic once th
On Sat, 1 Mar 2008, Craig James wrote:
So my question still stands: From a strictly performance point of view, would
it be better to separate the OS and the WAL onto two disks?
You're not getting a more useful answer here because you haven't mentioned
yet a) what the disk controller is or b)
On Sat, Mar 1, 2008 at 3:53 PM, Craig James <[EMAIL PROTECTED]> wrote:
> Joshua D. Drake wrote:
> > On Sat, 01 Mar 2008 10:06:54 -0800
> > Craig James <[EMAIL PROTECTED]> wrote:
> >
> >> We're upgrading to a medium-sized server, a Dell PowerEdge 2950,
> >> dual-quad CPU's and 8 GB memory. Thi
Joshua D. Drake wrote:
On Sat, 01 Mar 2008 10:06:54 -0800
Craig James <[EMAIL PROTECTED]> wrote:
We're upgrading to a medium-sized server, a Dell PowerEdge 2950,
dual-quad CPU's and 8 GB memory. This box can hold at most 8 disks
(10K SCSI 2.5" 146 GB drives) and has Dell's Perc 6/i RAID contro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sat, 01 Mar 2008 10:06:54 -0800
Craig James <[EMAIL PROTECTED]> wrote:
> We're upgrading to a medium-sized server, a Dell PowerEdge 2950,
> dual-quad CPU's and 8 GB memory. This box can hold at most 8 disks
> (10K SCSI 2.5" 146 GB drives) and has
On Sat, Mar 1, 2008 at 12:06 PM, Craig James <[EMAIL PROTECTED]> wrote:
> We're upgrading to a medium-sized server, a Dell PowerEdge 2950, dual-quad
> CPU's and 8 GB memory. This box can hold at most 8 disks (10K SCSI 2.5" 146
> GB drives) and has Dell's Perc 6/i RAID controller.
>
> I'm thinki
We're upgrading to a medium-sized server, a Dell PowerEdge 2950, dual-quad CPU's and
8 GB memory. This box can hold at most 8 disks (10K SCSI 2.5" 146 GB drives)
and has Dell's Perc 6/i RAID controller.
I'm thinking of this:
6 disks RAID 1+0 Postgres data
1 disk WAL
1 disk Linux
I'v
14 matches
Mail list logo
