Inconsistent performance

From: Joseph Bove <jbove(at)vetstar(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Inconsistent performance
Date: 2003-09-15 21:34:12
Message-ID: 5.1.0.14.2.20030915172334.00b1fe48@mail.vetstar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

To whoever can assist,

I am working with a decent sized database on an extremely powerful machine.
The specs follow:

OS: RedHat Linux 9.0
PG Version 7.3
Memory 1 gig
CPU Quad Processor - Unsure of exact CPUs
Hard Drive 80 gigs
Database Size 2 gigs

As you can see the server is built for overkill.

The problem that I see is as follows.

I do a rather simple query: select count (*) from large-table where column
= some value;

About 80% of the time, the response time is sub-second. However, at 10% of
the time, the response time is 5 - 10 seconds.

This is nothing readily apparent at the system level that comes close to
explaining the performance hits. CPU and memory usage (as measured by top)
appear to be fine.

Although there are certain tuning issues within the database itself, no
documentation I have seen seems to indicate that tuning issues would lead
to such inconsistent response time.

Any ideas?

Regards,

Joseph

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2003-09-15 21:34:49 Re: Inconsistent performance
Previous Message Womens Breakthrough 2003-09-15 20:54:18 L|p Treatment that makes your L|ps PLUMP