public inbox for [email protected]  
help / color / mirror / Atom feed
From: John Hansen <[email protected]>
To: Marc G. Fournier <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: Joshua D. Drake <[email protected]>
Cc: PostgreSQL WWW <[email protected]>
Subject: Re: search.postgresql.org
Date: Sat, 25 Mar 2006 17:45:28 +1100
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>

On Sat, 2006-03-25 at 02:24 -0400, Marc G. Fournier wrote:
> On Sat, 25 Mar 2006, Tom Lane wrote:
> 
> > "Joshua D. Drake" <[email protected]> writes:
> >> I was looking at our search configuration and I noted that out of a
> >> weight of 100 we are only weighing archives at 50 and varlena at 25.
> >> That seems a little low as archives is the primary source of pratical
> >> and real world issues and varlena is a great resource.
> >
> > Um, what other resources are rated higher?  If you'll pardon my
> > ignorance, what other resources is the search engine considering at all?
> 
> And maybe a short explanation of what these 'weights' are all about?  Does 
> that just mean that when i search for something, archives results will 
> always preceed varlena's?  And, if so, and we are only doing archives vs 
> varlena, as long as archives is weighted higher then varlena, does it 
> matter what the weights are?  Could be 1 + 2, no?

That's right, the siteweights are just for making sure results from one
site is displayed before another.

A search on search.postgresql.org/archives.search ONLY considers the
archives anyways.

search.postgresql.org/www.search, however, returns results from all the
indexed sites, in order of relevance, with priority according to the
siteweights.

> 
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: [email protected]           Yahoo!: yscrappy              ICQ: 7615664
> 
> ---------------------------(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




view thread (22+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: search.postgresql.org
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox