Hi All,
This is my first post, so I hope I'm in the right area and doing it correctly.
We are having MAJOR & URGENT problems with Postresql occaisonly corrupting tables on insert. I had a quick look through your archive and couldn't find anything. It seems to happen mostly on large inserts (lots of data into one text field). This results in corrupting the table and hanging the psql console whenever I try to INSERT, UPDATE, DELETE, SELECT, etc. Doing an "EXPLAIN SELECT * FROM table" shows that I have around 100 - 1000 extra rows. The problem is often fixed by running VACUUM against the table, however VACUUM often hangs leaving the table locked until I delete the lock file.
Its only a basic INSERT statement into a basic table.
Thanks in advance.
Bruce Irvine.
SportingPulse.