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@xxxxxxxxxxxxx] Sent: Saturday, September 23, 2006 1:41 PM To: Ray Stell Cc: theman; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] COPY FROM command v8.1.4 Ray Stell <stellr@xxxxxxxxxx> 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
