full vacuum - resources - scaling

From: "Mr(dot) Dan" <bitsandbytes88(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: full vacuum - resources - scaling
Date: 2006-05-30 13:44:22
Message-ID: BAY116-F65AAE6BC31AD40D101D58D1920@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Averbukh Stella 2006-05-30 14:00:10 Re: Problem building initdb on sparc10
Previous Message Andy Shellam 2006-05-30 13:35:27 Re: Problem building initdb on sparc10