Re: Queries sometimes take 1000 times the normal time - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Queries sometimes take 1000 times the normal time
Date
Msg-id 1062095603.79027.205.camel@jester
Whole thread Raw
In response to Re: Queries sometimes take 1000 times the normal time  ("Anders K. Pedersen" <akp@cohaesio.com>)
List 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.

Attachment

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Hardware recommendations to scale to silly load
Next
From: Stephan Szabo
Date:
Subject: Re: Simple queries take forever to run