Postgres Pro
Downloads
Home   >   mailing lists

full vacuum - resources - scaling - Mailing list pgsql-admin

From Mr. Dan
Subject full vacuum - resources - scaling
Date
Msg-id BAY116-F65AAE6BC31AD40D101D58D1920@phx.gbl
Whole thread Raw
Responses Re: full vacuum - resources - scaling  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: full vacuum - resources - scaling  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-admin
Tree view 
Hi,

I have noticed that my full vacuum and re-index script is taking a day and a
half instead of 1/2 day.
Recently, the size of my database cluster has doubled to 130 GB.   Would
anyone recommend increasing one or more of these to help get my full vacuums
to run a little faster?

Thanks,
~DjK



work memory       49152 KB
shared buffers      65536 (8 KB)
maxfsmpages       480001 (6 bytes each)
maxfsmrelations    30000 (70 bytes each)

effective cache     983040 (8 KB each)

pgsql-admin by date:

Previous
From: "Andy Shellam"
Date:
Subject: Re: Problem building initdb on sparc10
Next
From: "Averbukh Stella"
Date:
Subject: Re: Problem building initdb on sparc10