Re: Why do I have holes in my pages? - Mailing list pgsql-general

From Jeff Janes
Subject Re: Why do I have holes in my pages?
Date
Msg-id CAMkU=1wcMpTUKCgr7LMwoFR1gdE_taPG9uZSaSk30_ddtzQ_Ng@mail.gmail.com
Whole thread Raw
In response to Re: Why do I have holes in my pages?  (Victor Yegorov <vyegorov@gmail.com>)
Responses Re: Why do I have holes in my pages?  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
List pgsql-general
On Fri, Sep 21, 2012 at 11:41 AM, Victor Yegorov <vyegorov@gmail.com> wrote:
>
> It seems that this also matches your explanation, correct me if I'm wrong.

I think that the explanations do generally match.  But, just because
you observe that the ctid space has not been reused (like the OP did),
does not mean that the tuple-space has not been reused.  My
understanding is that tuple space is easier to reuse than ctid space
is.  Sometimes that distinction is important, and sometimes it is not.
 In general, doing "select ctid..." is a poor way of figuring out
where the space in your database is going.

Cheers,

Jeff


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Expression to construct a anonymous record with named columns?
Next
From: Aleksey Tsalolikhin
Date:
Subject: Re: Why do I have holes in my pages?