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
if that link doesn't work, try
for now you will have to type it, I'm working on indexing it then making
On Tue, 2003-12-30 at 22:39, D. Dante Lorenso wrote:
> 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.
> >What is the full URL for the page you are looking at? Just the 'search
> >link' at the top of the page?
> >>Perhaps this should be worked on?
> >Looking into it right now ...
> http://www.postgresql.org/ *click Docs on top of page*
> http://www.postgresql.org/docs/ * click PostgreSQL static
> documentation *
> Search this document set: [ SECURITY INVOKER ] Search!
> I loaded that URL on IE and I wait like 2 minutes or more for a response.
> then, it usually returns with 1 result. I click the Search! button again
> to refresh and it came back a little faster with 0 results?
> Searched again from the top and it's a little faster now:
> * click search *
> > date
> Wed Dec 31 22:52:01 CST 2003
> * results come back *
> > date
> Wed Dec 31 22:52:27 CST 2003
> Still one result:
> PostgreSQL 7.4 Documentation (SQL Key Words)
> Size: 65401 bytes, modified: Tue, 25 Nov 2003, 15:02:33 AST
> However, the page that I SHOULD have found was this one:
> That page has SECURITY INVOKER in a whole section:
> [EXTERNAL] SECURITY INVOKER
> [EXTERNAL] SECURITY DEFINER
> SECURITY INVOKER indicates that the function is to be executed with
> the privileges of the user that calls it. That is the default.
> SECURITY DEFINER specifies that the function is to be executed with
> the privileges of the user that created it.
> D. Dante Lorenso
> ---------------------------(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
519 939 0336
ICQ # 1467551
In response to
pgsql-general by date
|Next:||From: Marc G. Fournier||Date: 2003-12-31 05:04:20|
|Subject: Re: website doc search is extremely SLOW|
|Previous:||From: Joshua D. Drake||Date: 2003-12-31 04:25:08|
|Subject: Re: PostgreSQL speakers needed for OSCON 2004|