Sumeet <asumeet(at)gmail(dot)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