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 5970E329D86 for ; Tue, 19 Oct 2004 18:50:39 +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 83161-03 for ; Tue, 19 Oct 2004 17:50:32 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id B68AF32A7BC for ; Tue, 19 Oct 2004 18:50:32 +0100 (BST) Received: from [192.168.1.51] (dsl093-038-087.pdx1.dsl.speakeasy.net [66.93.38.87]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id i9JHoIU12604; Tue, 19 Oct 2004 10:50:18 -0700 Message-ID: <417553D5.1080704@commandprompt.com> Date: Tue, 19 Oct 2004 10:50:13 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Joshua D. Drake" Cc: John Hansen , PostgreSQL www Subject: Re: mailing list offer References: <41746DC7.2060003@commandprompt.com> <1098155495.15522.19.camel@localhost.localdomain> <417488FB.8050908@commandprompt.com> <1098157289.15522.22.camel@localhost.localdomain> <41749370.3000003@commandprompt.com> In-Reply-To: <41749370.3000003@commandprompt.com> Content-Type: multipart/mixed; boundary="------------000009030909070402090203" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.5 tagged_above=0.0 required=5.0 tests=RAZOR2_CF_RANGE_11_50, RAZOR2_CHECK X-Spam-Level: * X-Archive-Number: 200410/195 X-Sequence-Number: 5589 This is a multi-part message in MIME format. --------------000009030909070402090203 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit >> >> > 1.4 seconds for the search, 4.5ms for the pull of the full details.. > > So no -- that may not scale that well. We would have to test it out. There are also other items that can be done, like keeping the tables per month. And allow searching based on the month. If they want to search the entire archives I think it is pretty much a safe bet that it will take time. Of course, we can always use the Google API as well. Sincerely, Joshua D. Drake > > Sincerely, > > Joshua D. Drake > > >>... John >> >> > > > -- > Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC > Postgresql support, programming shared hosting and dedicated hosting. > +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com > PostgreSQL Replicator -- production quality replication for PostgreSQL > -- Command Prompt, Inc., home of PostgreSQL Replication, and plPHP. Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL --------------000009030909070402090203 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard --------------000009030909070402090203--