Re: Long running queries and timeouts

Jean-Michael,

> Are you connecting from Netscape? I noticed long queries timeouted in
>
> Netscape. This is because Nescape waits for the entire content of a
>  page
> before displaying it.

Yes, and several other Mozilla derivatives.  For example, Konqueror has
 a .conf variable that defaults its timeout at 60 seconds.  While one
 can adjust this, you can't count on hundreds of users doing the same.

> PostgreSQL can run very fast when well-optimized. You probably need
>  to
> optimize the source code of queries themselves, probably writing some
>  good
> PL/pgSQL server side code. If you need a GUI to do so, download and
>  install
> Dave Page's excellent tool http://pgadmin.postgresql.org

Nope don't need a GUI.  The query in question was actually a procedure
 that evaluated 700-1500 candidates for jobs based on between 14 and 90
 different scalable criteria and then ranked them by suitability.  So
 there was a good reason for it to run for a long time ... that, and
 the DB server's damn Celeron chip which I eventually replaced.

Thanks for the general advice.  I'm sure the other list members will
 benefit from it.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco