From: | John Hansen <john(at)geeknet(dot)com(dot)au> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, PostgreSQL WWW <pgsql-www(at)postgresql(dot)org> |
Subject: | Re: search.postgresql.org |
Date: | 2006-03-25 06:45:28 |
Message-ID: | 1143269128.8226.3.camel@livecd.geeknet.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-www |
On Sat, 2006-03-25 at 02:24 -0400, Marc G. Fournier wrote:
> On Sat, 25 Mar 2006, Tom Lane wrote:
>
> > "Joshua D. Drake" <jd(at)commandprompt(dot)com> 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: scrappy(at)hub(dot)org 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
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-03-25 16:58:58 | Re: search.postgresql.org |
Previous Message | Marc G. Fournier | 2006-03-25 06:24:45 | Re: search.postgresql.org |