X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B03489DCA21 for ; Mon, 13 Mar 2006 04:02:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76033-07 for ; Mon, 13 Mar 2006 04:02:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.rentalia.net (mail.rentalia.com [213.192.209.8]) by postgresql.org (Postfix) with ESMTP id 10F709DCA3E for ; Mon, 13 Mar 2006 04:02:49 -0400 (AST) Received: (qmail 5953 invoked by uid 514); 13 Mar 2006 08:59:09 +0100 Received: from 62.37.216.137 by rigodon (envelope-from , uid 512) with qmail-scanner-1.25-st-qms (clamdscan: 0.88/1284. spamassassin: 3.0.2. perlscan: 1.25-st-qms. Clear:RC:0(62.37.216.137):SA:0(-1.0/5.0):. Processed in 0.55214 secs); 13 Mar 2006 07:59:09 -0000 X-Antivirus-MYDOMAIN-Mail-From: ruben@rentalia.com via rigodon X-Antivirus-MYDOMAIN: 1.25-st-qms (Clear:RC:0(62.37.216.137):SA:0(-1.0/5.0):. Processed in 0.55214 secs Process 5944) Received: from 62-37-216-137.mad1.adsl.uni2.es (HELO ?192.168.2.28?) (ruben@rentalia.com@62.37.216.137) by mail.rentalia.net with SMTP; 13 Mar 2006 08:59:08 +0100 Message-ID: <44152722.9080008@rentalia.com> Date: Mon, 13 Mar 2006 09:02:42 +0100 From: Ruben Rubio Rey User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051011) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Query time References: <44114F85.8020702@rentalia.com> <4411821A.8000605@archonet.com> In-Reply-To: <4411821A.8000605@archonet.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.106 required=5 tests=[AWL=0.106] X-Spam-Score: 0.106 X-Spam-Level: X-Archive-Number: 200603/159 X-Sequence-Number: 17596 Richard Huxton wrote: > Ruben Rubio Rey wrote: > >> Hi, >> >> I think im specting problems with a 7.4.8 postgres database. >> >> Sometimes some big query takes between 5 to 15 seconds. It happens >> sometimes all the day it does not depend if database is busy. >> >> I have measured that sentence in 15 - 70 ms in normal circunstances. >> >> Why sometimes its takes too much time? >> How can I fix it? >> Is a postgres version problem, database problem or query problem? > > > Information, Ruben - we can't do anything without information. > What usefull information could I provide?