X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2B1CC563AB for ; Mon, 14 Mar 2005 10:43:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62865-07 for ; Mon, 14 Mar 2005 10:43:53 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8E92D5639E for ; Mon, 14 Mar 2005 10:43:52 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id A611730941; Mon, 14 Mar 2005 11:43:54 +0100 (MET) From: Mirko Zeibig X-Newsgroups: pgsql.performance Subject: Re: Questions about 2 databases. Date: Mon, 14 Mar 2005 11:43:52 +0100 Lines: 17 Message-ID: <42356AE8.8080907@zeibig.net> References: <6.2.0.14.0.20050311155221.041aa528@pop.interactivemediafactory.net> <5055.1110573222@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en In-Reply-To: To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/407 X-Sequence-Number: 11112 jelle wrote: > The insert heavy sessions average 175 page hits generating XML, 1000 > insert/updates which comprise 90% of the insert/update load, of which > 200 inserts need to be transferred to the master db. The other > sessions are read/cache bound. I hoping to get a speed-up from moving > the temporary stuff off the master db and using 1 transaction > instead of 175 to the disk based master db. Just a thought: Wouldn't it be sufficient to have the "temporary", fast session-table in a RAM-disk? I suspect you could do this rather easily using a TABLESPACE. All the indices could be in this TABLESPACE as well (at least after having a quick look at the short help for CREATE TABLE and assuming you are using PostgreSQL >= 8.0). Regards Mirko