Query time

From: Ruben Rubio Rey <ruben(at)rentalia(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Query time
Date: 2006-03-10 10:05:57
Message-ID: 44114F85.8020702@rentalia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Any ideas will be apreciatted.

Ruben Rubio

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ruben Rubio Rey 2006-03-10 10:29:53 Re: Query time
Previous Message H.J. Sanders 2006-03-10 09:59:46 FW: x206-x226