Re: vacuum, dead rows, usual solutions didn't help

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