2008/3/13, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>:> 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 yesthe db is vacuumed every three hours after each bulk insert/delete. Regards, Clodoaldo Pinto Neto -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
