The only info i have is Apple xRaid drive array with 14 400GB drives for a total of 5 TB storage I have around 10-15 indexes for each tables. does the number of indexes slow down the vacuum process? indexes are compund indexes on multiple fields.
-Sumeet On 3/13/07, Andrej Ricnik-Bay <[EMAIL PROTECTED]> wrote:
On 3/14/07, Sumeet <[EMAIL PROTECTED]> wrote: > Hi All, Hi, > Sorry if this is the wrong list to ask this question. General woould have been better :) > 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. And the disk subsystem is .... ? > Thanks, > Sumeet. Cheers, Andrej
-- Thanks, Sumeet Ambre Master of Information Science Candidate, Indiana University.