| From: | Sheer El-Showk <sheer(at)saraf(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | performance tuning |
| Date: | 2001-10-27 17:58:42 |
| Message-ID: | Pine.LNX.4.33.0110271355490.420-100000@laudanum.saraf.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Does anyone have a good reference for Postgres performance tuning. The
first thing I'm looking for is a way to determine my bottle-neck. My
system is currently running with 5-6 processes in the runqueue and 100%
cpu utilization (50% in the kernel). I'm guessing I'm cpu-bound but I'd
like to find out why (I'm doing mostly inserts, but I have a lot of
foreign keys). I know postgres has a lot of pg_stat_* tables but I'd like
to learn how to use these and other performance analysis tools.
Thanks,
Sheer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-10-27 18:50:03 | Re: On Distributions In 7.2 (Longish) |
| Previous Message | postgresql | 2001-10-27 15:45:40 | Re: Sequential sequence numbers |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keary Suska | 2001-10-27 19:00:37 | Re: performance tuning |
| Previous Message | Valdir H. Dias Leite | 2001-10-27 16:38:05 | SQL99 |