Re: postgresql meltdown on PlanetMath.org - Mailing list pgsql-performance

From Tom Lane
Subject Re: postgresql meltdown on PlanetMath.org
Date
Msg-id 18635.1047795992@sss.pgh.pa.us
Whole thread Raw
In response to postgresql meltdown on PlanetMath.org  (Aaron Krowne <akrowne@vt.edu>)
List pgsql-performance
Aaron Krowne <akrowne@vt.edu> writes:
> As the topic suggests, I am having fairly critical troubles with
> postgresql on PlanetMath.org (a site which I run).

Um ... not meaning to insult your intelligence, but how often do you
vacuum?  Also, exactly what Postgres version are you running?  Can
you show us EXPLAIN ANALYZE results for some of the slow queries?

            regards, tom lane

pgsql-performance by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: postgresql meltdown on PlanetMath.org
Next
From: Joe Conway
Date:
Subject: Re: postgresql meltdown on PlanetMath.org