My web app does lots of inserts that aren't read until a session is complete. The plan is to put the heavy insert session onto a ramdisk based pg-db and transfer the relevant data to the master pg-db upon session completion. Currently running 7.4.6.
From what you say I'd think you want to avoid making one write transaction to the main database on each page view, right ?
You could simply store the data in a file, and at the end of the session, read the file and do all the writes in one transaction.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
