We're running on MySQL. I don't know why you'd be seeing such a huge delay
with PostgreSQL though. Can you tell me which pages are showing delays? (Is
it all of them?)
if it's the dashboard, there are some known slowdowns when reaching large
numbers of review requests. If the diff viewer, make sure your memcached is
One thing you could try doing is going into Settings -> Logging and turn on
Profiling. Then you can visit a page with slowdowns and run with
?profiling=1. This should output to a reviewboard.prof file in the logging
directory with some details on the SQL queries and the code paths hit. If
you could pass that on to me, I could take a look.
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
VMware, Inc. - http://www.vmware.com
On Thu, Jun 10, 2010 at 11:56 AM, Stephen Gallagher <
> Well, right now 4-8s for a page refresh is just barely within the tolerable
> limits of my users. I'm trying to determine whether it makes more sense to
> migrate to MySQL (if it would be better performance)
> I was also curious whether ReviewBoard's reference implementation was
> running on postgresql and whether there were any tuning tricks I should be
> aware of.
> On 06/10/2010 02:53 PM, Jan Koprowski wrote:
>> It is probably between SQLite and PostgreSQL. But this is delay is
>> proportional to scalable. SQLite is not scalable at all, PostgreSQL is
>> most scalable free SQL database.
>> On Jun 9, 9:39 pm, Stephen Gallagher<step...@gallagherhome.com>
>>> I'm curious, what database is thehttp://reviews.reviewboard.orgserver
>>> using? We deployed on PostgreSQL recently, and I've noticed a distinct
>>> performance issue with it.
>>> I can only directly compare it to SQLite, but of course that's local
>>> access. But we went from< 1s responses on webpages to 4-8s per page
>>> when backed by Postgresql (on a private network with very little
>>> How is the performance when backed by MySQL?
> Want to help the Review Board project? Donate today at
> Happy user? Let us know at http://www.reviewboard.org/users/
> To unsubscribe from this group, send email to
> For more options, visit this group at
Want to help the Review Board project? Donate today at
Happy user? Let us know at http://www.reviewboard.org/users/
To unsubscribe from this group, send email to
For more options, visit this group at