The following bug has been logged online: Bug reference: 2631 Logged by: Ross Elliott Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Red Hat AS 4 Description: database locking problem Details:
I have a dataset of aprox 650 million rows that I load into 5 spatial (PostGIS) tables using 9 client machines (via JDBC). On 8.1.3 this all works fine but on 8.1.4 it will fail with just three clients loading the data. The database will lock up, the process list shows the clients performing an INSERT, the postgres locks show each client having an exclusive row lock and these locks seem to move about, that is it would seem to be working, except that nothing is being inserted, I've left the system in this state for over a day just to make sure. So, what happened between 8.1.3 and 8.1.4 that may have affected locking? ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
