Re: max fsm pages question

From: Vivek Khera <vivek(at)khera(dot)org>
To: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: max fsm pages question
Date: 2008-07-09 15:59:31
Message-ID: 362E0126-A054-4C70-B702-C467A1778D2E@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Jul 8, 2008, at 3:24 PM, Bill Moran wrote:

> If you don't handle this, that table will continue to grow in size on
> the disk, taking up space unnecessarily and probably negatively
> impacting performance.

s/probably/definitely/

Also, if it was #3 on Bill's list, one thing to do is look for index
bloat. Reindex followed by vacuum might help as well.

As for running VACUUM FULL, I find it sometimes faster to just do a
dump + reload. A FULL vacuum is really, really, really, extremely,
slow.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ow Mun Heng 2008-07-10 07:53:00 Altering a column type - Most efficient way
Previous Message achill@matrix 2008-07-09 12:51:30 Re: syslog performance when logging big statements