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 800CF32A50A; Fri, 1 Oct 2004 03:36:44 +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 20699-03; Fri, 1 Oct 2004 02:36:38 +0000 (GMT) Received: from dic-mail.telstra.net (crash.telstra.net [203.50.0.185]) by svr1.postgresql.org (Postfix) with ESMTP id 32D1C32A509; Fri, 1 Oct 2004 03:36:38 +0100 (BST) Received: from [203.50.0.197] (rsdhcp5.telstra.net [203.50.0.197]) by dic-mail.telstra.net (8.12.11/8.12.11) with ESMTP id i912aS5T024836; Fri, 1 Oct 2004 12:36:33 +1000 Message-ID: <415CC2AA.9030306@postgresql.org> Date: Fri, 01 Oct 2004 12:36:26 +1000 From: Justin Clift User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: John Hansen Cc: "Marc G. Fournier" , pgsql-www@postgresql.org Subject: Re: Archives / search 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> In-Reply-To: <1096597533.21537.9.camel@localhost.localdomain> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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/7 X-Sequence-Number: 5401 John Hansen wrote: >>>>'k, first look and I know I wouldn't use it, so let's do it as an 'option' >>>>vs a 'replacement' ... thing is, we have realtime right now also, and that >>>>is the news groups, and, to be honest, I much prefer using a news reader >>>>to read a group then a forum ... > > > Second look, after importing just 1500 messages from -admin : search > sucks big time, even browsing takes forever. No, I don't think this will > work. I think i'll look for something else... :) Any chance that it's just badly optimised tables? i.e. missing indexes and such? Regards and best wishes, Justin Clift > ... John > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)