Re: pgsql: Binary data support improvement
Hi Matteo,
2013/7/2 Matteo Beccati <[email protected]>
> I'm talking about parameters, not results. The speedup would be only for
> inserts, not selects (which would require something that's not available
> in libpq).
>
For insert or update, binary can be inserted/updated directly.
If we do this transparently to users, we need additional select query to
system catalog to find field type.
Since pgsql is not a db access abstraction layer, adding a array parameter
that indicates which field is binary or text may be the way to go. Lack of
reverse operation would be problematic, though.
We may wait until PostgreSQL implements appropriate API.
Regards,
--
Yasuo Ohgaki
[email protected]
Thread (10 messages)