pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950
5+ messages / 4 participants
[nested] [flat]
* Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950
@ 2007-07-14 08:29 Hannes Dorbath <light@theendofthetunnel.de>
2007-07-14 08:34 ` Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Steinar H. Gunderson <sgunderson@bigfoot.com>
2007-07-14 09:57 ` Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Gregory Stark <stark@enterprisedb.com>
0 siblings, 2 replies; 5+ messages in thread
From: Hannes Dorbath @ 2007-07-14 08:29 UTC (permalink / raw)
To: Joseph <spmok2@canada.com>
Joseph wrote:
> We just got a DELL POWEREDGE 2950. So I was tasked with putting
> Linux Redhat and dumped our software/packages on it. Contrary to
> common sense, I didn't bother reading the manuals that came with te
> 2950. I went right ahead and installed Redhat server on it, then went
> and loaded the backups software/data etc onto it and started having
> the team use it.
And this has to do with pgsql.performance exactly what?
Anyway, as someone who seems to administrates a PostgreSQL production
box, you sure have a good backup plan. So just call DELL's support, fix
you RAID and restore form backup.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950
2007-07-14 08:29 Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Hannes Dorbath <light@theendofthetunnel.de>
@ 2007-07-14 08:34 ` Steinar H. Gunderson <sgunderson@bigfoot.com>
1 sibling, 0 replies; 5+ messages in thread
From: Steinar H. Gunderson @ 2007-07-14 08:34 UTC (permalink / raw)
To: pgsql-performance
On Sat, Jul 14, 2007 at 10:29:05AM +0200, Hannes Dorbath wrote:
> From the DELL site it seems this `PERC 5/i' on board controller
> (assuming that's what you have) doesn't even have a BBU. If you don't
> plan to post here in a few weeks again about data corruption, go out and
> shop a serious controller.
We have a 2950 with a PERC, and it has a BBU.
/* Steinar */
--
Homepage: http://www.sesse.net/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950
2007-07-14 08:29 Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Hannes Dorbath <light@theendofthetunnel.de>
@ 2007-07-14 09:57 ` Gregory Stark <stark@enterprisedb.com>
2007-07-14 10:19 ` Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Hannes Dorbath <light@theendofthetunnel.de>
1 sibling, 1 reply; 5+ messages in thread
From: Gregory Stark @ 2007-07-14 09:57 UTC (permalink / raw)
To: Hannes Dorbath <light@theendofthetunnel.de>; +Cc: Joseph <spmok2@canada.com>; pgsql-performance
"Hannes Dorbath" <light@theendofthetunnel.de> writes:
> From the DELL site it seems this `PERC 5/i' on board controller
> (assuming that's what you have) doesn't even have a BBU. If you don't
> plan to post here in a few weeks again about data corruption, go out and
> shop a serious controller.
This is a bit of a strange comment. A BBU will improve performance but
Postgres doesn't require one to guarantee data integrity.
If your drives have write caching disabled (ie write-through) and your
controller does write-through caching and you leave fsync=on and
full_page_writes=on which is the default then you shouldn't have any data
integrity issues.
Note that many drives, especially IDE drives ship with write caching enabled
(ie, write-back).
And without a BBU many people are tempted to set fsync=off which improves
performance at the cost of data loss on a system crash or power failure. With
a BBU there's no advantage to fsync=off so that temptation to risk data loss
is removed.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950
2007-07-14 08:29 Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Hannes Dorbath <light@theendofthetunnel.de>
2007-07-14 09:57 ` Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Gregory Stark <stark@enterprisedb.com>
@ 2007-07-14 10:19 ` Hannes Dorbath <light@theendofthetunnel.de>
2007-07-16 21:02 ` Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Jim C. Nasby <decibel@decibel.org>
0 siblings, 1 reply; 5+ messages in thread
From: Hannes Dorbath @ 2007-07-14 10:19 UTC (permalink / raw)
To: Gregory Stark <stark@enterprisedb.com>
Gregory Stark wrote:
>> From the DELL site it seems this `PERC 5/i' on board controller
>> (assuming that's what you have) doesn't even have a BBU. If you don't
>> plan to post here in a few weeks again about data corruption, go out and
>> shop a serious controller.
>
> This is a bit of a strange comment. A BBU will improve performance but
> Postgres doesn't require one to guarantee data integrity.
>
> If your drives have write caching disabled (ie write-through) and your
> controller does write-through caching and you leave fsync=on and
> full_page_writes=on which is the default then you shouldn't have any data
> integrity issues.
That was my point, controllers without BBU usually leave drive caches
turned on, as with drive caches off performance would be unbearable bad.
--
Best regards,
Hannes Dorbath
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950
2007-07-14 08:29 Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Hannes Dorbath <light@theendofthetunnel.de>
2007-07-14 09:57 ` Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Gregory Stark <stark@enterprisedb.com>
2007-07-14 10:19 ` Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Hannes Dorbath <light@theendofthetunnel.de>
@ 2007-07-16 21:02 ` Jim C. Nasby <decibel@decibel.org>
0 siblings, 0 replies; 5+ messages in thread
From: Jim C. Nasby @ 2007-07-16 21:02 UTC (permalink / raw)
To: Hannes Dorbath <light@theendofthetunnel.de>; +Cc: Gregory Stark <stark@enterprisedb.com>; pgsql-performance
On Sat, Jul 14, 2007 at 12:19:51PM +0200, Hannes Dorbath wrote:
> Gregory Stark wrote:
> >> From the DELL site it seems this `PERC 5/i' on board controller
> >> (assuming that's what you have) doesn't even have a BBU. If you don't
> >> plan to post here in a few weeks again about data corruption, go out and
> >> shop a serious controller.
> >
> > This is a bit of a strange comment. A BBU will improve performance but
> > Postgres doesn't require one to guarantee data integrity.
> >
> > If your drives have write caching disabled (ie write-through) and your
> > controller does write-through caching and you leave fsync=on and
> > full_page_writes=on which is the default then you shouldn't have any data
> > integrity issues.
>
> That was my point, controllers without BBU usually leave drive caches
> turned on, as with drive caches off performance would be unbearable bad.
Wow, are you sure about that? I've never heard it before, but that'd be
pretty disturbing if it's true...
--
Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-07-16 21:02 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-14 08:29 Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Hannes Dorbath <light@theendofthetunnel.de>
2007-07-14 08:34 ` Steinar H. Gunderson <sgunderson@bigfoot.com>
2007-07-14 09:57 ` Gregory Stark <stark@enterprisedb.com>
2007-07-14 10:19 ` Hannes Dorbath <light@theendofthetunnel.de>
2007-07-16 21:02 ` Jim C. Nasby <decibel@decibel.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox