Hey all,
I've never experienced such problems before pefrorming some tests
on large objects. I am on Ubuntu and my HDD is whole encrypted
(LVM2). I've imported large object ~ 1.5 Gb of size. After this, entire
system lost performance dramaticaly and the disk activity becomes
anomalous.
After reboot everithing is fine with OS, but attempt to remove all
large object results in error:
dmitigr=# select lo_unlink(loid) from (select distinct loid from pg_largeobject) as foo;
ERROR: could not read block 704833 in file "base/16386/11838.5": read only 4096 of 8192 bytes
What does this means -- hardware / OS / Postgres failure ?
Any suggestions ?
--
// Dmitriy.