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

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 (view raw or flat)
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

pgsql-performance by date

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

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