Hi all, I hope this is the right mailinglist for my question. I'm using postgresql 7.2.1 and doing some bulk-loads from one table to another. Due to sometimes there may exist som already loaded rows the first thing I do is to delete them to reinsert all of them later on. This sequence is but into one transaction.
My problem now is, that postgresql behaves somehow strange. Sometimes when I practice like mentioned above it works just fast within seconds but sometimes it last more than an hour. Both times 30000 rows are processed. Even if I'd like to delete and insert only one row it lasts an hour until I cancel the statement. Does anyone have an idea or can anyone give me some hints how to solve that problem? I'd appreciate any help! Thanks in advance, Yann ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
