Joshua D. Drake wrote:
Gábor Farkas wrote:
hi,
i have a postgresql-8.2.4 db,
and vacuuming it does not remove the dead rows
basically, the problem is this part of the vacuum-output:
on the db-server, 4 postgres processes are "idle in transaction", but
none is older than 2 days.
If you have something idle in transaction, your vacuums are useless. You
need to fix your app.
maybe i described it the wrong way:
there is only 1 process, that is constantly "idle in transaction".
the remaining 3 were only idle-in-transaction at that point. so if i
would keep checking for idle-in-transaction processes, the list of them
would keep changing.
are you saying, that a process should NEVER be idle-in-transaction? not
even for a short time? (like some seconds?)
also, even if it is wrong, can an 'idle-in-transaction' connection that
was opened today block the vacuuming of rows that were deleted yesterday?
thanks,
gabor
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
