We wanted to use OpenERP along with PostgreSQL database. OpenERP has a functionality to upload documents and stored in to database in binary format. Our worry is if user decides to upload to huge number of files to database.

Can PostgreSQL take care of this situation itself, or do we need to do anything specifically to scale up the database? I worry about both space as well as performance.

  • 2
    PostgreSQL limits. Don't add a bunch of version tags to your posts, we'll see it anyway. Mentioning the actual version you're running in the text is nice - preferably output of SELECT version(). How are you storing these files in the DB? As bytea, pg_largeobject (lob), other? Do you monitor your disk usage? – Craig Ringer Jan 16 '14 at 5:09
  • I think it's similar to this question: dba.stackexchange.com/questions/24034/… – ddaniel Jan 16 '14 at 8:52
  • The more important question is how much data can your SERVER handle. PostgreSQL can handle terabytes pretty well, but single connections are single threaded, and the throughput will be largely determined by the ability of your server to act as a "data pump" for such a connection than anything else. Do you have a pair of 5400RPM SATA drives for storage? OR a RAID array of 32 SSDs? And so on. – Scott Marlowe Jan 26 '14 at 4:02
  • Hi Scott, I am actually using a VPS with 1GB Ram, 48GB hard disk machine. So I have no idea. Thanks – Fayaz Jan 27 '14 at 7:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.