random delays

Hi,

I noticed that sometimes we seem to have a problem with simple queries
that take a long time to execute. For example "select * from config
where key='abc'" which normally only takes a few milliseconds, but in
some rare cases suddenly takes 10-30 seconds.

It is a production system, so there are always other queries going on.
But the server is not neccessarly loaded when this happens. I can't
think of any reasons that there should be a lock on the tables in question.

Is there a way to find out what the query is waiting for?

We are using postgresql 8.0.3.

Thanks,

Baldur