pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: jm.poure@freesurf.fr, "Josh Berkus" <josh@agliodbs.com>
To: Francisco Reyes <lists@natserv.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Long running queries and timeouts
Date: Fri, 25 Jan 2002 16:27:31 -0800
Message-ID: <web-676382@davinci.ethosmedia.com> (raw)
In-Reply-To: <200201231358.g0NDwML18011@www1.translationforge>

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



view thread (16+ messages)

Message-ID: <web-676382@davinci.ethosmedia.com>
Permalink:  ../web-676382@davinci.ethosmedia.com/
Also on:    postgresql.org/message-id/web-676382@davinci.ethosmedia.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: josh@agliodbs.com, lists@natserv.com
  Subject: Re: Long running queries and timeouts
  In-Reply-To: <web-676382@davinci.ethosmedia.com>
  References: <200201231358.g0NDwML18011@www1.translationforge> <web-676382@davinci.ethosmedia.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox