473,838 Members | 1,624 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

website doc search is extremely SLOW

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 my search over two minutes ago. I just finished this
email to the list. The results have still not come back. I only
searched for:

SECURITY INVOKER

Perhaps this should be worked on?

Dante

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

Nov 12 '05
83 5977

-----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 engine for the docs back when the site was having
problems last year, and myself and some others needed a searchable
interface. It actually spidered the raw sgml pages themselves, and was
fairly quick. I can resurrect this if anyone is interested. It runs
with Perl and PostgreSQL and nothing else. :) Of course, it could probably
be modified to feed it's sgml parsing output to tsearch as well.

In the meantime, could we please switch to a simple google search? It
would require changing one or two lines of HTML source, and at least
there would be *something* until we get everything sorted out.

- --
Greg Sabino Mullane gr**@turnstep.c om
PGP Key: 0x14964AC8 200401041439

-----BEGIN PGP SIGNATURE-----

iD8DBQE/+GwIvJuQZxSWSsg RAkOgAJ9lmXwd/h/d+HzPiaPUVvO/Gq1O9wCeNbmn
CidSrTYP0sc5pp/hdlIS19o=
=YPWw
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #71
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 fun :)


Ummm, where do you derive that from? As the -www team all know (or
should), they need something installed, they ask for it ... we have OACS,
Jakarta-Tomcat, mod_perl, mod_python, etc now as it is. I personally use
PHP, but I don't use CMSs, so don't even know of a PHPbased CMS to think
to recommend ...

Personally, I use what fits the situation ... web based stuff, I generally
do in PHP ... command line, all in perl *shrug*

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #72
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 :)


Access to the archives was provided before New Years *puzzled look* I sent
Teodor the rsync command that he needs to run to download it all from the
IP he provided me previously ...


Hmm, what's the secret rsync command you didn't share with me :)


Its no secret, else I wouldn't have sent it to Teodor :)

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #73
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 give us access to mailing list archives :)


Access to the archives was provided before New Years *puzzled look* I sent
Teodor the rsync command that he needs to run to download it all from the
IP he provided me previously ...


Hmm, what's the secret rsync command you didn't share with me :)


----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


Regards,
Oleg
_______________ _______________ _______________ _______________ _
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: ol**@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 ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

--
Dave Cramer
519 939 0336
ICQ # 1467551
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #74
Marc,

Can you please send it again, I can't seem to find the original message?

Dave
On Sun, 2004-01-04 at 10:03, Marc G. Fournier wrote:
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 :)

Access to the archives was provided before New Years *puzzled look* I sent
Teodor the rsync command that he needs to run to download it all from the
IP he provided me previously ...


Hmm, what's the secret rsync command you didn't share with me :)


Its no secret, else I wouldn't have sent it to Teodor :)

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

--
Dave Cramer
519 939 0336
ICQ # 1467551
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #75

Check it out now and let me know what you searched on, and whether or not
you see an improvement over what it was ... Tom -and- Bruce suggested some
changes that, from my tests, show a dramatic change in speed *compared to
what it was* ... but that could just be that I'm getting lucky ...

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 ironic! I only come to the online docs when I already know the
<where> part of my search and just go to that part or section. For
everything else, there's google!

SECURITY INVOKER site:postgresql .org

Searched pages from postgresql.org for SECURITY INVOKER. Results 1 -
10 of about 141. Search took 0.23 seconds.
Ahhh, that's better.

Or use site:www.postgresql.org to avoid the archive listings, etc.

== Ezra Epstein

""D. Dante Lorenso"" <da***@lorenso. com> wrote in message
news:3F******** ******@lorenso. com...
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 my search over two minutes ago. I just finished this
email to the list. The results have still not come back. I only
searched for:

SECURITY INVOKER

Perhaps this should be worked on?

Dante

---------------------------(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 7: don't forget to increase your free space map settings


----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 12 '05 #76
On Sun, 4 Jan 2004, Greg Sabino Mullane wrote:
------------------------------------------------------------------------------
/usr/local/libexec/ppf_verify: pgp command failed

gpg: WARNING: using insecure memory!
gpg: please see http://www.gnupg.org/faq.html for more information
gpg: Signature made Sun Jan 4 15:39:52 2004 AST using DSA key ID 14964AC8
gpg: Can't check signature: public key not found
------------------------------------------------------------------------------
-----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 engine for the docs back when the site was having
problems last year, and myself and some others needed a searchable
interface. It actually spidered the raw sgml pages themselves, and was
fairly quick. I can resurrect this if anyone is interested. It runs
with Perl and PostgreSQL and nothing else. :) Of course, it could probably
be modified to feed it's sgml parsing output to tsearch as well.

In the meantime, could we please switch to a simple google search? It
would require changing one or two lines of HTML source, and at least
there would be *something* until we get everything sorted out.


Have you checked things out since Tom -and- Bruce's suggestions?

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 12 '05 #77

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Have you checked things out since Tom -and- Bruce's suggestions?


Yes, and while they are better, they still reflect badly on PostgreSQL:

Searching for "partial index" in the docs only: 12.26 seconds

Searching from that result page (which defaults to the while site)
for the word "index": 16.32 seconds

By comparison, the mysql site (which claims to be running Mnogosearch)
returns instantly, no matter the query. I like the idea of separating
the archives into their own search, which I agree with Marc should
help quite a bit.

- --
Greg Sabino Mullane gr**@turnstep.c om
PGP Key: 0x14964AC8 200401041533

-----BEGIN PGP SIGNATURE-----

iD8DBQE/+HmHvJuQZxSWSsg RAmV0AJsHQ1lisS j4ur1WWyylYUjUW ONU/QCgzk5p
UeN+njNAiWFA/u2+AajuC4k=
=qWcr
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 12 '05 #78
I searched only the 7.4 docs for create table, and it returned in 10
seconds, much better

Dave
On Sun, 2004-01-04 at 15:02, Marc G. Fournier wrote:
Check it out now and let me know what you searched on, and whether or not
you see an improvement over what it was ... Tom -and- Bruce suggested some
changes that, from my tests, show a dramatic change in speed *compared to
what it was* ... but that could just be that I'm getting lucky ...

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 ironic! I only come to the online docs when I already know the
<where> part of my search and just go to that part or section. For
everything else, there's google!

SECURITY INVOKER site:postgresql .org

Searched pages from postgresql.org for SECURITY INVOKER. Results 1 -
10 of about 141. Search took 0.23 seconds.
Ahhh, that's better.

Or use site:www.postgresql.org to avoid the archive listings, etc.

== Ezra Epstein

""D. Dante Lorenso"" <da***@lorenso. com> wrote in message
news:3F******** ******@lorenso. com...
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 my search over two minutes ago. I just finished this
email to the list. The results have still not come back. I only
searched for:

SECURITY INVOKER

Perhaps this should be worked on?

Dante

---------------------------(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 7: don't forget to increase your free space map settings


----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

--
Dave Cramer
519 939 0336
ICQ # 1467551
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #79
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 broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #80

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
2238
by: bettina | last post by:
I'm re-programming my Website (www.coaster.ch) in PHP and I find it too slow (although I have ADSL). That's more or less how it functions: Here my tables: 'COASTERS' (code of coaster, code of country, etc...) 'COUNTRIES' (code of country, names of countries in different languages, code of continent) 'CONTINENTS' (code of continent, names of continents in different languages)
12
6481
by: Vjay77 | last post by:
Hi, I haven't posted any problem in quite a while now, but I came to the point that I really need to ask for help. I need to create an application which will search through .txt log file and find all lines where email from hotmail occured. All these emails need to be printed to list box on the form. Problem with code you'll see below, is that it takes long time to
4
4778
by: sommes | last post by:
It's only happen on .asp website, what's the problem? Thank you
2
2079
by: tmb | last post by:
When publishing a website the process is excrutiatingly slow - we are talking 3-4 minutes from when the actual transfer to the site has begun to completion. Apparently i'm not the only one experiencing this and searching on the net i found a possible solution: http://blog.n-technologies.be/CommentView.aspx?guid=3df1930b-9517-4b9b-9dd6-b59cbcbbe34d However, i don't quite understand how to actually apply the solution mentioned. I have...
2
5040
by: yasmike | last post by:
I am having a problem with my secure website on our internal network. The secure website is hosted on our Windows 2000 Server running IIS 5.0. If you try and access the website from a browser from another computer on the same internal network using its domain name, https://www.domainname .com, it is extremely slow. If you access it using its IP https://192.168.1.2 it is very quick. It is also quick for anyone outside the internal network to...
0
9853
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10903
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10289
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9423
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7014
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5864
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4482
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4062
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3131
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.