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 36A093A408D for ; Wed, 17 Nov 2004 04:00:30 +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 05542-08 for ; Wed, 17 Nov 2004 04:00:28 +0000 (GMT) Received: from mail1.panix.com (mail1.panix.com [166.84.1.72]) by svr1.postgresql.org (Postfix) with ESMTP id B9E4E3A41D3 for ; Wed, 17 Nov 2004 04:00:28 +0000 (GMT) Received: from panix5.panix.com (panix5.panix.com [166.84.1.5]) by mail1.panix.com (Postfix) with ESMTP id 73B6A58B13 for ; Tue, 16 Nov 2004 23:00:24 -0500 (EST) Received: (from adler@localhost) by panix5.panix.com (8.11.6p3/8.8.8/PanixN1.1) id iAH40Oe16197 for pgsql-performance@postgresql.org; Tue, 16 Nov 2004 23:00:24 -0500 (EST) Date: Tue, 16 Nov 2004 23:00:24 -0500 From: Michael Adler To: pgsql-performance@postgresql.org Subject: memcached and PostgreSQL Message-ID: <20041117040024.GB8838@pobox.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/236 X-Sequence-Number: 9190 http://pugs.postgresql.org/sfpug/archives/000021.html I noticed that some of you left coasters were talking about memcached and pgsql. I'm curious to know what was discussed. In reading about memcached, it seems that many people are using it to circumvent the scalability problems of MySQL (lack of MVCC). from their site: Shouldn't the database do this? Regardless of what database you use (MS-SQL, Oracle, Postgres, MysQL-InnoDB, etc..), there's a lot of overhead in implementing ACID properties in a RDBMS, especially when disks are involved, which means queries are going to block. For databases that aren't ACID-compliant (like MySQL-MyISAM), that overhead doesn't exist, but reading threads block on the writing threads. memcached never blocks. So What does memcached offer pgsql users? It would still seem to offer the benefit of a multi-machined cache. -Mike