Re: Questions about 2 databases. - Mailing list pgsql-performance

From PFC
Subject Re: Questions about 2 databases.
Date
Msg-id opsnh5vvs2th1vuj@localhost
Whole thread Raw
In response to Questions about 2 databases.  (jelle <jellej@pacbell.net>)
List pgsql-performance

> 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.

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Postgres on RAID5
Next
From: PFC
Date:
Subject: Re: Postgres on RAID5