Simulation output using libpq

Started by C Gover 22 years ago2 messagesgeneral
Jump to latest
#1C G
csgcsg39@hotmail.com

Dear All,

I have some c code that writes results directly to a file as they're
produced during a simulation. I want to modify the code to write
directly to a postgres database using libpq. I think I could open a
connection and insert into the database with a transaction, commiting at
the end of the simulation. One problem with this approach is that if I
have a lot of simultaneous simulations running I may run into problems
with exceeding the maximum number of connections allowed. I would
welcome any advice

Many thanks

Colin

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger

#2Ben
bench@silentmedia.com
In reply to: C G (#1)
Re: Simulation output using libpq

Sorry, what's to keep you from increasing the max number of connections?

On Thu, 8 Jan 2004, C G wrote:

Show quoted text

Dear All,

I have some c code that writes results directly to a file as they're
produced during a simulation. I want to modify the code to write
directly to a postgres database using libpq. I think I could open a
connection and insert into the database with a transaction, commiting at
the end of the simulation. One problem with this approach is that if I
have a lot of simultaneous simulations running I may run into problems
with exceeding the maximum number of connections allowed. I would
welcome any advice

Many thanks

Colin

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly