pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: charlie <ctoohey@pacbell.net>
To: pgsql-sql@postgresql.org
Subject: Support for bulk reads/writes ?
Date: Mon, 11 Feb 2002 12:06:08 -0800
Message-ID: <200202112006.g1BK6KE13063@postgresql.org> (raw)

I have looked around quite a bit and could not find any information on
whether or not Postgres supports Oracle-style array usage for bulk
reading/writing of the database, e.g. bulk insert statements ?

I have a web application --- I'm acquiring/calculating various data
throughout a user's session that needs to be written to the database. I
could either just insert/update the data in Postgres as it is computed
throughout the session, or, I could keep the data in memory (using servlets,
storing the data at session scope) and then write it all to Postgres when
the session ends, if there were any advantage to doing so, i.e., if there
were a way that I could insert the data in bulk to save a bunch of trips
back and forth to the database. Otherwise, there would seem to be no
performance difference in whether the web app is executing a bunch of SQL 
statements over the course of the session vs. executing all the same 
statements at the end of the session.

The web application could experience high loads, in terms of the
number of simultaneous user sessions, which is why I'm concerned about
performance.

thanks,
charlie




view thread (3+ messages)  latest in thread

Message-ID: <200202112006.g1BK6KE13063@postgresql.org>
Permalink:  ../200202112006.g1BK6KE13063@postgresql.org/
Also on:    postgresql.org/message-id/200202112006.g1BK6KE13063@postgresql.org

 · 

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: pgsql-sql@postgresql.org
  Cc: ctoohey@pacbell.net
  Subject: Re: Support for bulk reads/writes ?
  In-Reply-To: <200202112006.g1BK6KE13063@postgresql.org>

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

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