Guy Rouillier wrote:
Joshua D. Drake wrote:
External storing is useful but I prefer LO because all my data (binary
and meta) is all in the same place for management.
But if that's a big L in LO, performance and maintenance will be
negatively affected, perhaps significantly.
How?
The DBMS will
"Guy Rouillier" <[EMAIL PROTECTED]> writes:
> Joshua D. Drake wrote:
>
>> External storing is useful but I prefer LO because all my data (binary
>> and meta) is all in the same place for management.
>
> But if that's a big L in LO, performance and maintenance will be
> negatively affected, perha
Joshua D. Drake wrote:
> External storing is useful but I prefer LO because all my data (binary
> and meta) is all in the same place for management.
But if that's a big L in LO, performance and maintenance will be
negatively affected, perhaps significantly. The DBMS will have to scan
over all t
On Wed, May 18, 2005 at 02:49:40PM -0600, Ed L. wrote:
> I was following this:
>
> http://www.postgresql.org/files/documentation/books/aw_pgsql/node96.html
>
> "Because large objects use the local filesystem, users connecting
> over a network cannot use lo_import or lo_export()."
So you use lo
On Wednesday May 18 2005 2:57 pm, Joshua D. Drake wrote:
> > What api/language are you using? Is this possible to do
> > through DBI? If you don't use lo_import/lo_export, how do
> > you insert/retrieve images? Pointers to docs are welcomed!
>
> I have done it via PHP and I can definately insert
Can you or anyone share your experiences with using blobs as
opposed to bytea or storing externally? I'm particularly
interested to know if loading a large number of images is going
to crowd my DB cache?
Large Objects stream (for lack of a better term) to the client in 8k?
chunks so it typical
I was following this:
http://www.postgresql.org/files/documentation/books/aw_pgsql/node96.html
"Because large objects use the local filesystem, users connecting
over a network cannot use lo_import or lo_export()."
Confirmed using psql.
What api/language are you using? Is this possible to do thro
On Wednesday May 18 2005 2:40 pm, Joshua D. Drake wrote:
> Ed L. wrote:
> > On Wednesday May 18 2005 2:10 pm, Ed L. wrote:
> >>What are the tradeoffs of storing images as bytea vs blobs?
> >
> > Actually, I see you can't store/retrieve blobs remotely,
> > which is a non-starter.
>
> Sure you can. W
Ed L. wrote:
On Wednesday May 18 2005 2:10 pm, Ed L. wrote:
What are the tradeoffs of storing images as bytea vs blobs?
Actually, I see you can't store/retrieve blobs remotely, which is
a non-starter.
Sure you can. We do it all the time. What language are you using that
doesn't let you do it?
On Wednesday May 18 2005 2:10 pm, Ed L. wrote:
> What are the tradeoffs of storing images as bytea vs blobs?
Actually, I see you can't store/retrieve blobs remotely, which is
a non-starter. So the remaining choices seem to be bytea vs.
storing only metadata and keeping the images elsewhere (may
If I store images as blobs in pgsql, will they be loaded into the
db shared memory cache as they are retrieved?
What are the tradeoffs of storing images as bytea vs blobs?
Thanks.
Ed
---(end of broadcast)---
TIP 3: if posting/reading through Usen
11 matches
Mail list logo
