You are viewing a single comment's thread from:
RE: What are you building right now?
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! :)