X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BE40CD1CC84; Mon, 19 Jan 2004 19:43:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18976-10; Mon, 19 Jan 2004 15:42:32 -0400 (AST) Received: from hosting.commandprompt.com (215.commandprompt.com [207.173.200.215]) by svr1.postgresql.org (Postfix) with ESMTP id E684DD1B4D3; Mon, 19 Jan 2004 15:42:29 -0400 (AST) Received: from commandprompt.com (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 i0JJgKg24995; Mon, 19 Jan 2004 11:42:21 -0800 Message-ID: <400C3317.6010504@commandprompt.com> Date: Mon, 19 Jan 2004 11:42:15 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jussi Mikkola Cc: "scott.marlowe" , "'PostgreSQL General'" , Postgresql Advocacy Subject: Re: New PostgreSQL search resource References: <400C29E4.90908@commandprompt.com> <400C3127.8090107@bonware.com> In-Reply-To: <400C3127.8090107@bonware.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/270 X-Sequence-Number: 3452 Jussi Mikkola wrote: > I think most of the people use http://www.postgresql.org/search.cgi Yep... Supposedly it is being worked on to make it faster. J > > Default settings, search for select distinct returns in about 10 > minutes, with "You haven't typed any word(s) to search for." > > Same query with match full phrase... (I did not wait long enough. But > several minutes in any case. Don't know about the result.) > > Same query with match full phrase and 7.4 documentation. 2 results in > 5 seconds. Results are select into and pg_select. > > Could we do something to this search? (Change the defaults, divide it > to smaller parts, use different search engine...) > > Rgs, > > Jussi > > > > > > Joshua D. Drake wrote: > >> >>> Not really. with htdig, I can do "select distinct" on the 7.3 docs >>> and I get exactly 7 responses back, and they all have select >>> followed immediately by distinct, with only space, CR / LF etc in >>> between. >>> >>> >>> >> Well, if you search for select distinct... OpenFTS automatically >> searches >> for select & distinct. My search returned: >> >> 5 results with the first one being this: >> >> http://www.commandprompt.com/community//search.lxp?lxpwrap=734/queries-select-lists.html >> >> >> Which seems fairly accurate ;). Perhaps a better description of what >> the problem actually is or >> the behavior you are expecting? >> >> SIncerely, >> >> Joshua D. Drake >> >> >> >>> And the & symbol josh recommended shows as being ignored, so that >>> didn't work either. >>> >>> Word combos like "bulk loads" or "run-time configuration" are quite >>> handy filters. >>> >>> >> >> > > > > -- 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 Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL