pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Clarification 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