Re: postgres configuration
| От | Sumeet |
|---|---|
| Тема | Re: postgres configuration |
| Дата | |
| Msg-id | 7539aebb0703131348m4d139387ob3db342b22170021@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: postgres configuration ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>) |
| Ответы |
Re: postgres configuration
|
| Список | 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
--
Thanks,
Sumeet Ambre
Master of Information Science Candidate,
Indiana University.
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.
В списке pgsql-sql по дате отправления: