Re: Trying to understand VACUUM VERBOSE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: kogorman(at)pacbell(dot)net
Cc: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trying to understand VACUUM VERBOSE
Date: 2000-11-14 07:28:31
Message-ID: 1863.974186911@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Kevin O'Gorman" <kogorman(at)pacbell(dot)net> writes:
> I've got 33150 rows which the EXPLAIN said at top level would be
> 80-byte rows. VACUUM indicates 488 pages. Does this compute?

Keep in mind that EXPLAIN's estimates of average row width are almost,
but not quite, entirely bogus. I'm actually quite surprised that your
arithmetic produced a number as close to 8K as it did.

We need to start keeping stats about the average width of variable-
length columns; until we do, EXPLAIN can't possibly produce row width
estimates that are at all accurate.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marcos 2000-11-14 09:05:45 moving throw the resultset
Previous Message hubert depesz lubaczewski 2000-11-14 07:22:26 Re: 7.0.3 RPMs?