Re: table size growing out of control

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
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 20:49:29
Message-ID: Pine.LNX.4.44.0207151447530.29212-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Rice 2002-07-15 21:03:30 Re: MySQL vs. PostgreSQL
Previous Message Joshua D. Drake 2002-07-15 20:44:20 Re: Question: merit / feasibility of compressing frontend