[SQL] postgres configuration

2007-03-13 Thread Sumeet
Hi All, Sorry if this is the wrong list to ask this question. 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

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

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

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 been better

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 gigs