[redland-dev] A question about librdf and postgres storage

[Attilio Fiandrotti]

Dave Beckett wrote:
> Attilio Fiandrotti wrote:
> 
>>Hi
>>
>>I'm developing an application that accesses librdf thru java bindings
>>and retrives data from a postgres db.
>>
>>This is what i noticed about the number of opened connections to the pg
>>database
>>
>>world = new World();
>>world.open();
>>storage = new Storage (world, "postgresql", "test", "...");
>>model = new Model(world, storage, "");
>>
>>-> now i have 3 opened connections
>>
>>Then, When i first perform a model.getXXX() , the number of active
>>connections is permanently increased by 1, even if i take care of
>>cleaning up iterator and other similar things.
>>If i later perform another model.getXXX() the number of connections is
>>not increased anymore.
>>
>>The question is: is this expected and regular or am i doing something
>>the wrong way ?
> 
> 
> I'm guessing that like the mysql backend, the connections are cached until
> the store is closed.

ok, then i guess everything is ok: having 5-8 pgsql connections opened 
togheter is not a problem, definitely.

Attilio