| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Robert Treat <rtreat(at)webmd(dot)net> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: table size growing out of control |
| Date: | 2002-07-15 23:45:15 |
| Message-ID: | 20020716094515.A24535@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)svana(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sugita | 2002-07-16 01:22:14 | Re: Mac OS X: system shutdown prevents checkpoint |
| Previous Message | Ralph Graulich | 2002-07-15 23:07:21 | Re: create function: number of parameters |