Glad to see you're still pushing ahead with the site! You've got some awesome reports in there that I use from time to time. Hopefully the migration to postgresql brings some performance enhancements. How much data are you storing at the moment anyways (out of curiousity)?
You are viewing a single comment's thread from:
Thanks! The in total I'm storing about 22GB, mainly comments/posts for the search facility. I'm not really sure how much moving to postgresql will actually improve performance now I've upgraded the server tbh. I could be storing some of the data more effectively though with better indexes anyway.
Sounds about right - chainBB uses a similar amount (23.190GB).
I think you'll see a decent increase in performance. SQLite afaik isn't the most performant DB, or at least it didn't used to be when I was experimenting with it back in the day. postgresql should at least be better at storing the used data in memory or something! :)