Re: Storage/Performance and splitting a table

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Storage/Performance and splitting a table
Date: 2005-11-19 19:03:04
Message-ID: 20051119190304.GJ7330@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Nov 19, 2005 at 09:54:23AM -0800, Craig A. James wrote:
>First, I occasionally rebuild the keywords, after which the VACUUM FULL
>ANALYZE takes a LONG time - like 24 hours.

You know you just need vacuum, not vacuum full, right?

Mike Stone

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig A. James 2005-11-19 20:42:50 Re: Perl DBD and an alarming problem
Previous Message Craig A. James 2005-11-19 17:54:23 Storage/Performance and splitting a table