Hello,

Now I can reproduce that situation, when that query and all others
that is using these tables is getting so slow. I have procedure in my
app where I delete many (~14000) records from 3 tables, run select
query and post results (also 14000 records). I do this thing in one
transaction, becouse I have to make sure everything was ok with select
and posts before I delete old records (deleted records are not
participating in select query).

So after delete, select, post, commit whatever I do with subselects on
these tables takes ages to finish. Normaly it takes ~1 min after this
procedure the same things takes ~1h. This stops happening just after I
backup and restore db. Sweep do not help.