Thanks a million Tom!
SLES support helped upgrade our SLES 9, sp3, linux kernel from 2.6.5-7.244
to 2.6.5-7.282. Since that we haven't had any blocks of rows beign
re-written or blanked out by the kernel. The new kernel is handling the
wirtes much better.
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Saturday, September 23, 2006 1:41 PM
To: Ray Stell
Cc: theman; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] COPY FROM command v8.1.4
Ray Stell <stellr@cns.vt.edu> writes:
> Curious how you get to an OS kernel bug from these writes?
Note the two successive lseek's returning the same result. With a
write() in between that should have extended the file, that is clearly the
wrong answer.
Subsequent discussion reveals that Dan is running
> Linux pike 2.6.5-7.244-smp #1 SMP Mon Dec 12 18:32:25 UTC 2005 x86_64
> x86_64 x86_64 GNU/Linux SLES 9 suse linux enterprise 9 service pack 3
which is probably overdue for an update ...
regards, tom lane