agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Quandt Brian <quandt@eec.umr.edu>
To: postgres@postgres.Berkeley.EDU
Cc: Quandt Brian <quandt@eec.umr.edu>
Subject: performance and postgres
Date: Fri, 19 Aug 1994 10:51:25 -0500 (CDT)
Message-ID: <199408191551.KAA03823@umrgec8.eec.umr.edu> (raw)

Just curious.  What is the performance difference between
writing multiple programs to issue multiple postgres queries,
ie attaching to the database then detaching, versus writing one
program that attaches to the database does all the queries
then detaches?

The reason that Im asking is that I'd like to have people 
access postgres through things like perl scripts but I'm concerend
about the performance of using pgperl since each script will
attache then detach on exiting the perl script.  Another solution
I thought about is to have a daemon that is attached to a named pipe
that the perl scripts communicate with.  This way  the cost of
opening/closing the database is not incurred, however it does
present some problems on multiple users accessing the db, ie there
needs to be a locking mechanism on the pipe.  Any suggestions would
be helpful


Brian quandt

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: quandt@eec.umr.edu
  Subject: Re: performance and postgres
  In-Reply-To: <199408191551.KAA03823@umrgec8.eec.umr.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox