Sumeet <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq