Обсуждение: vaccumdb is giving "ERROR: out of free buffers: time to abort !"
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
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
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