X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 8F6355280B
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sun,  5 Jun 2005 23:04:39 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 35903-10
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon,  6 Jun 2005 02:04:35 +0000 (GMT)
Received: from mailbox.samurai.com (mailbox.samurai.com [205.207.28.82])
	by svr1.postgresql.org (Postfix) with ESMTP id 2D9985282A
	for <pgsql-performance@postgresql.org>;
	Sun,  5 Jun 2005 23:04:34 -0300 (ADT)
Received: from localhost (mailbox.samurai.com [205.207.28.82])
	by mailbox.samurai.com (Postfix) with ESMTP id C9F1D18CC05;
	Sun,  5 Jun 2005 22:04:38 -0400 (EDT)
Received: from mailbox.samurai.com ([205.207.28.82])
	by localhost (mailbox.samurai.com [205.207.28.82]) (amavisd-new,
	port 10024)
	with LMTP id 25459-01-5; Sun,  5 Jun 2005 22:04:36 -0400 (EDT)
Received: from [61.88.101.19] (unknown [61.88.101.19])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mailbox.samurai.com (Postfix) with ESMTP id 3595C18D055;
	Sun,  5 Jun 2005 22:04:35 -0400 (EDT)
Message-ID: <42A3AF2D.4000802@samurai.com>
Date: Mon, 06 Jun 2005 12:04:29 +1000
From: Neil Conway <neilc@samurai.com>
User-Agent: Debian Thunderbird 1.0.2 (X11/20050331)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Mark Stosberg <mark@summersault.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Most effective tuning choices for busy website?
References: <slrnd9s2n5.ca0.mark@simba.summersault.com>
In-Reply-To: <slrnd9s2n5.ca0.mark@simba.summersault.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at mailbox.samurai.com
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.019 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200506/103
X-Sequence-Number: 12740

Mark Stosberg wrote:
> I've used PQA to analyze my queries and happy overall with how they are
> running. About 55% of the query time is going to variations of the pet
> searching query, which seems like where it should be going. The query is
> frequent and complex. It has already been combed over for appropriate
> indexing.

It might be worth posting the EXPLAIN ANALYZE and relevant schema 
definitions for this query, in case there is additional room for 
optimization.

>    Our hardware: Dual 3 Ghz processors 3 GB RAM, running on FreeBSD.

Disk?

You are presumably using Xeon processors, right? If so, check the list 
archives for information on the infamous "context switching storm" that 
causes performance problems for some people using SMP Xeons.

-Neil