Trying to understand VACUUM VERBOSE

From: "Kevin O'Gorman" <kogorman(at)pacbell(dot)net>
To: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Trying to understand VACUUM VERBOSE
Date: 2000-11-14 07:05:31
Message-ID: 3A10E43B.E7079B49@pacbell.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Quickie questions:

When VACUUM VERBOSE says a table has x pages, what is the size of
the indicated page?

I'm trying to correlate table size with the output of an EXPLAIN
of the SELECT INTO which created it.

I've got 33150 rows which the EXPLAIN said at top level would be
80-byte rows. VACUUM indicates 488 pages. Does this compute?

33150 x 80 = 2,652,000
2652000/488 = 5434

Is it reasonable to assume some overhead and that the pages are
8k? Is this why there's an 8k row-size limit?

++ kevin

--
Kevin O'Gorman (805) 650-6274 mailto:kogorman(at)pacbell(dot)net
Permanent e-mail forwarder: mailto:Kevin.O'Gorman(dot)64(at)Alum(dot)Dartmouth(dot)org
At school: mailto:kogorman(at)cs(dot)ucsb(dot)edu
Web: http://www.cs.ucsb.edu/~kogorman/index.html
Web: http://trixie.kosman.via.ayuda.com/~kevin/index.html

"There is a freedom lying beyond circumstance,
derived from the direct intuition that life can
be grounded upon its absorption in what is
changeless amid change"
-- Alfred North Whitehead

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2000-11-14 07:22:26 Re: 7.0.3 RPMs?
Previous Message Denis Perchine 2000-11-14 05:19:48 Re: Problems during doing reindex on 7.0.3