Horton

Re: postgresql meltdown on PlanetMath.org

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Aaron Krowne <akrowne@vt.edu>
Cc: pgsql-performance@postgresql.org
Date: 2003-03-16T06:26:32Z
Lists: 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