On Thu, Nov 24, 2005 at 02:59:28PM -0500, Qingqing Zhou wrote: > > "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote > > > > At this point I think there's no question that your filesystem is > > dropping blocks :-(. > > It is very interesting to follow this thread. But at this point, can you > explain more why "there is no question" is file system's fault? Not to put words in Tom's mouth, but as he said there's very few ways that PostgreSQL will leave a blank page laying around, and the tests he had the OP perform show that this almost certainly isn't one of those cases. That means something other than PostgreSQL is dropping data. Since it's apparently multiples of 4k it's reasonable to suspect the kernel or the filesystem; it's pretty unlikely it's the drives. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
