Search Postgresql Archives

Re: Why do I have holes in my pages?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Sep 21, 2012 at 11:41 AM, Victor Yegorov <vyegorov@xxxxxxxxx> 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux