Re: vaccumdb is giving "ERROR: out of free buffers: time to abort !"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Raja Kumar Thatte <trajakumar(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: vaccumdb is giving "ERROR: out of free buffers: time to abort !"
Date: 2003-01-08 16:58:16
Message-ID: 4489.1042045096@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Raja Kumar Thatte <trajakumar(at)yahoo(dot)com> writes:
> After 7 to 8 hours I am getting
> ERROR: out of free buffers: time to abort !
> vacuumdb: vacuum xyzdb failed

What do you have shared_buffers set to?

If it's still the default (64), that's way too small for a production
installation. Try a few thousand instead.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-01-08 17:13:26 Re: Increase max_connections
Previous Message David Gilbert 2003-01-08 16:18:43 repair table? database? how ? neccessary?