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:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
