Forum OpenACS Q&A: postgresql tuning

Collapse
1: postgresql tuning
Posted by nick gaeta on 05/20/04 07:41 PM
how can I find the 10 worst performing SQL statemens.
Is there a commerical product available?
Collapse
2: Re: postgresql tuning (response to 1)
Posted by xx xx on 05/20/04 10:53 PM
https://openacs.org/forums/message-view?message_id=185281

If that is what you were looking for, please report back what you find.

Collapse
3: Re: postgresql tuning (response to 2)
Posted by Mark Aufflick on 05/24/04 06:02 PM
I posted another link to a postgres log analyzer here:

https://openacs.org/forums/message-view?message_id=185480

it seems to give you what you want. The earlier link looks more user friendly though and has better instructions.