Postgres Pro
Downloads
Home   >   mailing lists

Re: Storage/Performance and splitting a table - Mailing list pgsql-performance

From Michael Stone
Subject Re: Storage/Performance and splitting a table
Date
Msg-id 20051119190304.GJ7330@mathom.us
Whole thread Raw
In response to Storage/Performance and splitting a table  ("Craig A. James" <cjames@modgraph-usa.com>)
Responses Hyperthreading slows processes?  ("Craig A. James" <cjames@modgraph-usa.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Craig A. James"
Date:
Subject: Storage/Performance and splitting a table
Next
From: "Craig A. James"
Date:
Subject: Re: Perl DBD and an alarming problem