X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D8B3C9FA176 for ; Tue, 16 May 2006 12:57:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 94519-01 for ; Tue, 16 May 2006 12:56:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pdc.geeknet.com.au (unknown [210.9.9.216]) by postgresql.org (Postfix) with ESMTP id 84C669F9C18 for ; Tue, 16 May 2006 12:56:55 -0300 (ADT) Received: from barney.geeknet.com.au ([192.168.61.101]) by pdc.geeknet.com.au with Microsoft SMTPSVC(6.0.3790.1830); Wed, 17 May 2006 01:56:54 +1000 Subject: Re: Search thoughts From: John Hansen To: "Joshua D. Drake" Cc: PostgreSQL WWW In-Reply-To: <446280EB.3090307@commandprompt.com> References: <446280EB.3090307@commandprompt.com> Content-Type: text/plain Date: Wed, 17 May 2006 01:56:54 +1000 Message-Id: <1147795014.7258.14.camel@barney.geeknet.com.au> Mime-Version: 1.0 X-Mailer: Evolution 2.4.2.1 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 16 May 2006 15:56:54.0065 (UTC) FILETIME=[5A209210:01C67901] X-TM-AS-Product-Ver: SMEX-7.0.0.1345-3.52.1006-14448.003 X-TM-AS-Result: No--4.800000-8.000000-2 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/78 X-Sequence-Number: 10041 On Wed, 2006-05-10 at 17:10 -0700, Joshua D. Drake wrote: > Hello, > > I have been doing some example searching with our search engine and was > wondering if we can adjust the weights a little differently. For example: > > ALTER TABLE, first link is: > > http://www.postgresql.org/files/documentation/books/aw_pgsql/node203.html > > Which although accurate is way out dated. It seems we should weight a > docs search higher with the current docs having the most weight? > > The same happens with many of the commands such as CREATE INDEX... That's actually not as simple as it sounds. A lot of things is involved in calculating weights for documents from the same site, given the keywords 'ALTER TABLE', the position of the keywords on the page, if they appear in the title, and their position... You will notice, that pages with just the keywords are wighted higher than those where they appear last, etc... The earlier discussion about SiteWeight, does not apply here as they are just for that, weighting entire sites higher, or lower, than others... However, if you first navigate to the documentation for the current version, then do your search, then only pages from that section will be included in the search. ... John > > Joshua D. Drake >