Re: Queries sometimes take 1000 times the normal time

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: "Anders K(dot) Pedersen" <akp(at)cohaesio(dot)com>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Queries sometimes take 1000 times the normal time
Date: 2003-08-28 18:33:24
Message-ID: 1062095603.79027.205.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> With regards to other jobs on the server, there is a MySQL server on it
> as well, which from time to time has some multi-second queries generated
> from a webserver also on this host, but the MySQL is running with nice
> 10 (PostgreSQL isn't nice'd).

Do those MySQL queries hit disk hard?

I've never seen PostgreSQL have hicups like you describe when running on
a machine by itself. I have experienced similar issues when another
process (cron job in my case) caused brief swapping to occur.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2003-08-28 18:49:00 Re: Simple queries take forever to run
Previous Message Rod Taylor 2003-08-28 18:29:02 Re: Hardware recommendations to scale to silly load