On Mon, Jun 7, 2010 at 8:30 PM, Takahiro Itagaki
wrote:
>
> Dave Cramer wrote:
>
>> I noted on line 169 that max_avail is still an int ? Where else would
>> it be having problems ?
>
> It should not a problem because the local variable only stores byte
> size in a page. It will be at most only BL
Dave Cramer wrote:
> I noted on line 169 that max_avail is still an int ? Where else would
> it be having problems ?
It should not a problem because the local variable only stores byte
size in a page. It will be at most only BLCKSZ (=8192).
I wonder why you had "ERROR: value ... is out of rang
I noted on line 169 that max_avail is still an int ? Where else would
it be having problems ?
Dave
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
> Oh. Hmm, if that's what you want then I do not think an indexscan is
> the way to go about it. The indexscan will only visit leaf pages
> (and not, for example, internal nodes of a btree). Also the
> free-space-counting code you're using seems pretty unworkable since the
> indexscan is unlike
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> Sure. In my understanding, unlike tables "free/reusable space" is
> actually not reused in index. pgstatindex would be usefull to judge if
> REINDEX is needed by showing the growth of physical length and
> "free/reusable space".
Oh. Hmm, if that's what
> Um ... what's the point? Isn't this always the same as the percentage
> for the underlying table?
Sure. In my understanding, unlike tables "free/reusable space" is
actually not reused in index. pgstatindex would be usefull to judge if
REINDEX is needed by showing the growth of physical length
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> Here is a new contrib function called "pgstatindex", similar to
> pgstattuple but different in that it returns the percentage of the
> dead tuples of an index. I am posting this for review purpose.
Um ... what's the point? Isn't this always the same as
Here is a new contrib function called "pgstatindex", similar to
pgstattuple but different in that it returns the percentage of the
dead tuples of an index. I am posting this for review purpose.
Installation of pgstatindex is pretty easy:
unpack the tar package in contrib directory.
cd into pgsta
