Re: table size growing out of control - Mailing list pgsql-general

From scott.marlowe
Subject Re: table size growing out of control
Date
Msg-id Pine.LNX.4.44.0207151447530.29212-100000@css120.ihs.com
Whole thread Raw
In response to table size growing out of control  (Robert Treat <rtreat@webmd.net>)
List pgsql-general
On 15 Jul 2002, 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

Did you check the actual physical file sizes of your indexes and tables
on the disk?  One might have been growing but not shoing it in the tables
you looked at.

Did you have stalled transactions holding a lock on anything?

That's all I can think of.




pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Question: merit / feasibility of compressing frontend
Next
From: Alex Rice
Date:
Subject: Re: MySQL vs. PostgreSQL