Re: Large Binary Objects Middleware

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Large Binary Objects Middleware
Date: 2006-04-02 14:36:17
Message-ID: e0onh1$2pms$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


""Rodrigo Madera"" <rodrigo(dot)madera(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Qingqing Zhou 2006-04-02 14:45:34 Re: Logging SQL queries to optimize them ?
Previous Message Qingqing Zhou 2006-04-02 14:33:05 Re: statistics buffer is full