PostgreSQL Performance issues

From: "Werner vd Merwe" <werner(at)saicom(dot)co(dot)za>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: PostgreSQL Performance issues
Date: 2004-07-13 08:54:02
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAUwQqaqKa8EeTFMxLtmNJY8KAAAAQAAAAG0m5ptZE9EGaOu95oRsI3AEAAAAA@saicom.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Good day,

I hope you guys can help me, I went through the archives and spend some time
Googling, and I think my biggest problem is not really understanding all the
terms.
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.

I will gladly post our conf files if that might help.

Many thanks in advance.

Regards
Werner vd Merwe

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2004-07-13 11:43:01 Re: Weird join...
Previous Message Barry Gribben 2004-07-13 08:17:06 getting info out of a dump from postgresql