X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D6745D1B51E for ; Fri, 24 Oct 2003 20:50:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 67871-04 for ; Fri, 24 Oct 2003 17:49:53 -0300 (ADT) Received: from cmailg2.svr.pol.co.uk (cmailg2.svr.pol.co.uk [195.92.195.172]) by svr1.postgresql.org (Postfix) with ESMTP id AD8A8D1B525 for ; Fri, 24 Oct 2003 17:49:50 -0300 (ADT) Received: from user-784.wfd20.dsl.pol.co.uk ([81.79.115.16] helo=rj) by cmailg2.svr.pol.co.uk with esmtp (Exim 4.14) id 1AD8sa-0003Pu-57 for pgsql-performance@postgresql.org; Fri, 24 Oct 2003 21:49:52 +0100 From: Richard Jones Reply-To: rj@last.fm Organization: Last.fm Ltd. To: Subject: Memcache Date: Fri, 24 Oct 2003 22:06:10 +0100 User-Agent: KMail/1.5.4 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200310242206.10911.rj@last.fm> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/632 X-Sequence-Number: 4380 Just thought i'd mention that on top of optimising postgres as much as possible, don't forget how much something like memcached can do for you http://www.danga.com/memcached/ we use it on www.last.fm - most pages only take one or two database hits, compared with 30 to 40 when memcache is turned off. Rich.