Postgres Pro
Downloads
Home   >   mailing lists

Transactional vs. Read-only (Retrieval) database - Mailing list pgsql-general

From Samuel J. Sutjiono
Subject Transactional vs. Read-only (Retrieval) database
Date
Msg-id 003801c1e15a$c03c5450$110a010a@headquarters.wcgroup.com
Whole thread Raw
Responses Re: Transactional vs. Read-only (Retrieval) database  (Jean-Michel POURE <jm.poure@freesurf.fr>)
Re: [SQL] Transactional vs. Read-only (Retrieval) database  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-general
Tree view
I'd like to get some opinions if there are any benefits (i.e. in terms of performance) of creating two separate databases, one for transactions (insert, update, delete) and the other one is for retrieval/search (select).
 
Thanks in advance for your input.
Sam
_________________________________________________
 Expand your wireless world with Arkdom PLUS
 http://www.arkdom.com/

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: Critical performance problems on large databases
Next
From: Shaun Thomas
Date:
Subject: Re: Critical performance problems on large databases