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 92FF15E473F; Sat, 4 Sep 2004 20:15:02 +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 95595-07; Sat, 4 Sep 2004 19:14:49 +0000 (GMT) Received: from rodrick.geeknet.com.au (ns1.geeknet.com.au [220.244.63.182]) by svr1.postgresql.org (Postfix) with ESMTP id 3F8ED5E4739; Sat, 4 Sep 2004 20:14:43 +0100 (BST) Subject: Re: Suggestion for improving Archives MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Content-class: urn:content-classes:message Date: Sun, 5 Sep 2004 05:14:54 +1000 X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Message-ID: <5066E5A966339E42AA04BA10BA706AE5618D@rodrick.geeknet.com.au> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [pgsql-www] Suggestion for improving Archives Thread-Index: AcSSstUW31ERyVgoQzChYiMiTRJpjgAACOcw From: "John Hansen" To: "Marc G. Fournier" , "Josh Berkus" Cc: "Oleg Bartunov" , "PostgreSQL WWW Mailing List" 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: 200409/35 X-Sequence-Number: 5105 > the followign was searching "nested transaction support": >=20 > "Documents 1-10 of total 383 found. Searching in 390035=20 > documents took=20 > 4.714 seconds." >=20 > Not what I'd consider "slow" ... granted, that last one on=20 > Google too .2 seconds, but when we can build a server farm=20 > like them, then I'll be worried about 4secs vs .2 :) >=20 And the archives is currently being crawled, and there was a vacuum running (heavy db load). nested transaction support: Documents 1-10 of total 383 found. Searching in 390035 documents took 0.104 seconds. ... John