Measuring Performance/Tuning

From: Hunter Hillegas <lists(at)lastonepicked(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Measuring Performance/Tuning
Date: 2003-02-12 00:17:58
Message-ID: BA6ED2B6.91316%lists@lastonepicked.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When watching postmaster in top, I see it go from 4% to 30% of the CPU and
back and forth, etc...

Is there an easy way to determine if I need to adjust some settings,
sort_mem, etc... to boost performance? Or trial and error?

Just curious. Looked in Bruce's book and didn't seem to find what I was
looking for.

Cheers,
Hunter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco J Reyes 2003-02-12 00:58:05 Re: Measuring Performance/Tuning
Previous Message Jan Wieck 2003-02-11 23:23:25 Re: Deleting orphan records