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 <[EMAIL PROTECTED]> wrote: > Raja Kumar Thatte <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
