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

Re: Slow Postgresql server

From: Guido Neitzer <lists(at)event-s(dot)net>
To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow Postgresql server
Date: 2007-04-12 14:08:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-patchespgsql-performance
On 12.04.2007, at 07:26, Ron wrote:

> You need to buy RAM and HD.

Before he does that, wouldn't it be more useful, to find out WHY he  
has so much IO?

Have I missed that or has nobody suggested finding the slow queries  
(when you have much IO on them, they might be slow at least with a  
high shared memory setting).

So, my first idea is, to turn on query logging for queries longer  
than a xy milliseconds, "explain analyse" these queries and see  
wether there are a lot of seq scans involved, which would explain the  
high IO.

Just an idea, perhaps I missed that step in that discussion  
somewhere ...

But yes, it might also be, that the server is swapping, that's  
another thing to find out.


In response to


pgsql-performance by date

Next:From: RonDate: 2007-04-12 14:59:10
Subject: Re: Slow Postgresql server
Previous:From: Merlin MoncureDate: 2007-04-12 13:42:03
Subject: Re: Large objetcs performance

pgsql-hackers by date

Next:From: Jonah H. HarrisDate: 2007-04-12 14:08:11
Subject: Re: Benchmarking tools for the Postgres, EDB and Oracle Database
Previous:From: Alvaro HerreraDate: 2007-04-12 14:07:22
Subject: Re: What tools do people use to hack on PostgreSQL?

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2007-04-12 14:58:16
Subject: Re: autovacuum multiworkers, patch 5
Previous:From: Tom LaneDate: 2007-04-12 13:29:52
Subject: Re: [HACKERS] Fix mdsync never-ending loop problem

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