Yes, it won't scale well. I have used postgres exactly the way you specified in my past job and it didn't scale well after a certain point.