Postgres Pro
Downloads
Home   >   mailing lists

Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows - Mailing list pgsql-performance

From Tom Lane
Subject Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows
Date
Msg-id 26618.1282226169@sss.pgh.pa.us
Whole thread Raw
In response to Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows  (Alexandre de Arruda Paes <adaldeia@gmail.com>)
List pgsql-performance
Tree view 
Alexandre de Arruda Paes <adaldeia@gmail.com> writes:
> Below, the pg_prepared_xacts result.

OK, so you don't have any prepared transactions, but you're still not
showing us the full content of pg_stat_activity.

Just out of curiosity, how many rows does "select count(*) from tp93t"
think there are?

            regards, tom lane

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows
Next
From: Tom Lane
Date:
Subject: Re: yet another q