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

Janar Kartau wrote: I know what causes the "sorry, too many clients already" error, but the number of connections shouldn't grow so big.. so i guess the table (category_tree) got locked. If that happens again, take a look at pg_stat_activity or ps output to see what's going on. Something must

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

I know what causes the "sorry, too many clients already" error, but the number of connections shouldn't grow so big.. so i guess the table (category_tree) got locked. We do REINDEX every 5 minutes because the table gets updated very often and the query's took a lot of time. I think since we use

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

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 minutes. So i wonder if running REINDEX and VACUUM on the same

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

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