public inbox for [email protected]
help / color / mirror / Atom feedsearch.postgresql.org
22+ messages / 11 participants
[nested] [flat]
* search.postgresql.org
@ 2004-09-05 09:08 John Hansen <[email protected]>
2004-09-05 13:27 ` Re: search.postgresql.org Oleg Bartunov <[email protected]>
0 siblings, 1 reply; 22+ messages in thread
From: John Hansen @ 2004-09-05 09:08 UTC (permalink / raw)
To: John Hansen <[email protected]>; Marc G. Fournier <[email protected]>; Dave Page <[email protected]>; +Cc: pgsql-www
Guys,
By popular demand, I've just added search by date to
search.postgresql.org
(both for www and archives)
... John
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2004-09-05 09:08 search.postgresql.org John Hansen <[email protected]>
@ 2004-09-05 13:27 ` Oleg Bartunov <[email protected]>
0 siblings, 0 replies; 22+ messages in thread
From: Oleg Bartunov @ 2004-09-05 13:27 UTC (permalink / raw)
To: John Hansen <[email protected]>; +Cc: Marc G. Fournier <[email protected]>; Dave Page <[email protected]>; pgsql-www
On Sun, 5 Sep 2004, John Hansen wrote:
> Guys,
>
> By popular demand, I've just added search by date to
> search.postgresql.org
> (both for www and archives)
order by date, probably, should be default for archives.
>
>
> ... John
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: [email protected], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
@ 2004-09-06 07:05 Dave Page <[email protected]>
0 siblings, 0 replies; 22+ messages in thread
From: Dave Page @ 2004-09-06 07:05 UTC (permalink / raw)
To: John Hansen <[email protected]>; Marc G. Fournier <[email protected]>; +Cc: pgsql-www
> -----Original Message-----
> From: John Hansen [mailto:[email protected]]
> Sent: 05 September 2004 10:09
> To: John Hansen; Marc G. Fournier; Dave Page
> Cc: [email protected]
> Subject: search.postgresql.org
>
> Guys,
>
> By popular demand, I've just added search by date to
> search.postgresql.org (both for www and archives)
:-)
/D
^ permalink raw reply [nested|flat] 22+ messages in thread
* search.postgresql.org
@ 2004-09-17 06:25 John Hansen <[email protected]>
2004-09-17 06:29 ` Re: search.postgresql.org Michael Glaesemann <[email protected]>
0 siblings, 1 reply; 22+ messages in thread
From: John Hansen @ 2004-09-17 06:25 UTC (permalink / raw)
To: pgsql-www
Guys,
I'm going on a 10 day holiday in perth, and will be back on Monday 27/9.
Until then have fun,
... John
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2004-09-17 06:25 search.postgresql.org John Hansen <[email protected]>
@ 2004-09-17 06:29 ` Michael Glaesemann <[email protected]>
0 siblings, 0 replies; 22+ messages in thread
From: Michael Glaesemann @ 2004-09-17 06:29 UTC (permalink / raw)
To: John Hansen <[email protected]>; +Cc: pgsql-www
On Sep 17, 2004, at 3:25 PM, John Hansen wrote:
> I'm going on a 10 day holiday in perth, and will be back on Monday
> 27/9.
Have a great time, app^H^H John!
:)
Michael Glaesemann
grzm myrealbox com
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
@ 2004-09-25 10:13 John Hansen <[email protected]>
0 siblings, 0 replies; 22+ messages in thread
From: John Hansen @ 2004-09-25 10:13 UTC (permalink / raw)
To: Michael Glaesemann <[email protected]>; +Cc: pgsql-www
I'm back
^ permalink raw reply [nested|flat] 22+ messages in thread
* search.postgresql.org
@ 2004-09-26 21:11 John Hansen <[email protected]>
0 siblings, 0 replies; 22+ messages in thread
From: John Hansen @ 2004-09-26 21:11 UTC (permalink / raw)
To: pgsql-www
The archives are now fully searchable again.
Also, there is a mirror of the archives at
http://search.postgresql.org/archives/
... John
^ permalink raw reply [nested|flat] 22+ messages in thread
* search.postgresql.org
@ 2006-01-27 09:48 John Hansen <[email protected]>
0 siblings, 0 replies; 22+ messages in thread
From: John Hansen @ 2006-01-27 09:48 UTC (permalink / raw)
To: pgsql-www
Search was down today, from approx 15:45 AEDST to 20:45, due to a power outage.
... John
^ permalink raw reply [nested|flat] 22+ messages in thread
* search.postgresql.org
@ 2006-03-25 05:57 Joshua D. Drake <[email protected]>
2006-03-25 06:07 ` Re: search.postgresql.org Tom Lane <[email protected]>
0 siblings, 1 reply; 22+ messages in thread
From: Joshua D. Drake @ 2006-03-25 05:57 UTC (permalink / raw)
To: pgsql-www
Hello,
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.
Thoughts?
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2006-03-25 05:57 search.postgresql.org Joshua D. Drake <[email protected]>
@ 2006-03-25 06:07 ` Tom Lane <[email protected]>
2006-03-25 06:24 ` Re: search.postgresql.org Marc G. Fournier <[email protected]>
2006-03-25 16:58 ` Re: search.postgresql.org Joshua D. Drake <[email protected]>
0 siblings, 2 replies; 22+ messages in thread
From: Tom Lane @ 2006-03-25 06:07 UTC (permalink / raw)
To: Joshua D. Drake <[email protected]>; +Cc: pgsql-www
"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?
regards, tom lane
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2006-03-25 05:57 search.postgresql.org Joshua D. Drake <[email protected]>
2006-03-25 06:07 ` Re: search.postgresql.org Tom Lane <[email protected]>
@ 2006-03-25 06:24 ` Marc G. Fournier <[email protected]>
2006-03-25 06:45 ` Re: search.postgresql.org John Hansen <[email protected]>
1 sibling, 1 reply; 22+ messages in thread
From: Marc G. Fournier @ 2006-03-25 06:24 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: Joshua D. Drake <[email protected]>; pgsql-www
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?
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [email protected] Yahoo!: yscrappy ICQ: 7615664
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2006-03-25 05:57 search.postgresql.org Joshua D. Drake <[email protected]>
2006-03-25 06:07 ` Re: search.postgresql.org Tom Lane <[email protected]>
2006-03-25 06:24 ` Re: search.postgresql.org Marc G. Fournier <[email protected]>
@ 2006-03-25 06:45 ` John Hansen <[email protected]>
0 siblings, 0 replies; 22+ messages in thread
From: John Hansen @ 2006-03-25 06:45 UTC (permalink / raw)
To: Marc G. Fournier <[email protected]>; +Cc: Tom Lane <[email protected]>; Joshua D. Drake <[email protected]>; 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" <[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
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2006-03-25 05:57 search.postgresql.org Joshua D. Drake <[email protected]>
2006-03-25 06:07 ` Re: search.postgresql.org Tom Lane <[email protected]>
@ 2006-03-25 16:58 ` Joshua D. Drake <[email protected]>
2006-03-25 20:18 ` Re: search.postgresql.org Robert Treat <[email protected]>
1 sibling, 1 reply; 22+ messages in thread
From: Joshua D. Drake @ 2006-03-25 16:58 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: pgsql-www
> 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
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2006-03-25 05:57 search.postgresql.org Joshua D. Drake <[email protected]>
2006-03-25 06:07 ` Re: search.postgresql.org Tom Lane <[email protected]>
2006-03-25 16:58 ` Re: search.postgresql.org Joshua D. Drake <[email protected]>
@ 2006-03-25 20:18 ` Robert Treat <[email protected]>
2006-03-25 21:00 ` Re: search.postgresql.org Oleg Bartunov <[email protected]>
0 siblings, 1 reply; 22+ messages in thread
From: Robert Treat @ 2006-03-25 20:18 UTC (permalink / raw)
To: pgsql-www; +Cc: Joshua D. Drake <[email protected]>; Tom Lane <[email protected]>
On Saturday 25 March 2006 11:58, Joshua D. Drake wrote:
> > 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?
>
> # User contributed stuff
> SiteWeight http://techdocs.postgresql.org/ 50
> SiteWeight http://archives.postgresql.org/ 50
>
Should planetpostgresql.org get added to this section?
Also maybe Oleg/Teodor could wiegh in with which sites they are currently
indexing in pgsql.ru ?
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2006-03-25 05:57 search.postgresql.org Joshua D. Drake <[email protected]>
2006-03-25 06:07 ` Re: search.postgresql.org Tom Lane <[email protected]>
2006-03-25 16:58 ` Re: search.postgresql.org Joshua D. Drake <[email protected]>
2006-03-25 20:18 ` Re: search.postgresql.org Robert Treat <[email protected]>
@ 2006-03-25 21:00 ` Oleg Bartunov <[email protected]>
2006-03-27 14:14 ` Re: search.postgresql.org Jim C. Nasby <[email protected]>
2006-03-27 14:24 ` Re: search.postgresql.org Harald Armin Massa <[email protected]>
0 siblings, 2 replies; 22+ messages in thread
From: Oleg Bartunov @ 2006-03-25 21:00 UTC (permalink / raw)
To: Robert Treat <[email protected]>; +Cc: pgsql-www; Joshua D. Drake <[email protected]>; Tom Lane <[email protected]>
On Sat, 25 Mar 2006, Robert Treat wrote:
> On Saturday 25 March 2006 11:58, Joshua D. Drake wrote:
>>> 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?
>>
>> # User contributed stuff
>> SiteWeight http://techdocs.postgresql.org/ 50
>> SiteWeight http://archives.postgresql.org/ 50
>>
>
> Should planetpostgresql.org get added to this section?
>
> Also maybe Oleg/Teodor could wiegh in with which sites they are currently
> indexing in pgsql.ru ?
we have 78 sites indexed, see http://pgsql.ru/db/pgsearch/stat.html
and do nothing with weights.
>
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [email protected], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2006-03-25 05:57 search.postgresql.org Joshua D. Drake <[email protected]>
2006-03-25 06:07 ` Re: search.postgresql.org Tom Lane <[email protected]>
2006-03-25 16:58 ` Re: search.postgresql.org Joshua D. Drake <[email protected]>
2006-03-25 20:18 ` Re: search.postgresql.org Robert Treat <[email protected]>
2006-03-25 21:00 ` Re: search.postgresql.org Oleg Bartunov <[email protected]>
@ 2006-03-27 14:14 ` Jim C. Nasby <[email protected]>
1 sibling, 0 replies; 22+ messages in thread
From: Jim C. Nasby @ 2006-03-27 14:14 UTC (permalink / raw)
To: Oleg Bartunov <[email protected]>; +Cc: Robert Treat <[email protected]>; pgsql-www; Joshua D. Drake <[email protected]>; Tom Lane <[email protected]>
On Sun, Mar 26, 2006 at 12:00:34AM +0300, Oleg Bartunov wrote:
> we have 78 sites indexed, see http://pgsql.ru/db/pgsearch/stat.html
> and do nothing with weights.
Man, that's damn handy! We should really have something like that on the
main site, perhaps a "search the official sites" and "search
everything".
--
Jim C. Nasby, Sr. Engineering Consultant [email protected]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2006-03-25 05:57 search.postgresql.org Joshua D. Drake <[email protected]>
2006-03-25 06:07 ` Re: search.postgresql.org Tom Lane <[email protected]>
2006-03-25 16:58 ` Re: search.postgresql.org Joshua D. Drake <[email protected]>
2006-03-25 20:18 ` Re: search.postgresql.org Robert Treat <[email protected]>
2006-03-25 21:00 ` Re: search.postgresql.org Oleg Bartunov <[email protected]>
@ 2006-03-27 14:24 ` Harald Armin Massa <[email protected]>
1 sibling, 0 replies; 22+ messages in thread
From: Harald Armin Massa @ 2006-03-27 14:24 UTC (permalink / raw)
To: Oleg Bartunov <[email protected]>; +Cc: pgsql-www
>
>
> we have 78 sites indexed, see http://pgsql.ru/db/pgsearch/stat.html
> and do nothing with weights.
>
Wow! That is really really fast and good. I would love to see this on
Postgresql main page (maybe linked), and ...
you do that with tsearch2 ?
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
PostgreSQL - supported by a community that does not put you on hold
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
@ 2006-03-25 18:15 Dave Page <[email protected]>
2006-03-25 20:49 ` Re: search.postgresql.org Oleg Bartunov <[email protected]>
0 siblings, 1 reply; 22+ messages in thread
From: Dave Page @ 2006-03-25 18:15 UTC (permalink / raw)
To: [email protected]; [email protected]; +Cc: pgsql-www
-----Original Message-----
From: "Joshua D. Drake"<[email protected]>
Sent: 25/03/06 16:53:27
To: "Tom Lane"<[email protected]>
Cc: "PostgreSQL WWW"<[email protected]>
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
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2006-03-25 18:15 Re: search.postgresql.org Dave Page <[email protected]>
@ 2006-03-25 20:49 ` Oleg Bartunov <[email protected]>
0 siblings, 0 replies; 22+ messages in thread
From: Oleg Bartunov @ 2006-03-25 20:49 UTC (permalink / raw)
To: Dave Page <[email protected]>; +Cc: [email protected]; [email protected]; pgsql-www
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"<[email protected]>
> Sent: 25/03/06 16:53:27
> To: "Tom Lane"<[email protected]>
> Cc: "PostgreSQL WWW"<[email protected]>
> 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: [email protected], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
@ 2006-03-25 23:10 Dave Page <[email protected]>
2006-03-26 09:17 ` Re: search.postgresql.org Guillaume Smet <[email protected]>
0 siblings, 1 reply; 22+ messages in thread
From: Dave Page @ 2006-03-25 23:10 UTC (permalink / raw)
To: [email protected]; [email protected]; +Cc: [email protected]; [email protected]; pgsql-www
-----Original Message-----
From: "Oleg Bartunov"<[email protected]>
Sent: 25/03/06 20:49:25
To: "Dave Page"<[email protected]>
Cc: "[email protected]"<[email protected]>, "[email protected]"<[email protected]>, "[email protected]"<[email protected]>
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 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
weight correction and trust authors of web pages.
Oleg
On Sat, 25 Mar 2006, Dave Page wrote:
>
>
> -----Original Message-----
> From: "Joshua D. Drake"<[email protected]>
> Sent: 25/03/06 16:53:27
> To: "Tom Lane"<[email protected]>
> Cc: "PostgreSQL WWW"<[email protected]>
> 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: [email protected], 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
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2006-03-25 23:10 Re: search.postgresql.org Dave Page <[email protected]>
@ 2006-03-26 09:17 ` Guillaume Smet <[email protected]>
2006-03-26 17:29 ` Re: search.postgresql.org Dave Page <[email protected]>
0 siblings, 1 reply; 22+ messages in thread
From: Guillaume Smet @ 2006-03-26 09:17 UTC (permalink / raw)
To: Dave Page <[email protected]>; +Cc: [email protected]; [email protected]; [email protected]; pgsql-www
Dave Page wrote:
> 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.
Speaking of that, I noticed a problem a few days ago related to the
scope of the search.
You can reproduce it this way:
http://www.postgresql.org/docs/8.1/interactive/index.html
Search for alter table for example:
http://search.postgresql.org/www.search?ul=http%3A%2F%2Fwww.postgresql.org%2Fdocs%2F8.1%2Finteractiv...
You have 91 results and especially the results from the documentation.
But when you click on the search button again on the results page, the
ul parameter is not here anymore and you have pretty bad results:
http://search.postgresql.org/www.search?cs=utf-8&fm=on&gr=on&o=0&ps=20&s=rate&am...
We have only 15 results and the documentation is not there.
So we should probably keep the ul parameter in the new form when set in
the query string but I don't understand why we don't have the doc
results when ul is not there and I suspect the search should be global
in this case.
Regards,
--
Guillaume
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: search.postgresql.org
2006-03-25 23:10 Re: search.postgresql.org Dave Page <[email protected]>
2006-03-26 09:17 ` Re: search.postgresql.org Guillaume Smet <[email protected]>
@ 2006-03-26 17:29 ` Dave Page <[email protected]>
0 siblings, 0 replies; 22+ messages in thread
From: Dave Page @ 2006-03-26 17:29 UTC (permalink / raw)
To: Guillaume Smet <[email protected]>; +Cc: [email protected]; [email protected]; [email protected]; pgsql-www
-----Original Message-----
From: Guillaume Smet [mailto:[email protected]]
Sent: Sun 3/26/2006 10:17 AM
To: Dave Page
Cc: [email protected]; [email protected]; [email protected]; [email protected]
Subject: Re: [pgsql-www] search.postgresql.org
> But when you click on the search button again on the results page, the
> ul parameter is not here anymore and you have pretty bad results:
Hm, no, it does seem to vanish. John, is that one of those template formatting buglets?
> http://search.postgresql.org/www.search?cs=utf-8&fm=on&gr=on&o=0&ps=20&s=rate&am...
> We have only 15 results and the documentation is not there.
What you see there is the site grouping coming into effect. The docs are all on www.postgresql.org, which due to the weightings does get listed first, however, it seems that Bruce's book are the 2 options it shows from there (probably they mention the complete phrase most often or similar). You then see a couple of results from each of the other sites with hits. Under each should be a 'Show more from this site' link. Click that on the www results, and you will see the documentation hits form other parts of that site.
Regards, Dave.
^ permalink raw reply [nested|flat] 22+ messages in thread
end of thread, other threads:[~2006-03-27 14:24 UTC | newest]
Thread overview: 22+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-05 09:08 search.postgresql.org John Hansen <[email protected]>
2004-09-05 13:27 ` Oleg Bartunov <[email protected]>
2004-09-06 07:05 Re: search.postgresql.org Dave Page <[email protected]>
2004-09-17 06:25 search.postgresql.org John Hansen <[email protected]>
2004-09-17 06:29 ` Michael Glaesemann <[email protected]>
2004-09-25 10:13 Re: search.postgresql.org John Hansen <[email protected]>
2004-09-26 21:11 search.postgresql.org John Hansen <[email protected]>
2006-01-27 09:48 search.postgresql.org John Hansen <[email protected]>
2006-03-25 05:57 search.postgresql.org Joshua D. Drake <[email protected]>
2006-03-25 06:07 ` Tom Lane <[email protected]>
2006-03-25 06:24 ` Marc G. Fournier <[email protected]>
2006-03-25 06:45 ` John Hansen <[email protected]>
2006-03-25 16:58 ` Joshua D. Drake <[email protected]>
2006-03-25 20:18 ` Robert Treat <[email protected]>
2006-03-25 21:00 ` Oleg Bartunov <[email protected]>
2006-03-27 14:14 ` Jim C. Nasby <[email protected]>
2006-03-27 14:24 ` Harald Armin Massa <[email protected]>
2006-03-25 18:15 Re: search.postgresql.org Dave Page <[email protected]>
2006-03-25 20:49 ` Oleg Bartunov <[email protected]>
2006-03-25 23:10 Re: search.postgresql.org Dave Page <[email protected]>
2006-03-26 09:17 ` Guillaume Smet <[email protected]>
2006-03-26 17:29 ` Dave Page <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox