Re: > 16TB worth of data question

Paul Ramsey <pramsey(at)refractions(dot)net> writes:

> Heck, is the Pg BLOB interface anything more than a cute hook into
> filesystem storage?

Yes; it's organized as a table and storage-managed the same way as
other tables.

> I've often wondered what the point of BLOBs is,
> beyond providing a single API to all the data (maybe that *is* the
> point).

That, plus when you back up the database you're backing up everything
you need, plus it's harder for the database and the 'filesystem' to
get out of sync (you can use triggers etc to make sure, and easily run
queries to make sure you don't have any dangling references).

> Is there a performance advantage?

Slight disadvantage, I should think (unless the individual-file
approach stupidly puts them all in one directory, which can be very
slow on some system).

-Doug