| From: | Daniel Ceregatti <daniel(at)omnis(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | ricardo(at)sqlmagazine(dot)com(dot)br |
| Subject: | Re: Article about PostgreSQL and RAID in Brazil |
| Date: | 2004-09-16 18:10:13 |
| Message-ID: | 4149D705.7050900@omnis.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
>The first part of the article can be found in
>http://www.sqlmagazine.com.br/colunistas.asp?artigo=Colunistas/RicardoRezende/06_Raid_P1.asp
>
>
The site seems to be down. I was looking forward to reading it. :(
>The first and most important step for RAID performance with PostgreSQL is to
>get a card with onboard battery back-up and enable the write cache for the
>card. You do not want to enable the write cache *without* battery back-up
>because of the risk of data corruption after a power failure.
>
>
Here is a small example of the performance difference with write cache:
--
Daniel Ceregatti - Programmer
Omnis Network, LLC
A little suffering is good for the soul.
-- Kirk, "The Corbomite Maneuver", stardate 1514.0
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steinar H. Gunderson | 2004-09-16 18:57:32 | Re: Article about PostgreSQL and RAID in Brazil |
| Previous Message | Tom Lane | 2004-09-16 18:07:43 | Re: declared cursor uses slow plan |