From: | Sumeet <asumeet(at)gmail(dot)com> |
---|---|
To: | "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com> |
Cc: | PostgreSQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: postgres configuration |
Date: | 2007-03-13 20:48:30 |
Message-ID: | 7539aebb0703131348m4d139387ob3db342b22170021@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 <andrej(dot)groups(at)gmail(dot)com> wrote:
>
> On 3/14/07, Sumeet <asumeet(at)gmail(dot)com> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2007-03-13 21:07:44 | Re: postgres configuration |
Previous Message | Greg Toombs | 2007-03-13 20:43:15 | Re: Maintence DB |