Re: pgstattuple output? - Mailing list pgsql-general

From John D. Burger
Subject Re: pgstattuple output?
Date
Msg-id 8877cfcaf598ac5691496170fb28b561@mitre.org
Whole thread Raw
In response to Re: pgstattuple output?  (Michael Crozier <crozierm@conducivetech.com>)
Responses Re: pgstattuple output?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Michael Crozier wrote:

> I think I see now, "dead" tuples are the tuples that have yet to be
> reclaimed
> by vacuum, not tuples that are ready to be used. I'm still rather
> confused,
> as this table is only modified via inserts.  No deletes or update
> operations
> are ever performed.  Logically (ie "I don't really know the truth")
> this
> table should have no free tuples or free space except for the
> remainder of
> the last allocated page.

I suspect that if a transaction rolls back, any inserts done in the
interim turn into dead tuples.

- John Burger
   MITRE


pgsql-general by date:

Previous
From: Dick Kniep
Date:
Subject: Re: Connected user in a triggerfunction
Next
From: Patrick Hatcher
Date:
Subject: Re: Trigger question: ROW or STATEMENT?