Query time - Mailing list pgsql-performance

From Ruben Rubio Rey
Subject Query time
Date
Msg-id 44114F85.8020702@rentalia.com
Whole thread Raw
Responses Re: Query time
Re: Query time
List 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



pgsql-performance by date:

Previous
From: "H.J. Sanders"
Date:
Subject: FW: x206-x226
Next
From: Richard Huxton
Date:
Subject: Re: Process Time X200