Received: from slim.affinityexpeditions.org ([209.209.5.3]) by postgresql.org (8.11.3/8.11.4) with SMTP id g1BK6KE13063 for ; Mon, 11 Feb 2002 15:06:20 -0500 (EST) (envelope-from ctoohey@pacbell.net) Message-Id: <200202112006.g1BK6KE13063@postgresql.org> Received: (qmail 29773 invoked from network); 11 Feb 2002 20:06:08 -0000 Received: from unknown (HELO there) (127.0.0.1) by localhost with SMTP; 11 Feb 2002 20:06:08 -0000 Content-Type: text/plain; charset="iso-8859-15" From: charlie To: pgsql-sql@postgresql.org Subject: Support for bulk reads/writes ? Date: Mon, 11 Feb 2002 12:06:08 -0800 X-Mailer: KMail [version 1.3.1] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200202/117 X-Sequence-Number: 6545 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