2008/3/13, Alvaro Herrera <[EMAIL PROTECTED]>: > Clodoaldo escribió: > > > > Now what is happening is that reindex does not finish even with a > > small 6,500 rows table and after a reboot. In top there is no CPU or > > memory usage by postmaster and vmstat shows no disk activity. > > > Hmm, are you vacuuming the system catalogs appropriately?
If a simple vacuum in instead of a vacuum full is appropriate then yes the db is vacuumed every three hours after each bulk insert/delete. Regards, Clodoaldo Pinto Neto -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
