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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
