From: Sumeet <asumeet@gmail.com>
To: Andrej Ricnik-Bay <andrej.groups@gmail.com>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: postgres configuration
Date: Tue, 13 Mar 2007 16:48:30 -0400
Message-ID: <7539aebb0703131348m4d139387ob3db342b22170021@mail.gmail.com> (raw)
In-Reply-To: <b35603930703131106g2606bdc3j94e44a0844923227@mail.gmail.com>
References: <7539aebb0703131014y2512853fw9ced1bd3bb5f5e77@mail.gmail.com>
<b35603930703131106g2606bdc3j94e44a0844923227@mail.gmail.com>
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.groups@gmail.com> wrote:
>
> On 3/14/07, Sumeet <asumeet@gmail.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: asumeet@gmail.com, andrej.groups@gmail.com
Subject: Re: postgres configuration
In-Reply-To: <7539aebb0703131348m4d139387ob3db342b22170021@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox