Crippling Performance Issues: RelStorage/PostgreSQL DB with 44M+ ZODB Objects

[yurj (Yuri)]

Do you have versioning enabled? How many objects do you have from the plone catalog? ZODB object caches?

Did you search in the forum? I've found this that maybe can give some hint:

Zodbconvert incredibly slow [solved]

When I check the current SQL statement that is running on the database server, it is always this: SELECT zoid, tid, prev_tid, current_object_state.state FROM temp_store JOIN current_object_state USING (zoid) WHERE (tid <> prev_tid) If I call this manually it needs round about 35 seconds and returns an empty list. It is not clear to me what it does. But it does this for every transaction if sure will take a while. I could imagine that there are some index…

but seems to be related to the speed of the query. Anyway, adding an index can speed up that query while you're looking for the real problem.