Re: [GENERAL] bytea performance issue

2007-01-25 Thread brian stone
So there is no confusion as to why my output has 10 lines that say "Error:", the pg error printf line should read: printf("Error: %s\n", PQresultErrorMessage(res)); skye brian stone <[EMAIL PROTECTED]> wrote: I have not tried profiling yet; I am no pro at that. output of "SELECT version()" P

Re: [GENERAL] bytea performance issue

2007-01-25 Thread brian stone
I have not tried profiling yet; I am no pro at that. output of "SELECT version()" PostgreSQL 8.2rc1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) This is the test program. I run it on the same machine as the postmaster. I am not sure, but I would assume that

Re: [GENERAL] bytea performance issue

2007-01-25 Thread Tom Lane
brian stone <[EMAIL PROTECTED]> writes: > I have to store binary data in a table, ranging from 512K - 1M. I am getting > very poor performance when inserting this data. > create table my_stuff (data bytea); > I then try to insert 10 1M blobs into this table using PQexecParams from C. > It takes