Re: postgresql meltdown on PlanetMath.org

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Aaron Krowne <akrowne(at)vt(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql meltdown on PlanetMath.org
Date: 2003-03-16 06:26:32
Message-ID: 18635.1047795992@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Aaron Krowne <akrowne(at)vt(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joe Conway 2003-03-16 06:37:07 Re: postgresql meltdown on PlanetMath.org
Previous Message Sean Chittenden 2003-03-16 06:12:08 Re: postgresql meltdown on PlanetMath.org