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

Re: PostgreSQL Performance issues

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL Performance issues
Date: 2004-07-13 18:23:35
Message-ID: 5.2.1.1.0.20040713142004.030806d0@pop6.sympatico.ca (view raw or flat)
Thread:
Lists: pgsql-novice
At 04:54 AM 7/13/04, Werner vd Merwe wrote:
>I would love some help on performance tuning our PG box, some of our 
>queries takes a very long time to complete.
>
>My request is maybe more one of looking for a nice profiling system that 
>can eg. Graph available buffers vs used buffers, same with memory etc etc, 
>to try and find the bottleneck in our system and also for pro-active 
>upgrades where needed.


Have you checked to see if the speed of the slow running queries can be 
improved by rewriting the SQL?  If your problem is poorly written queries, 
then analyzing buffers and memory isn't going to help.

Frank


pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2004-07-13 18:58:41
Subject: Re: Query
Previous:From: Eduardo Vázquez RodríguezDate: 2004-07-13 18:07:36
Subject: Query

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