Re: slow growing table

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow growing table
Date: 2005-06-06 17:00:37
Message-ID: 20050606170037.GA1177@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Jun 06, 2005 at 09:48:26AM -0700, Jone C wrote:
> When the table is new it's very fast, towards the end of the month
> it's taking almost 10 times longer, yet I'm deleting and COPYing in
> the same amount of data. Other operations on this table slow down,
> too, that were fast before using the same criteria.

You might have a problem with index bloat. Could you try REINDEXing the
indexes on the table and see if that makes a difference?

/* Steinar */
--
Homepage: http://www.sesse.net/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Browne 2005-06-06 17:01:23 Re: Need help to decide Mysql vs Postgres
Previous Message Jone C 2005-06-06 16:48:26 slow growing table