Large Binary Objects Middleware - Mailing list pgsql-performance

From Rodrigo Madera
Subject Large Binary Objects Middleware
Date
Msg-id 3cf983d0603271216x6d4a4614ye6dc48e31e8b5cb6@mail.gmail.com
Whole thread Raw
List pgsql-performance
Hello to all on the list.

I have developed a product that sits between the database and an
application that handles the storage of large binary data.

The system is fast, but I'm feeling bad as to think that I have
completely reinvented the weel on this case.

You see, the engine does just stores the large data in "containers"
that are directly on the filesystem instead of going to the database
directly (since some of this list's members told me it would make the
database really slow to store the data directly).

So now I have a huge dilema as to continue this reinvention or use
direct large objects.

The database is holding large ammounts of digital video, and I am
wanting to put these directly into the database. What performance
guidelines would you all give seeing my position today?

Thanks for all your speed-up tips,
Rodrigo

pgsql-performance by date:

Previous
From: Guido Neitzer
Date:
Subject: Re: count(*) performance
Next
From: "Mikael Carneholm"
Date:
Subject: Re: count(*) performance