Re: which version? old user coming back....

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: which version? old user coming back....
Дата
Msg-id 456B5B13.2090008@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: which version? old user coming back....  (developer@wexwarez.com)
Список pgsql-general
developer@wexwarez.com wrote:
>>> ...Should I expect
>>> any problems with this even on the old 2.4 kernel?
>>
>> I'd advise you to be using a 2.6 kernel at this point, too.
>>
> ... I assume 8 will still work on 2.4 though.

IIRC, you need a reasonably modern 2.6 kernel (early 2005)
if you want fsync() to flush the write caches on hard
disks (IDE and SATA and SCSI included).  The Linux SATA
driver author explains here:
 http://hardware.slashdot.org/comments.pl?sid=149349&cid=12519114

Anyone know if those write barrier patches were ever
backported into the 2.4 kernels?

If not, I think you need to either use 2.6 or disable
the disk's write caches and suffer the performance hits.

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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: IS it a good practice to use SERIAL as Primary Key?
Следующее
От: George Weaver
Дата:
Сообщение: Re: PostgreSQL doesn't accept connections when Windows