Re: pgstattuple output?

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: Michael Crozier <crozierm(at)conducivetech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pgstattuple output?
Date: 2006-01-26 15:13:52
Message-ID: 8877cfcaf598ac5691496170fb28b561@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J 2006-01-26 15:43:12 Query optimization with X Y JOIN
Previous Message Dick Kniep 2006-01-26 15:06:57 Re: Connected user in a triggerfunction