Trying to understand VACUUM VERBOSE
От | Kevin O'Gorman |
---|---|
Тема | Trying to understand VACUUM VERBOSE |
Дата | |
Msg-id | 3A10E43B.E7079B49@pacbell.net обсуждение исходный текст |
Ответы |
Re: Trying to understand VACUUM VERBOSE
|
Список | 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@pacbell.net Permanent e-mail forwarder: mailto:Kevin.O'Gorman.64@Alum.Dartmouth.org At school: mailto:kogorman@cs.ucsb.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
В списке pgsql-general по дате отправления: