[BUGS] pg_autovacuum and REINDEX at the same time (?)

2007-02-28 Thread Janar Kartau
Hi. I've been running autovacuum over a month now without any problems, but today one of the critical tables got locked and made a pretty big mess. :) We have a cron script that does REINDEX on this table every 5 minutes. So i wonder if running REINDEX and VACUUM on the same table at the same t

Re: [BUGS] pg_autovacuum and REINDEX at the same time (?)

2007-02-28 Thread Janar Kartau
ULL) WHERE stat_id = 1; COMMIT; Heikki Linnakangas wrote: Janar Kartau wrote: Hi. I've been running autovacuum over a month now without any problems, but today one of the critical tables got locked and made a pretty big mess. :) We have a cron script that does REINDEX on this table every 5