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.
-lcrypt
Output of - `time ./bytea_test`
Error:
Error:
Error:
Error:
Error:
Error:
Error:
Error:
Error:
Error:
real0m9.300s
user0m0.013s
sys 0m0.010s
Thanks,
skye
Tom Lane <[EMAIL PROTECTED]> wrote: brian stone writes:
> I have to store binary data in a table, ranging
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 ~10 seconds to insert the 10 records.
The tes
I think any comparison between mysql and postgresql is faulty. I have used
mysql for a very long time. As my skills matured and I was entrusted with
larger projects, I could no longer make an intelligent case to use mysql over
postgresql. I needed more from my database.
Most arguments in fav
other solutions started to look
like one.
thanks for the help,
skye
Jeff Davis <[EMAIL PROTECTED]> wrote: On Sun, 2007-01-21 at 06:55 -0800, brian
stone wrote:
> Are there any built in tools or 3rd party tools for distributing a
> postgresql database? I need an active active c
Are there any built in tools or 3rd party tools for distributing a postgresql
database? I need an active active configuration; master-master with fail over.
The project I am working needs to support a very large number of transactions
a second. It will eventually require a main frame, or some
