Hello, im using postgresql 8 under SLES 9 and RH 3.x - under both OS i encountered the following problem : Lets say i have a table, which has no reference to any other table - and i create one entry for each day of the year within this table (PK). During a day, i update the values within that specific entry - this entry will be updated from multiple threads. Under a higher load, i get a message from postgresql "deadlock detected" - im using JDBC to update/query postgresql. However, i do not understand why i would get a "deadlock detected" error message because i only INCREASE the values of the fields - i do not overwrite them - my statement simplified looks like this : update mytable set field1 = field1 + 1, field2 = field2 + 4200 where pkDate = someDate Now, multiple threads with a connection pool are connecting to postgres - and i can reproduce the deadlock problem when i use a test class which starts 1000 threads to update this table. Increasing the value of deadlock_timeout helps a bit - but solves not the problem - because i think there should not be a problem at all - the transaction management of postgres should be able to handle two or more threads which only want to increase the value o f specific fields - like in programming i++; Releated Questions a) Is there another way to increase field values within postgres other then field = field + MY_VALUE b) Is it a problem with postgresql or is it my code ? Thanks __________________________________________ Yahoo! DSL ? Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com
