Re: [GENERAL] website doc search is extremely SLOW

2004-01-05 Thread Marc G. Fournier
On Mon, 5 Jan 2004, Tom Lane wrote: > Mark Kirkwood <[EMAIL PROTECTED]> writes: > > These results seem pretty good to me... > > FWIW, I see pretty decent search speed when I go to > http://www.postgresql.org/search.cgi > but pretty lousy search speed when I try a similar query at > http://archives

Re: [GENERAL] website doc search is extremely SLOW

2004-01-05 Thread Oleg Bartunov
Try www.pgsql.ru. I just released pilot version with full text searching postgresql related resources. Search for security invoker takes 0.03 sec :) Oleg On Thu, 1 Jan 2004, ezra epstein wrote: > Yup, > > So slow in fact that I never use it. I did once or twice and gave up. > It is i

Re: [GENERAL] website doc search is extremely SLOW

2004-01-05 Thread Tom Lane
Mark Kirkwood <[EMAIL PROTECTED]> writes: > These results seem pretty good to me... FWIW, I see pretty decent search speed when I go to http://www.postgresql.org/search.cgi but pretty lousy search speed when I try a similar query at http://archives.postgresql.org/ Could we get the latter search

Re: [GENERAL] website doc search is extremely SLOW

2004-01-05 Thread Mark Kirkwood
I just tried : i) "wal" in "7.4 docs" -> 5 seconds ii) "partial index" in "All Sites" -> 3 seconds iii) "column statistics" in "All Sites" -> 2 seconds iv) "fork exec" in "All Sites" -> 2 seconds These results seem pretty good to me... regards Mark ---(end of broad

Re: [GENERAL] website doc search is extremely SLOW

2004-01-04 Thread Dave Cramer
Send it to me too please? Dave On Sun, 2004-01-04 at 04:34, Oleg Bartunov wrote: > On Sat, 3 Jan 2004, Marc G. Fournier wrote: > > > On Sat, 3 Jan 2004, Oleg Bartunov wrote: > > > > > time was one of implementation of such system. This is what I hope to have on > > > www.pgsql.ru, if Marc will gi

Re: [GENERAL] website doc search is extremely SLOW

2004-01-04 Thread Marc G. Fournier
On Sun, 4 Jan 2004, Oleg Bartunov wrote: > On Sat, 3 Jan 2004, Marc G. Fournier wrote: > > > On Sat, 3 Jan 2004, Oleg Bartunov wrote: > > > > > time was one of implementation of such system. This is what I hope to have on > > > www.pgsql.ru, if Marc will give us access to mailing list archives :)

Re: [GENERAL] website doc search is extremely SLOW

2004-01-04 Thread Marc G. Fournier
On Sat, 3 Jan 2004, Oleg Bartunov wrote: > On Sat, 3 Jan 2004, Joshua D. Drake wrote: > > > > > > > > > > > > >A content management system is long overdue I think, do you have any > > >good recommendations? > > > > > > > > > > > Bricolage > > > > It's good Mason driven CMS, but Marc seems is a PHP

Re: [GENERAL] website doc search is extremely SLOW

2004-01-04 Thread Marc G. Fournier
On Wed, 31 Dec 2003, Dave Cramer wrote: > Well it appears there are quite a few solutions to use so the next > question should be what are we trying to accomplish here? > > One thing that I think is that the documentation search should be > limited to the documentation. > > Who is in a position to

Re: [GENERAL] website doc search is extremely SLOW

2004-01-04 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I keep searching the web hoping someone has come up with a 'tsearch2' > based search engine that does the spidering, but, unless its sitting right > in front of my eyes and I'm not seeing it, I haven't found it yet :( I wrote my own search engi

Re: [GENERAL] website doc search is extremely SLOW

2004-01-04 Thread ezra epstein
Yup, So slow in fact that I never use it. I did once or twice and gave up. It is ironic! I only come to the online docs when I already know the part of my search and just go to that part or section. For everything else, there's google! SECURITY INVOKER site:postgresql.org

Re: [GENERAL] website doc search is extremely SLOW

2004-01-03 Thread Dave Cramer
On Sat, 2004-01-03 at 09:49, Oleg Bartunov wrote: > Hi there, > > I hoped to release pilot version of www.pgsql.ru with full text search > of postgresql related resources (currently we've crawled 27 sites, about > 340K pages) but we started celebration NY too early :) > Expect it tomorrow or monda

Re: [GENERAL] website doc search is extremely SLOW

2004-01-03 Thread Oleg Bartunov
On Sat, 3 Jan 2004, Dave Cramer wrote: > On Sat, 2004-01-03 at 09:49, Oleg Bartunov wrote: > > Hi there, > > > > I hoped to release pilot version of www.pgsql.ru with full text search > > of postgresql related resources (currently we've crawled 27 sites, about > > 340K pages) but we started celebr

Re: [GENERAL] website doc search is extremely SLOW

2004-01-03 Thread Joshua D. Drake
A content management system is long overdue I think, do you have any good recommendations? Bricolage -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-222-2783 - [EMAIL PROTECTED] - ht

Re: [GENERAL] website doc search is extremely SLOW

2003-12-31 Thread Marc G. Fournier
On Wed, 31 Dec 2003, Dave Cramer wrote: > In fact this is a very bad advertisement for postgres I just posted a very very long email of what I'm seeing in the logs, as well as various query runs ... it may just be something that I need to tune that I'm overlooking:( the queries aren't particular

Re: [GENERAL] website doc search is extremely SLOW

2003-12-31 Thread Dave Cramer
On Wed, 2003-12-31 at 18:43, Bruce Momjian wrote: > Marc G. Fournier wrote: > > On Tue, 30 Dec 2003, Joshua D. Drake wrote: > > > > > Hello, > > > > > > Why are we not using Tsearch2? > > > > Because nobody has built it yet? Oleg's stuff is nice, but we want > > something that we can build into

Re: [GENERAL] website doc search is extremely SLOW

2003-12-31 Thread Arjen van der Meijden
Marc, At our website we had a "in database" search as well... It was terribly slow (it was a custom built vector space model implemented in mysql+php so that explains a bit). We replaced it by the Xapian library (www.xapian.org) with its Omega frontend as a middle end. I.e. we call with our ph

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Marc G. Fournier
On Wed, 31 Dec 2003, Dave Cramer wrote: > I can modify mine to be client server if you want? > > It is a java app, so we need to be able to run jdk1.3 at least? jdk1.4 is available on the VMs ... does your spider? for instance, you mention that you have the docs indexed right now, but we are cur

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Joshua D. Drake
Hello, Why are we not using Tsearch2? Besides the obvious of getting everything into the database? Sincerely, Joshua D. Drake On Tue, 2003-12-30 at 21:24, Marc G. Fournier wrote: > On Wed, 31 Dec 2003, Dave Cramer wrote: > > > Why are their multiple servers hitting the same db > > > > what

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Dave Cramer
I can modify mine to be client server if you want? It is a java app, so we need to be able to run jdk1.3 at least? Dave On Wed, 2003-12-31 at 00:04, Marc G. Fournier wrote: > does anyone know anything better then mnogosearch, that works with > PostgreSQL, for doing indexing? the database serve

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Dave Cramer
Why are their multiple servers hitting the same db what servers are searching through the db? Dave On Wed, 2003-12-31 at 00:04, Marc G. Fournier wrote: > does anyone know anything better then mnogosearch, that works with > PostgreSQL, for doing indexing? the database server is a Dual Xeon 2.4G,

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Marc G. Fournier
On Wed, 31 Dec 2003, Dave Cramer wrote: > Why are their multiple servers hitting the same db > > what servers are searching through the db? www.postgresql.org and archives.postgresql.org both hit the same DB ... the point is more that whatever alternative that someone can suggest, it has to be ab

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Marc G. Fournier
does anyone know anything better then mnogosearch, that works with PostgreSQL, for doing indexing? the database server is a Dual Xeon 2.4G, 4G of RAM, and a load avg right now of a lowly 1.5 ... the file system is 3x72G drive in a RAID5 configuration, and the database server is 7.4 ... the mnogos

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Dave Cramer
search for create index took 59 seconds ? I've got a fairly (< 1 second for the same search) fast search engine on the docs at http://postgresintl.com/search?query=create index if that link doesn't work, try postgres.fastcrypt.com/search?query=create index for now you will have to type it, I'm

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread D. Dante Lorenso
Marc G. Fournier wrote: On Mon, 29 Dec 2003, D. Dante Lorenso wrote: Trying to use the 'search' in the docs section of PostgreSQL.org is extremely SLOW. Considering this is a website for a database and databases are supposed to be good for indexing content, I'd expect a much faster performance.

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Joshua D. Drake
When you got to docs and then click static, it has the ability to search. It is slow Sincerely, Joshua D. Drake On Tue, 2003-12-30 at 19:05, Marc G. Fournier wrote: > On Mon, 29 Dec 2003, D. Dante Lorenso wrote: > > > Trying to use the 'search' in the docs section of PostgreSQL.o

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Marc G. Fournier
On Tue, 30 Dec 2003, Marc G. Fournier wrote: > On Mon, 29 Dec 2003, D. Dante Lorenso wrote: > > > Trying to use the 'search' in the docs section of PostgreSQL.org > > is extremely SLOW. Considering this is a website for a database > > and databases are supposed to be good for indexing content, I'

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Marc G. Fournier
On Mon, 29 Dec 2003, D. Dante Lorenso wrote: > Trying to use the 'search' in the docs section of PostgreSQL.org > is extremely SLOW. Considering this is a website for a database > and databases are supposed to be good for indexing content, I'd > expect a much faster performance. What is the full

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Oleg Bartunov
On Mon, 29 Dec 2003, D. Dante Lorenso wrote: > Trying to use the 'search' in the docs section of PostgreSQL.org > is extremely SLOW. Considering this is a website for a database > and databases are supposed to be good for indexing content, I'd > expect a much faster performance. > > I submitted m