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 3FEAF5289B for ; Mon, 6 Jun 2005 15:55:05 -0300 (ADT) 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 71570-04 for ; Mon, 6 Jun 2005 18:54:55 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id E933152864 for ; Mon, 6 Jun 2005 15:54:54 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 9029230952; Mon, 6 Jun 2005 20:51:11 +0200 (MET DST) From: Ron Mayer X-Newsgroups: pgsql.performance Subject: Re: Need help to decide Mysql vs Postgres Date: Mon, 06 Jun 2005 12:02:27 -0700 Organization: Hub.Org Networking Services Lines: 20 Message-ID: <42A49DC3.1030800@cheapcomplexdevices.com> References: <0C072E7CC947D511AC9600A0CC7341200256CF37@xeon400.tagaudit.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Christopher Browne User-Agent: Mozilla Thunderbird 1.0 (Windows/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-Archive-Number: 200506/131 X-Sequence-Number: 12768 Christopher Browne wrote: > > There is a common "use case" where MySQL(tm) ... > > select * from some_table where id='some primary key value'; > > If your usage patterns differ from that... However this is a quite common use-case; and I wonder what the best practices for postgresql is for applications like that. I'm guessing the answer is PGMemcache? (http://people.freebsd.org/~seanc/pgmemcache/pgmemcache.pdf) ... with triggers and listen/notify to manage deletes&updates and tweaks to the application code to look to memcached for those primary_key=constant queries? If that is the answer, I'm curious if anyone's benchmarked or even has qualitative "yeah, feels very fast" results for such an application for the common mysql use case.