Postgres Pro
Downloads
Home   >   mailing lists

Re: slow growing table - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: slow growing table
Date
Msg-id 20050606171253.GA1655@uio.no
Whole thread Raw
In response to Re: slow growing table  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Responses Re: slow growing table
List pgsql-performance
Tree view 
On Mon, Jun 06, 2005 at 07:00:37PM +0200, Steinar H. Gunderson wrote:
> You might have a problem with index bloat. Could you try REINDEXing the
> indexes on the table and see if that makes a difference?

On second thought... Does a VACUUM FULL help? If so, you might want to
increase your FSM settings.

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

pgsql-performance by date:

Previous
From: "Steinar H. Gunderson"
Date:
Subject: Re: slow growing table
Next
From: Tobias Brox
Date:
Subject: Re: Need help to decide Mysql vs Postgres