Weird effects using BLOBs from libpq

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

Responses

Browse pgsql-general by date

  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