Re: database bloat,non removovable rows, slow query etc...

Hi, Tom and Matteo,

Tom Lane wrote:
> Matteo Sgalaberni <sgala@sgala.com> 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