Re: Large Binary Objects Middleware - Mailing list pgsql-performance

From Qingqing Zhou
Subject Re: Large Binary Objects Middleware
Date
Msg-id e0onh1$2pms$1@news.hub.org
Whole thread Raw
In response to Large Binary Objects Middleware  ("Rodrigo Madera" <rodrigo.madera@gmail.com>)
List 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



pgsql-performance by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: statistics buffer is full
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Logging SQL queries to optimize them ?