From: Rodrigo Madera <rodrigo.madera@gmail.com>
To: Nörder-Tuitje, Marcus <noerder-tuitje@technology.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Inefficient escape codes.
Date: Fri, 21 Oct 2005 16:59:30 +0000
Message-ID: <3cf983d0510210959y32fdb891gff11bfbaf1943ebe@mail.gmail.com> (raw)
In-Reply-To: <16F953410A0F1346848DCB476A989CFE01D557@swtexchange2.technology.de>
References: <16F953410A0F1346848DCB476A989CFE01D557@swtexchange2.technology.de>
> I guess, You should check, if a blob field and large object access is
> suitable for you - no escaping etc, just raw binary large objects.
>
> AFAIK, PQExecParams is not the right solution for You. Refer the "Large
> object" section:
>
> "28.3.5. Writing Data to a Large Object
> The function
> int lo_write(PGconn *conn, int fd, const char *buf, size_t len);writes len
> bytes from buf to large object descriptor fd. The fd argument must have been
> returned by a previous lo_open. The number of bytes actually written is
> returned. In the event of an error, the return value is negative."
Well, I read that large objects are kept in only ONE table. No matter what,
only the LOID would be kept. I can't affor that since I hav lots of tables
(using the image-album-app analogy, imagine that we have pictures from
several cities, each one corresponding to a city, like Memphis_Photos,
Chicago_Photos, etc.).
This is one major drawback, isn't it?
Rodrigo
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rodrigo.madera@gmail.com, noerder-tuitje@technology.de
Subject: Re: Inefficient escape codes.
In-Reply-To: <3cf983d0510210959y32fdb891gff11bfbaf1943ebe@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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