| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2004-07-13 18:58:41 | Re: Query |
| Previous Message | Eduardo Vázquez Rodríguez | 2004-07-13 18:07:36 | Query |