From: | Joerg Hessdoerfer <Joerg(dot)Hessdoerfer(at)sea-gmbh(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Weird effects using BLOBs from libpq |
Date: | 2000-10-19 09:00:48 |
Message-ID: | 5.0.0.25.0.20001019105122.00a763b0@192.168.0.1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
I'm experiencing somewhat confusing results using lo_creat(), lo_open(),
lo_write()...
First effect I have noticed is that when I write more than a certain amount
of data
at once using lo_write(), my application hangs indefinitely (10K work
perfect, 100K not).
Is there a well-known limit? On what does it depend? Or is it an unexpected
feature ;-)
Next off, now that everything runs fine, it does so only when using a local
database - when
connecting over the network to our test server, i need to put in usleeps of
minimum 30ms
in between consecutive writes to the same BLOB - else writing fails and i
have to close
the DB connection to do anything useful with the DB again!
Now, that's what i call unexpected...
I'm afraid i can't give you source code right now, 'cause i'm using LabVIEW
(a graphical
programming language).
Oh, yes, the local DB is postgreSQL 7.0.2 on cygwin 1.1.4, cygipc 1.0.7.
The remote is
7.0.2 on RedHat 6.2, single CPU.
Any ideas what could cause these effects? Are they by design (shudder)?
Greetings,
Joerg
From | Date | Subject | |
---|---|---|---|
Next Message | KuroiNeko | 2000-10-19 09:05:36 | Re: How to back up large objects? |
Previous Message | Herbert Liechti | 2000-10-19 07:28:06 | updating blobs in Perl with DBD::Pg |