On Wed, 2006-09-13 at 09:13 -0700, Jeff Marder wrote: > I'm wondering what the advantages are to running Trac on Postgres > versus SQLite. Do they outweigh the added administrative overhead? Can > anyone using Postgres with Trac share any insight about their > experience? This may be answered in the wiki, but a quick search > didn't turn up anything. Any input or a link pointing me in the right > direction would be appreciated. >
We've been converted for a day now, and so far the biggest advantage is concurrency. We no longer get any "database locked" errors. The users also report that trac as a whole is quicker than it was before too. Other than that, I can't say any more due to the upgrade being so recent. My only other comment would be that if you do decide to upgrade, ensure that you tune postgresql.conf if you want decent performance. The defaults are intentionally very conservative to ensure that the server will run pretty much anywhere. > Thanks, > Jeff > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users -~----------~----~----~----~------~----~------~--~---
