Forum OpenACS Development: Re: Slow queries on Bug-Tracker. Some SQL Tunning

Collapse
10: Re: Slow queries on Bug-Tracker. Some SQL Tunning (response to 1)
Posted by Dave Bauer on 03/22/10 12:44 PM
Here is an interesting post about statistics, you almost definitely need to tune this on a database that large (based on the content of the post, not my experience.)

http://it.toolbox.com/blogs/database-soup/selectively-setting-statistics-sample-size-37565?rss=1

Collapse
11: Re: Slow queries on Bug-Tracker. Some SQL Tunning (response to 10)
Posted by Eduardo Santos on 03/22/10 12:55 PM
Hi Dave,

Thank you very much for your tips. PostgreSQL really have some issues that I didn't know about. I was thinking that the optimizer was not taking the best way for this query, but it's very difficult to find this out.

I'm out of access to the database right now, but as soon as I can I'll do this tuning and post the results back here.

Thank you very much again.