Re: postgres configuration

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.

In response to

Responses

Browse pgsql-sql by date

  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