X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id AAB3032A527;
	Fri,  1 Oct 2004 04:14:18 +0100 (BST)
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 29968-07; Fri,  1 Oct 2004 03:14:16 +0000 (GMT)
Received: from rodrick.geeknet.com.au (ns1.geeknet.com.au [220.244.63.182])
	by svr1.postgresql.org (Postfix) with ESMTP id 15A2432A508;
	Fri,  1 Oct 2004 04:14:13 +0100 (BST)
Received: from john.oztralis.com.au ([192.168.63.107]) by
	rodrick.geeknet.com.au with Microsoft SMTPSVC(6.0.3790.0);
	Fri, 1 Oct 2004 13:14:11 +1000
Subject: Re: Archives / search
From: John Hansen <john@geeknet.com.au>
To: Justin Clift <justin@postgresql.org>
Cc: "Marc G. Fournier" <scrappy@postgresql.org>,
	pgsql-www@postgresql.org
In-Reply-To: <415CC2AA.9030306@postgresql.org>
References: <5066E5A966339E42AA04BA10BA706AE561C5@rodrick.geeknet.com.au>
	<20040930200916.E23868@ganymede.hub.org>
	<1096587458.18851.8.camel@localhost.localdomain>
	<20040930212431.V23868@ganymede.hub.org>
	<1096597533.21537.9.camel@localhost.localdomain>
	<415CC2AA.9030306@postgresql.org>
Content-Type: text/plain
Organization: GeekNET
Message-Id: <1096600400.21537.15.camel@localhost.localdomain>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6 
Date: Fri, 01 Oct 2004 13:13:21 +1000
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 01 Oct 2004 03:14:12.0147 (UTC)
	FILETIME=[B95A0830:01C4A764]
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200410/8
X-Sequence-Number: 5402


> Any chance that it's just badly optimised tables?  i.e. missing indexes 
> and such?

I'll have a look, but I don't think so....


... John