Re: [SQL] postgres configuration

2007-03-13 Thread Tom Lane
Sumeet <[EMAIL PROTECTED]> writes: > 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

Re: [SQL] postgres configuration

2007-03-13 Thread Scott Marlowe
On Tue, 2007-03-13 at 15:48, Sumeet wrote: > 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

Re: [SQL] postgres configuration

2007-03-13 Thread Sumeet
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 P

Re: [SQL] postgres configuration

2007-03-13 Thread Andrej Ricnik-Bay
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 det