X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id F29C59DC81F for ; Sat, 25 Mar 2006 19:10:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33909-02 for ; Sat, 25 Mar 2006 19:10:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by postgresql.org (Postfix) with ESMTP id 62D5E9DC9EC for ; Sat, 25 Mar 2006 19:10:45 -0400 (AST) Received: from mailgate.vale-housing.co.uk ([194.217.48.34] helo=vale-housing.co.uk) by anchor-post-31.mail.demon.net with esmtp (Exim 4.42) id 1FNHuB-00072S-4B for pgsql-www@postgresql.org; Sat, 25 Mar 2006 23:10:47 +0000 Received: from 192.168.1.106 ([192.168.1.106]) by ratbert.vale-housing.co.uk ([192.168.1.106]) with Microsoft Exchange Server HTTP-DAV ; Sat, 25 Mar 2006 23:10:46 +0000 From: "Dave Page" To: , Cc: , , Subject: Re: search.postgresql.org Message-ID: <00e301c65061$595eff0b$6a01a8c0@valehousing.co.uk> Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Date: Sat, 25 Mar 2006 23:10:37 -0000 MIME-Version: 1.0 Thread-Topic: [pgsql-www] search.postgresql.org thread-index: AcZQTZnzj/6t3Ud2QRWQG1LDWwrAmQAE79qn X-MimeOLE: Produced By Microsoft Exchange V6.5 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=3.536 required=5 tests=[AWL=-2.864, MSGID_DOLLARS=2.163, RATWARE_MS_HASH=1.379, RATWARE_OUTLOOK_NONAME=1.861, URI_NOVOWEL=0.997] X-Spam-Score: 3.536 X-Spam-Level: *** X-Archive-Number: 200603/143 X-Sequence-Number: 9733 -----Original Message----- From: "Oleg Bartunov" Sent: 25/03/06 20:49:25 To: "Dave Page" Cc: "jd@commandprompt.com", = "tgl@sss.pgh.pa.us", = "pgsql-www@postgresql.org" Subject: Re: [pgsql-www] search.postgresql.org > Also, is't possible to group results by sites It does, when appropriate. > ? This could soften effect of incorrect=20 > ranking. At www.pgsql.ru/db/pgsearch we > have no manual weight = correction and=20 > trust authors of web pages. The config being shown is the one used for the main www.postgresql.org = site search, thus results from that site are favoured over external = sites. The archives are ranked even lower because of the potential for = additional noise. www.pgsql.ru is a generic search where lack of weightings and trusting = authors makes sense. search.postgresql.org provides site searches aimed = at users coming from different perspectives of our site network and we = compliment the site results with the external results for added value. Regards, Dave -----Unmodified Original Message----- I don't understand all this thread. Manual intervention brings to = nothing all search engine ranking and usually produce very bad results. Is't possible to use citations ? Also, is't possible to group results by sites ? This could soften effect of incorrect ranking. At www.pgsql.ru/db/pgsearch we have no manual=20 weight correction and trust authors of web pages. Oleg On Sat, 25 Mar 2006, Dave Page wrote: > > > -----Original Message----- > From: "Joshua D. Drake" > Sent: 25/03/06 16:53:27 > To: "Tom Lane" > Cc: "PostgreSQL WWW" > Subject: Re: [pgsql-www] search.postgresql.org > >> It seems to me that archives should be secondly only to >> www.postgresql.org. > > I disagree - the web search is intended to favour factual sites over = the archives which may contain incorrect info. If you want to search the = archives only you still can. > >> Once the new techdocs is live and we get some solid >> content on there, then we can push that up. > > That is on www so will have the same rating. > > /D > > -----Unmodified Original Message----- > >> Um, what other resources are rated higher? If you'll pardon my >> ignorance, what other resources is the search engine considering at = all? > > Below is the weights. As John said earlier they just decide who's = links > show up first. > > It seems to me that archives should be secondly only to > www.postgresql.org. Once the new techdocs is live and we get some = solid > content on there, then we can push that up. > > Thoughts? > > > > SiteWeight http://www.postgresql.org/ 100 > SiteWeight http://advocacy.postgresql.org/ 100 > SiteWeight http://jdbc.postgresql.org/ 100 > SiteWeight http://developer.postgresql.org/ 100 > > # Authoritiative project site > SiteWeight http://gborg.postgresql.org/ 75 > SiteWeight http://pgadmin.postgresql.org/ 75 > SiteWeight http://phppgadmin.sourceforge.net/ 75 > SiteWeight http://pgfoundry.org/ 75 > > # User contributed stuff > SiteWeight http://techdocs.postgresql.org/ 50 > SiteWeight http://archives.postgresql.org/ 50 > > # Outside but reliable > SiteWeight http://www.varlena.com/ 25 > > # And the rest... > SiteWeight http://www.postgresql.cl/ 0 > SiteWeight http://postgresql.ok.cz/ 0 > SiteWeight http://www.postgresql.jp/ 0 > SiteWeight http://www.postgresqlfr.org/ 0 > SiteWeight http://www.linuxshare.ru/ 0 > SiteWeight http://www.postgres.de/ 0 > SiteWeight http://www.pgsqldb.org/ 0 > SiteWeight http://www.postgresql.org.br/ 0 > > > > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match