Re: [PERFORM] Postgres delete performance problem

Hello, Just wondering whether you were able to resolve this issue. We are experiencing a very similar issue with deletes using Postgrs 9.0.5 on Ubuntu 12.04. Dan -- View this message in context: http://postgresql.1045698.n5.nabble.com/Postgres-delete-performance-problem-tp5714153p5738765.html

Re: [PERFORM] Postgres delete performance problem

"It does so by removing all constraints, then it compares table contents row by row, inserts missing rows and deletes "extra" rows in the target database." If the delete's you do when the constraints and indexes are removed then you need to create the constraints and indexes before you delete the

Re: [PERFORM] Postgres delete performance problem

Hello. This may be wrong type for parameter, like using setObject(param, value) instead of setObject(param, value, type). Especially if value passed is string object. AFAIR index may be skipped in this case. You can check by changing statement to "delete from xxx where xxx_pk=?::bigint". If it