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

[Heikki Linnakangas <heikki(at)enterprisedb(dot)com>]

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 be using the connections, a locked 
table alone won't give you that error message.

> 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 autovacuum now, 
> it's not needed anymore.

Yeah, a vacuum is normally enough to keep the indexes in good shape. I'd 
 suggest removing the REINDEX call and either letting autovacuum handle 
it, or adding an explicit VACUUM call after the commit.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com