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

Поиск
Список
Период
Сортировка
От Raja Kumar Thatte
Тема Re: vaccumdb is giving "ERROR: out of free buffers: time to abort !"
Дата
Msg-id 20030109041029.2530.qmail@web20603.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: vaccumdb is giving "ERROR: out of free buffers: time to abort !"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@sss.pgh.pa.us> wrote:
> 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


=====

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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "King_Henree@yahoo.com"
Дата:
Сообщение: HowTo TOAD and PostgreSQL???
Следующее
От: Peter Schuller
Дата:
Сообщение: Password authentication disabled due to MD5 usage