Re: [GENERAL] CLOB & BLOB limitations in PostgreSQL

2014-04-11 Thread Jack . O'Sullivan
Hi Andy, Thanks for getting those thoughts out so quickly. As far as points 1 and 2 go, it is definitely something to think about, but they are largely tangential to what I need to worry about at this moment. I am less concerned about "how much disk do we need to store this" than "is it even

[GENERAL] CLOB & BLOB limitations in PostgreSQL

2014-04-11 Thread Jack . O'Sullivan
I am working for a client who is interested in migrating from Oracle to Postgres. Their database is currently ~20TB in size, and is growing. The biggest table in this database is effectively a BLOB store and currently has around 1 billion rows. >From reading around Postgres, there are a couple