Received: from qmsql.netservers.net (hpmail2.netservers.net [209.196.128.168]) by postgresql.org (Postfix) with SMTP id 80A874759F2 for ; Fri, 12 Apr 2002 10:57:40 -0400 (EDT) Received: (qmail 11824 invoked from network); 12 Apr 2002 14:57:44 -0000 Received: from unknown (HELO AARON) (66.26.63.73) by hpmail2.netservers.net with SMTP; 12 Apr 2002 14:57:44 -0000 Message-ID: <00ce01c1e231$929619f0$110a010a@headquarters.wcgroup.com> From: "Samuel J. Sutjiono" To: "Josh Berkus" , , References: Subject: Re: [SQL] Transactional vs. Read-only (Retrieval) database Date: Fri, 12 Apr 2002 10:51:47 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/503 X-Sequence-Number: 23218 Hi Josh, Thank you very much for your input. About managing disk access and memory, do you know how to ensure the "read-only (to do the search on)" tables(i.e. product catalog) loaded and stay loaded in memory (provided buffer size is big enough for those tables) ? Are you familiar with RAMDISK ? On different subject, do you know how to monitor the number of connections in PostgreSQL ? Regards, Samuel ----- Original Message ----- From: "Josh Berkus" To: "Samuel J. Sutjiono" ; ; Sent: Thursday, April 11, 2002 7:16 PM Subject: Re: [SQL] Transactional vs. Read-only (Retrieval) database > Sam, > > > 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). > > No. Not in Postgresql, unless you wanted to get really exotic. Also, > keep in mind that you cannot join tables from seperate databases in > postgresql. > > There are *lots* of performance advantages to be had by managing disk > access and memory carefully. But not through seperate databases. > > -Josh Berkus >