Hai friends,
I am using postgres-7.2
System is in production state.
It has roughly 250 tables with 100 indexes.
roughly 20 tables will have 1,00,000 records each.
Lot of updations are going on.
Lot of deletions are also going on.
So have to do vacuumdb.
So Whenever i do
vaccumdb verbose analyze xyzdb
After 7 to 8 hours I am getting
ERROR: out of free buffers: time to abort !
vacuumdb: vacuum xyzdb failed
What to do?
Thanks in advance.
c u
raja
=====
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