Re: table size growing out of control

On Mon, Jul 15, 2002 at 04:20:10PM -0400, Robert Treat wrote:
> I have a table of about 5000 records that I noticed was taking a very
> long time to do simple selects from. I looked at explain analyze and got
> the following:
>
> NOTICE:  Pages 158429: Changed 0, Empty 0; Tup 5458: Vac 1669463, Keep
> 0, UnUsed 13717916.

That's a lot of unused tuples. Perhaps you need to do a VACUUM FULL. See the
docs.

Though I guess it's a little bit late to test now. Old uncommitted
transactions could also be the culprit.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.