Re: search.postgresql.org - Mailing list pgsql-www

-----Original Message-----
From: "Oleg Bartunov"<oleg@sai.msu.su>
Sent: 25/03/06 20:49:25
To: "Dave Page"<dpage@vale-housing.co.uk>
Cc: "jd@commandprompt.com"<jd@commandprompt.com>, "tgl@sss.pgh.pa.us"<tgl@sss.pgh.pa.us>,
"pgsql-www@postgresql.org"<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
> ranking. At  www.pgsql.ru/db/pgsearch we > have no  manual weight correction and
> 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
favouredover 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
providessite searches aimed at users coming from different perspectives of our site network and we compliment the site
resultswith 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
weight correction and trust authors of web pages.

     Oleg

On Sat, 25 Mar 2006, Dave Page wrote:

>
>
> -----Original Message-----
> From: "Joshua D. Drake"<jd@commandprompt.com>
> Sent: 25/03/06 16:53:27
> To: "Tom Lane"<tgl@sss.pgh.pa.us>
> Cc: "PostgreSQL WWW"<pgsql-www@postgresql.org>
> 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.
Ifyou 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