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?

Reply via email to