Skip site navigation (1) Skip section navigation (2)

Re: random slow query

From: Mike Ivanov <mikei(at)activestate(dot)com>
To: Sean Ma <seanxma(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: random slow query
Date: 2009-06-29 23:26:30
Message-ID: 4A494DA6.4010107@activestate.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi Sean,

Sean Ma wrote:
> One months ago, this type of slow query happened about a few time per
> day. But recently, the slow query happens more frequent at the rate of
> once every 10 minutes or less. There seesm not relation to th

What is your hardware (memory, CPU type and such)?

This seems like a cache issue to me, but I can't tell for sure without 
some additional information on your system:

1) What is the amount of a) available memory b) free memory and c) 
memory available to i/o buffers?

2) What is the swap usage if any?

3) What is the CPU load? Any noticeable patterns in CPU load?

You can use /usr/bin/top to obtain most of this information.

Mike



In response to

Responses

pgsql-performance by date

Next:From: Craig RingerDate: 2009-06-30 05:54:41
Subject: Re: Utilizing multiple cores in a function call.
Previous:From: Merlin MoncureDate: 2009-06-29 21:21:32
Subject: Re: Utilizing multiple cores in a function call.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group