| 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: | Whole Thread | Raw Message | 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 |