| From: | Shankar K <shan0075(at)yahoo(dot)com> |
|---|---|
| To: | performance(at)postgresql(dot)org |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | database running slow |
| Date: | 2003-05-12 18:55:11 |
| Message-ID: | 20030512185511.95439.qmail@web21102.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
hi there,
I'm looking for some advice here to troubleshoot
performance issues as and when i get reports of
'database running slow'
Since our application involves high inserts/deletes,
we vacuum/analyze major tables thrice a day. Apart
from this
1. how to identify run-away sql backends
2. find out the bad sqls thats causing trouble
and what would one do to quickly identify the real
cause of performance issues.
please advice.
Shankar
sorry to crosspost in both admin/performance list.
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Naomi Walker | 2003-05-12 19:46:43 | Re: No flamefest please, MySQL vs. PostgreSQL AGAIN |
| Previous Message | Robert Treat | 2003-05-12 18:21:21 | Re: No flamefest please, MySQL vs. PostgreSQL AGAIN |