Re: [PATCHES] O_DIRECT for WAL writes

Поиск
Список
Период
Сортировка
От Gavin Sherry
Тема Re: [PATCHES] O_DIRECT for WAL writes
Дата
Msg-id Pine.LNX.4.58.0506231446210.21186@linuxworld.com.au
обсуждение исходный текст
Ответ на Re: [PATCHES] O_DIRECT for WAL writes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, 23 Jun 2005, Tom Lane wrote:

> Gavin Sherry <swm@linuxworld.com.au> writes:
> >> Curt Sampson <cjs@cynic.net> writes:
> >>> But is it really a problem? I somewhere got the impression that some
> >>> drives, on power failure, will be able to keep going for long enough to
> >>> write out the cache and park the heads anyway. If so, the drive is still
> >>> guaranteeing the write.
>
> > I've seen discussion about disks behaving this way. There's no magic:
> > they're battery backed.
>
> Oh, sure, then it's easy ;-)
>
> The bottom line here seems to be the same as always: you can't run an
> industrial strength database on piece-of-junk consumer grade hardware.
> Our problem is that because the software is free, people expect to run
> it on bottom-of-the-line Joe Bob's Bait And PC Shack hardware, and then
> they blame us when they don't get the same results as the guy running
> Oracle on million-dollar triply-redundant server hardware.  Oh well.

If you ever need a second job, I recommend stand up comedy :-).

Gavin


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: HaveNFreeProcs ?
Следующее
От: Curt Sampson
Дата:
Сообщение: Re: [PATCHES] O_DIRECT for WAL writes