On 03.05.2017 12:57, Thomas Güttler wrote:
Am 02.05.2017 um 05:43 schrieb Jeff Janes:
No. You can certainly use PostgreSQL to store blobs. But then, you need to store the PostgreSQL data **someplace**.
If you don't store it in S3, you have to store it somewhere else.
I don't understand what you mean here. AFAIK storing blobs in PG is not recommended since it is not very efficient.
Seems like several people here disagree with this conventional wisdom.
I think what he was talking about the data itself. You have to store the bits and bytes somewhere (e.g. on S3).
I'm not sure I'd be comfortable placing my PostgreSQL data directory on an S3-based mount...
I would look at any general recommendation in this area with suspicion. Learn how different alternatives works, evaluate your needs, and make an informed decision for your specific scenario. Reading other's experiences helps with the education aspect but unless their scenario is exactly like yours you should probably refrain from directly accepting their conclusions.
David J.
