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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Mon, 5 Jan 2004 17:49:04 +0300 (MSK)
Oleg Bartunov <oleg@sai.msu.su>
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@sai.msu.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@postgresql.org so that your
>       message can get through to the mailing list cleanly
> 
-- 
Dave Cramer
519 939 0336
ICQ # 1467551


05 Jan 2004 10:51:34 -0500
Dave Cramer <pg@fastcrypt.com>
Re: [HACKERS] Announce: Search PostgreSQL related resources
> 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@fastcrypt.com>
To: "Oleg Bartunov" <oleg@sai.msu.su>
Cc: <pgsql-general@postgresql.org>; "Pgsql Hackers"
<pgsql-hackers@postgresql.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@sai.msu.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@postgresql.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@postgresql.org so that your
>       message can get through to the mailing list cleanly
>



Mon, 5 Jan 2004 10:13:11 -0600
"Glenn Wiorek" <gwiorek@jmlafferty.com>
Re: [HACKERS] Announce: Search PostgreSQL related resources
Dave Cramer wrote:
> connection failed :(
works for me... :-) (poland)

 

Mon, 05 Jan 2004 17:16:05 +0100
Marek Lewczuk <newsy@lewczuk.com>
Re: [HACKERS] Announce: Search PostgreSQL related resources
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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Mon, 5 Jan 2004 20:52:30 +0300 (MSK)
Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] Announce: Search PostgreSQL related resources
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.Elphick@lfix.co.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 


Mon, 05 Jan 2004 19:05:04 +0000
Oliver Elphick <olly@lfix.co.uk>
Re: Announce: Search PostgreSQL related resources

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@sai.msu.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
>
>  
>



Tue, 06 Jan 2004 01:05:52 +0530
Rajesh Kumar Mallah <mallah@trade-india.com>
Re: Announce: Search PostgreSQL related resources

> 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.



Tue, 06 Jan 2004 11:45:51 +0100
Chris <list@1006.org>
Re: [HACKERS] Announce: Search PostgreSQL related resources
> 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.




Tue, 06 Jan 2004 12:25:10 +0100
Chris <list@1006.org>
Re: Announce: Search PostgreSQL related resources
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@sai.msu.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@postgresql.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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Fri, 9 Jan 2004 11:12:28 +0300 (MSK)
Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] Announce: Search PostgreSQL related resources
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

Mon, 12 Jan 2004 21:36:53 +0000
Richard Huxton <dev@archonet.com>
Re: Announce: Search PostgreSQL related resources