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
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 |