Re: [HACKERS] Announce: Search PostgreSQL related resources

Hi there,

I'm pleased to present pilot version of http://www.pgsql.ru - search system on
postgresql related resources. Currently, we have crawled 27 sites,
new resources are welcome. It has multi-languages interface (russian, english)
but more languages could be added. We plan to add searchable archive of
mailing lists (a'la fts.postgresql.org), russian documentation and
WIKI for online documentation, tips, etc.

We are welcome your feedback and comments. We need design solution, icons.

This project is hosted at
Sternberg Astronomical Institute, Moscow University and supported
by Russian Foundation for Basic Research and Delta-Soft LLC.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

connection failed :(

Dave
On Mon, 2004-01-05 at 09:49, Oleg Bartunov wrote:
> Hi there,
>
> I'm pleased to present pilot version of http://www.pgsql.ru - search system on
> postgresql related resources. Currently, we have crawled 27 sites,
> new resources are welcome. It has multi-languages interface (russian, english)
> but more languages could be added. We plan to add searchable archive of
> mailing lists (a'la fts.postgresql.org), russian documentation and
> WIKI for online documentation, tips, etc.
>
> We are welcome your feedback and comments. We need design solution, icons.
>
> This project is hosted at
> Sternberg Astronomical Institute, Moscow University and supported
> by Russian Foundation for Basic Research and Delta-Soft LLC.
>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
--
Dave Cramer
519 939 0336
ICQ # 1467551

> connection failed :(
>
> Dave

I had no problem accessing it - very nice and responsive ! Great job Oleg
and Teodor.

-- Glenn

----- Original Message -----
From: "Dave Cramer" <pg(at)fastcrypt(dot)com>
To: "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>
Cc: <pgsql-general(at)postgresql(dot)org>; "Pgsql Hackers"
<pgsql-hackers(at)postgresql(dot)org>
Sent: Monday, January 05, 2004 9:51 AM
Subject: Re: [HACKERS] Announce: Search PostgreSQL related resources

> connection failed :(
>
> Dave
> On Mon, 2004-01-05 at 09:49, Oleg Bartunov wrote:
> > Hi there,
> >
> > I'm pleased to present pilot version of http://www.pgsql.ru - search
system on
> > postgresql related resources. Currently, we have crawled 27 sites,
> > new resources are welcome. It has multi-languages interface (russian,
english)
> > but more languages could be added. We plan to add searchable archive of
> > mailing lists (a'la fts.postgresql.org), russian documentation and
> > WIKI for online documentation, tips, etc.
> >
> > We are welcome your feedback and comments. We need design solution,
icons.
> >
> > This project is hosted at
> > Sternberg Astronomical Institute, Moscow University and supported
> > by Russian Foundation for Basic Research and Delta-Soft LLC.
> >
> > Regards,
> > Oleg
> > _____________________________________________________________
> > Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> > Sternberg Astronomical Institute, Moscow University (Russia)
> > Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> > phone: +007(095)939-16-83, +007(095)939-23-83
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
> >
> --
> Dave Cramer
> 519 939 0336
> ICQ # 1467551
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

Dave Cramer wrote:
> connection failed :(
works for me... :-) (poland)

On Mon, 5 Jan 2004, Marek Lewczuk wrote:

> Dave Cramer wrote:
> > connection failed :(
> works for me... :-) (poland)
>

We have small downtime because of upgrading server software, so this may
be a reason for the problem. We're in stage of optimizing crawler because
some sites are very-very ugly, for example, our crawler have discovered
2 millions URLs on http://ems-hitech.com/pgmanager/ ! 99.99 % of URLs are
just 404 (document not found), but server does return 200 code )\:)
So we have to explicitly exclude these pages. btw, archives.postgresql.org
doesn't returns modification date in header. This prevent crawler to
optimize downloading process. So, there are many problems, but we hope
soon we'll tune crawling process. I estimate average time to refresh index
about 1 week.

>
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

On Mon, 2004-01-05 at 14:49, Oleg Bartunov wrote:
> Hi there,
>
> I'm pleased to present pilot version of http://www.pgsql.ru - search system on
> postgresql related resources. Currently, we have crawled 27 sites,
> new resources are welcome. It has multi-languages interface (russian, english)
> but more languages could be added. We plan to add searchable archive of
> mailing lists (a'la fts.postgresql.org), russian documentation and
> WIKI for online documentation, tips, etc.
>
> We are welcome your feedback and comments. We need design solution, icons.

Could I suggest a filter to limit results in foreign languages. For
example, I am unable to benefit from pages written in Russian; I would
like to exclude them from the search, but I see no means of doing that.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"And thou shalt love the LORD thy God with all thine
heart, and with all thy soul, and with all thy might."
Deuteronomy 6:5

Hi,

Could you please tell how the "did you mean " feature
was implemented when the serach term has a typo.

The search engine is good .

Regds
mallah.

Oleg Bartunov wrote:

>Hi there,
>
>I'm pleased to present pilot version of http://www.pgsql.ru - search system on
>postgresql related resources. Currently, we have crawled 27 sites,
>new resources are welcome. It has multi-languages interface (russian, english)
>but more languages could be added. We plan to add searchable archive of
>mailing lists (a'la fts.postgresql.org), russian documentation and
>WIKI for online documentation, tips, etc.
>
>We are welcome your feedback and comments. We need design solution, icons.
>
>This project is hosted at
>Sternberg Astronomical Institute, Moscow University and supported
>by Russian Foundation for Basic Research and Delta-Soft LLC.
>
> Regards,
> Oleg
>_____________________________________________________________
>Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
>Sternberg Astronomical Institute, Moscow University (Russia)
>Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
>phone: +007(095)939-16-83, +007(095)939-23-83
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
>
>

> http://www.pgsql.ru/
> We are welcome your feedback and comments.

Very nice work!
I've just found docs I was looking for a long time :)

Bye, Chris.

> http://www.pgsql.ru/
> We are welcome your feedback and comments.

Very nice work!
I've just found some docs I was looking for a long time :)

Bye, Chris.

On Tue, 6 Jan 2004, Rajesh Kumar Mallah wrote:

>
> Hi,
>
> Could you please tell how the "did you mean " feature
> was implemented when the serach term has a typo.

it's based on trigrams similarity and words statistics.

>
> The search engine is good .
>
> Regds
> mallah.
>
> Oleg Bartunov wrote:
>
> >Hi there,
> >
> >I'm pleased to present pilot version of http://www.pgsql.ru - search system on
> >postgresql related resources. Currently, we have crawled 27 sites,
> >new resources are welcome. It has multi-languages interface (russian, english)
> >but more languages could be added. We plan to add searchable archive of
> >mailing lists (a'la fts.postgresql.org), russian documentation and
> >WIKI for online documentation, tips, etc.
> >
> >We are welcome your feedback and comments. We need design solution, icons.
> >
> >This project is hosted at
> >Sternberg Astronomical Institute, Moscow University and supported
> >by Russian Foundation for Basic Research and Delta-Soft LLC.
> >
> > Regards,
> > Oleg
> >_____________________________________________________________
> >Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> >Sternberg Astronomical Institute, Moscow University (Russia)
> >Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> >phone: +007(095)939-16-83, +007(095)939-23-83
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 9: the planner will ignore your desire to choose an index scan if your
> > joining column's datatypes do not match
> >
> >
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

On Monday 05 January 2004 19:05, Oliver Elphick wrote:
> On Mon, 2004-01-05 at 14:49, Oleg Bartunov wrote:
> > Hi there,
> >
> > I'm pleased to present pilot version of http://www.pgsql.ru - search

Just had reason to use it in anger.Seems to work very well indeed. Nice and
smooth. Good work, Oleg & Teodor (?)

--
Richard Huxton
Archonet Ltd