Re: postgres configuration - Mailing list pgsql-sql

From Tom Lane
Subject Re: postgres configuration
Date
Msg-id 9442.1173821440@sss.pgh.pa.us
Whole thread Raw
In response to postgres configuration  (Sumeet <asumeet@gmail.com>)
List pgsql-sql
Sumeet <asumeet@gmail.com> writes:
> My Vacuum's are running very very slow and expecially when vacuuming indexes
> in large tables of size in 5-10 gigabytes,
> can some one help me determine the parameters for postgres.conf which will
> help me vacuum fast. I'm running postgres on a server with 32 gigs of ram
> and 8 processors.

What postgres version?

8.2 should be considerably faster than prior releases due to Heikki's
fixes to let indexes be scanned in physical order during VACUUM.
        regards, tom lane


pgsql-sql by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: postgres configuration
Next
From: T E Schmitz
Date:
Subject: import CSV file