On Wed, Dec 1, 2010 at 11:23 AM, Jolles, Peter M (GE Energy) <peter.jolles@xxxxxx> wrote: > EST WARNING: database "fps_data" must be vacuumed within 11000000 transactions > > I know now that I'm going to have to slow down the transaction rate in order to let the autovacuum keep up, but at this point I am just trying to salvage the data present in the database. > Just how big is the table and how many transactions per second do you push through it? Perhaps your I/O bandwidth is just insufficient for your load level. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general