Hi, Tom and Matteo,

Tom Lane wrote:
> Matteo Sgalaberni <[EMAIL PROTECTED]> writes:
>> 22 daemons that have a persistent connection to this database(all
>> connection are in "idle"(no transaction opened).
> 
> You may think that, but you are wrong.
> 
>> INFO:  "cliente": found 0 removable, 29931 nonremovable row versions in 559 
>> pages
>> DETAIL:  29398 dead row versions cannot be removed yet.
> 
> The only way the above can happen is if there are some fairly old open
> transactions.  Looking in pg_stat_activity might help you identify the
> culprit(s).

Another possibility might be an outstanding two-phase-commit transaction.

HTH,
Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to