Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0Q0RVl27841 for ; Fri, 25 Jan 2002 19:27:31 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.5.2) with HTTP id 676382; Fri, 25 Jan 2002 16:27:31 -0800 From: "Josh Berkus" Subject: Re: Long running queries and timeouts To: jm.poure@freesurf.fr, "Josh Berkus" , Francisco Reyes Cc: pgsql-php@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.5.2 Date: Fri, 25 Jan 2002 16:27:31 -0800 Message-ID: In-Reply-To: <200201231358.g0NDwML18011@www1.translationforge> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200201/73 X-Sequence-Number: 877 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