Postgres Pro
Downloads
Home   >   mailing lists

Re: vaccumdb is giving "ERROR: out of free buffers: time to abort !" - Mailing list pgsql-admin

From Tom Lane
Subject Re: vaccumdb is giving "ERROR: out of free buffers: time to abort !"
Date
Msg-id 4489.1042045096@sss.pgh.pa.us
Whole thread Raw
In response to vaccumdb is giving "ERROR: out of free buffers: time to abort !"  (Raja Kumar Thatte <trajakumar@yahoo.com>)
Responses Re: vaccumdb is giving "ERROR: out of free buffers: time to abort !"  (Raja Kumar Thatte <trajakumar@yahoo.com>)
List pgsql-admin
Tree view 
Raja Kumar Thatte <trajakumar@yahoo.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

pgsql-admin by date:

Previous
From: David Gilbert
Date:
Subject: repair table? database? how ? neccessary?
Next
From: Tom Lane
Date:
Subject: Re: Increase max_connections