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