| From: | Raja Kumar Thatte <trajakumar(at)yahoo(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: vaccumdb is giving "ERROR: out of free buffers: time to abort !" |
| Date: | 2003-01-09 04:10:29 |
| Message-ID: | 20030109041029.2530.qmail@web20603.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hai Tom Lane
Thanks a lot.
I think I have to increase shared_buffers.
I will try.
I think this will solve my problem
c u
raja
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
=====
Raja Kumar Thatte, Research Engineer,TMN-Group,C-DOT, 71/1, Sneha Complex, Miller Road, Bangalore-560052.
Phone:080-2389351/354, 2263399Ext362
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jack Flak | 2003-01-09 08:25:01 | Re: restore/dup OIDs HELP! |
| Previous Message | somphong s. | 2003-01-09 03:40:37 | auto stop postmaster on cygwin |