| From: | "Francisco Figueiredo Jr(dot)" <francisco(at)npgsql(dot)org> |
|---|---|
| To: | Howard Cole <howardnews(at)selestial(dot)com> |
| Cc: | PgSql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to convert ByteA to Large Objects |
| Date: | 2009-01-23 12:34:01 |
| Message-ID: | 438d02260901230434k2945c52dmc70f517e7199f743@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jan 23, 2009 at 10:08 AM, Howard Cole <howardnews(at)selestial(dot)com> wrote:
> Hi All,
>
Hi, Howard!
> Is there some nice SQL I can use to convert a BYTEA field into large
> objects?
>
> I am having some memory problems handling bytea parameters in Npgsql -
> getting out of memory errors. From reading various posts on this I see that
> bytea's can consume much more memory than the size of the object so I am
> going to convert these bytea's to large objects so I can chunk the data.
>
About the memory issue of Npgsql, did you try to use a prepared
statement for this? We have some performance improvements when
handling bytea values but only when the NpgsqlCommand.Prepare() method
is called.
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://fxjr.blogspot.com
http://www.npgsql.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Osvaldo Kussama | 2009-01-23 13:21:44 | Resp.: Using null or not null in function arguments |
| Previous Message | Igor Katson | 2009-01-23 12:33:03 | Re: Using null or not null in function arguments |