Re: Tuning PostgreSQL

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Tuning PostgreSQL
Дата
Msg-id 1058884665.15452.57.camel@haggis
обсуждение исходный текст
Ответ на Re: Tuning PostgreSQL  ("Alexander Priem" <ap@cict.nl>)
Список pgsql-performance
On Tue, 2003-07-22 at 07:53, Alexander Priem wrote:
> Wow, I never figured how many different RAID configurations one could think
[snip]
> Also because of this battery backed cache controller, I will go for the ext2
> file system, mounted with 'noatime'. I will use a UPS, so I don't think I
> need the journaling of ext3.

Oooooo, I don't think I'd do that!!!!!  It's akin to saying, "I
don't need to make backups, because I have RAID[1,5,10,1+0]

If the power is out for 26 minutes and your UPS only lasts for 25
minutes, you could be in be in for a long, painful boot process if
the box crashes.  (For example, the UPS auto-shutdown daemon doesn't
work properly, and no one can get to the console to shut it down
properly before the batteries die.)


--
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+



В списке pgsql-performance по дате отправления:

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: Tunning FreeeBSD and PostgreSQL
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Tuning PostgreSQL