X-Original-To: pgsql-performance@postgresql.org Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 7C19C474E42 for ; Sun, 16 Mar 2003 01:26:33 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.8/8.12.8) with ESMTP id h2G6QXub018636; Sun, 16 Mar 2003 01:26:33 -0500 (EST) To: Aaron Krowne Cc: pgsql-performance@postgresql.org Subject: Re: postgresql meltdown on PlanetMath.org In-reply-to: <20030316060125.GD19570@vt.edu> References: <20030316060125.GD19570@vt.edu> Comments: In-reply-to Aaron Krowne message dated "Sun, 16 Mar 2003 01:01:25 -0500" Date: Sun, 16 Mar 2003 01:26:32 -0500 Message-ID: <18635.1047795992@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200303/101 X-Sequence-Number: 1399 Aaron Krowne 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