Re: Questions about 2 databases.

From: PFC <lists(at)boutiquenumerique(dot)com>
To: jellej(at)pacbell(dot)net, pgsql-performance(at)postgresql(dot)org
Subject: Re: Questions about 2 databases.
Date: 2005-03-12 02:15:21
Message-ID: opsnh5vvs2th1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2005-03-12 02:20:18 Re: Postgres on RAID5
Previous Message Josh Berkus 2005-03-12 01:32:10 Re: Postgres on RAID5