pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedClarification on two bits on VACUUM FULL VERBOSE output
4+ messages / 2 participants
[nested] [flat]
* Clarification on two bits on VACUUM FULL VERBOSE output
@ 2004-11-12 18:42 Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 4+ messages in thread
From: Josh Berkus @ 2004-11-12 18:42 UTC (permalink / raw)
To: pgsql-performance
Folks,
Wanted to get clarification on two bits of output from 7.4's VACUUM FULL
VERBOSE:
"Total free space (including removable row versions) is 2932036 bytes."
If the table referenced has no dead row versions, does this indicate open
space on partially full pages?
"There were 33076 unused item pointers."
Is this a count of dead index pointers, or something else?
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Clarification on two bits on VACUUM FULL VERBOSE output
@ 2004-11-12 19:20 Tom Lane <tgl@sss.pgh.pa.us>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2004-11-12 19:20 UTC (permalink / raw)
To: josh@agliodbs.com; +Cc: pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> Wanted to get clarification on two bits of output from 7.4's VACUUM FULL
> VERBOSE:
> "Total free space (including removable row versions) is 2932036 bytes."
> If the table referenced has no dead row versions, does this indicate open
> space on partially full pages?
Yes.
> "There were 33076 unused item pointers."
> Is this a count of dead index pointers, or something else?
No, it's currently-unused item pointers (a/k/a line pointers) on heap
pages. See http://developer.postgresql.org/docs/postgres/page.html
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Clarification on two bits on VACUUM FULL VERBOSE output
@ 2004-11-12 21:11 Josh Berkus <josh@agliodbs.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Josh Berkus @ 2004-11-12 21:11 UTC (permalink / raw)
To: pgsql-performance; +Cc: Tom Lane <tgl@sss.pgh.pa.us>
Tom,
> > "There were 33076 unused item pointers."
> > Is this a count of dead index pointers, or something else?
>
> No, it's currently-unused item pointers (a/k/a line pointers) on heap
> pages. See http://developer.postgresql.org/docs/postgres/page.html
So this would be a count of pointers whose items had already been moved?
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Clarification on two bits on VACUUM FULL VERBOSE output
@ 2004-11-12 21:19 Tom Lane <tgl@sss.pgh.pa.us>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2004-11-12 21:19 UTC (permalink / raw)
To: josh@agliodbs.com; +Cc: pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
>>> "There were 33076 unused item pointers."
>>> Is this a count of dead index pointers, or something else?
>>
>> No, it's currently-unused item pointers (a/k/a line pointers) on heap
>> pages. See http://developer.postgresql.org/docs/postgres/page.html
> So this would be a count of pointers whose items had already been moved?
Either deleted, or moved to another page during VACUUM FULL compaction.
Such a pointer can be recycled to point to a new item, if there's room
to put another item on its page ... but if not, the pointer is
wasted space. I don't believe we ever try to physically eliminate
unused item pointers.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-11-12 21:19 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-12 18:42 Clarification on two bits on VACUUM FULL VERBOSE output Josh Berkus <josh@agliodbs.com>
2004-11-12 19:20 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-11-12 21:11 ` Josh Berkus <josh@agliodbs.com>
2004-11-12 21:19 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox