[Mongrel] Error: Mongrel timed out this thread: too many open files

[Zed A. Shaw]

On Sat, 31 May 2008 21:03:21 -0700
"Emmett Shear" <emmett at justin.tv> wrote:

> - Observe that updates and inserts in the database (postgres) are becoming
> slow. And by slow, I mean 30-40 seconds for a simple insert or update where
> it previously took less than 0.1 seconds. Load on DB server itself remains
> nominal; less than 2 on an 8 core box. No error messages of importance that
> I can see. Inserts and updates from other sources (script/console, psql) are
> fast.

Well, it sounds like your site already has some traffic.  Without
getting into a remote debugging session, have you checked your indexes
to make sure you're adding the right ones to the right columns?

If you were say entering a ton of strings into a DB and then querying
for them with insane LIKE clauses, you'd see this kind of behavior.  As
you added more rows your app would get slower and slower.

-- 
Zed A. Shaw
- Hate: http://savingtheinternetwithhate.com/
- Good: http://www.zedshaw.com/
- Evil: http://yearofevil.com/