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

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: developer(at)wexwarez(dot)com
Subject: Re: which version? old user coming back....
Date: 2006-11-27 21:39:31
Message-ID: 456B5B13.2090008@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

developer(at)wexwarez(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message George Weaver 2006-11-27 21:42:19 Re: PostgreSQL doesn't accept connections when Windows
Previous Message Scott Ribe 2006-11-27 21:36:24 Re: IS it a good practice to use SERIAL as Primary Key?