pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedLarge Binary Objects Middleware
2+ messages / 2 participants
[nested] [flat]
* Large Binary Objects Middleware
@ 2006-03-27 20:16 Rodrigo Madera <rodrigo.madera@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Rodrigo Madera @ 2006-03-27 20:16 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Large Binary Objects Middleware
@ 2006-04-02 14:36 Qingqing Zhou <zhouqq@cs.toronto.edu>
parent: Rodrigo Madera <rodrigo.madera@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Qingqing Zhou @ 2006-04-02 14:36 UTC (permalink / raw)
To: pgsql-performance
""Rodrigo Madera"" <rodrigo.madera@gmail.com> wrote
>
> 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?
>
IMHO, if you don't need transaction semantics, don't put these big things
into database. Instead, add a field in your table and put the link to the
big things in it.
Regards,
Qingqing
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-04-02 14:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-27 20:16 Large Binary Objects Middleware Rodrigo Madera <rodrigo.madera@gmail.com>
2006-04-02 14:36 ` Qingqing Zhou <zhouqq@cs.toronto.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox