Re: Query time

From: Ruben Rubio Rey <ruben(at)rentalia(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query time
Date: 2006-03-13 08:02:42
Message-ID: 44152722.9080008@rentalia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2006-03-13 08:16:54 Re: Query time
Previous Message Bruno Wolff III 2006-03-12 21:00:51 Re: help needed asap....