Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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?


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

Next:From: Averbukh StellaDate: 2006-05-30 14:00:10
Subject: Re: Problem building initdb on sparc10
Previous:From: Andy ShellamDate: 2006-05-30 13:35:27
Subject: Re: Problem building initdb on sparc10

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group