X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0CE0632A610 for ; Fri, 1 Oct 2004 17:39:10 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 69125-05 for ; Fri, 1 Oct 2004 16:39:08 +0000 (GMT) Received: from dev.eisolution.com (dsl081-146-252.chi1.dsl.speakeasy.net [64.81.146.252]) by svr1.postgresql.org (Postfix) with ESMTP id 276D932A60B for ; Fri, 1 Oct 2004 17:39:02 +0100 (BST) Received: from MarcM8500 (sbce [67.39.137.114]) (authenticated bits=0) by dev.eisolution.com (8.12.8/8.12.8) with ESMTP id i91Gcw7F030838; Fri, 1 Oct 2004 11:38:58 -0500 From: "Marc Mitchell" To: "'Shane | SkinnyCorp'" , "'PgSQL ADMIN'" Subject: Re: PLEASE GOD HELP US! Date: Fri, 1 Oct 2004 11:38:52 -0500 Message-ID: <00de01c4a7d5$2337ab20$7901a8c0@MarcM8500> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: <002801c4a7d0$66797ad0$3402a8c0@shanepc> Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=LINES_OF_YELLING, SUBJ_ALL_CAPS X-Spam-Level: X-Archive-Number: 200410/18 X-Sequence-Number: 15012 -----Original Message----- > From: pgsql-admin-owner@postgresql.org > On Behalf Of Shane | SkinnyCorp > Sent: Friday, October 01, 2004 10:05 AM > To: PgSQL ADMIN > Subject: [ADMIN] PLEASE GOD HELP US! > > .... You can use pgmonitor to visually see general load and check if there is any contention. Your sample queries were all SELECTs but the data has to be getting in there somehow. What's the relationship between the process that issues the queries and the database machine? Could there be any latency between the two? Individual queries could run quickly but if the requester takes a while to retrieve the request results before submitting a subsequent query, that can result in problems? Without index, table size and sample distribution information (or explain verbose output), it is difficult to say if any one query could be made to execute faster. Marc Mitchell Enterprise Information Solutions, Inc. Downers Grove, IL 60515 marcm@eisolution.com