Not having enough RAM can significantly degrade database performance. Also, gotta wonder if you have good indices on the data. As others have said, the amount

Not having enough RAM can significantly degrade database performance. Also, gotta wonder if you have good indices on the data. As others have said, the amount of data you're talking about is not very big. I regularly deal with Postgres databases that are two orders of magnitude larger, and they are lightning fast.