Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id A4288633B17 for ; Wed, 16 Jun 2010 05:01:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 81091-04 for ; Wed, 16 Jun 2010 08:01:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from 29.mail-out.ovh.net (29.mail-out.ovh.net [87.98.216.213]) by mail.postgresql.org (Postfix) with SMTP id 5D2EB632B3F for ; Wed, 16 Jun 2010 05:01:38 -0300 (ADT) Received: (qmail 941 invoked by uid 503); 16 Jun 2010 07:59:26 -0000 Received: from b9.ovh.net (HELO mail644.ha.ovh.net) (213.186.33.59) by 29.mail-out.ovh.net with SMTP; 16 Jun 2010 07:59:26 -0000 Received: from b0.ovh.net (HELO queueout) (213.186.33.50) by b0.ovh.net with SMTP; 16 Jun 2010 09:54:57 +0200 Received: from par69-8-88-161-102-87.fbx.proxad.net (HELO apollo13) (lists%peufeu.com@88.161.102.87) by ns0.ovh.net with SMTP; 16 Jun 2010 09:54:56 +0200 Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes In-Reply-To: <4634b12c-749f-4605-9d95-121b8e2bd9e4@k17g2000pro.googlegroups.com> References: <87bpbcpabg.fsf@cbbrowne-laptop.afilias-int.info> <4C17A417.2040600@noao.edu> <87ocfcnqmk.fsf@cbbrowne-laptop.afilias-int.info> <4C180A3B.7090905@agliodbs.com> <4634b12c-749f-4605-9d95-121b8e2bd9e4@k17g2000pro.googlegroups.com> Subject: Re: PostgreSQL as a local in-memory cache To: "jgardner@jonathangardner.net" , pgsql-performance@postgresql.org Date: Wed, 16 Jun 2010 09:53:58 +0200 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: "Pierre C" Message-ID: User-Agent: Opera Mail/10.10 (Linux) X-Ovh-Tracer-Id: 9462062818197374553 X-Ovh-Remote: 88.161.102.87 (par69-8-88-161-102-87.fbx.proxad.net) X-Ovh-Local: 213.186.33.20 (ns0.ovh.net) X-Spam-Check: DONE|U 0.5/N X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_40=-0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/281 X-Sequence-Number: 39137 > Have you tried connecting using a UNIX socket instead of a TCP socket on > localhost ? On such very short queries, the TCP overhead is significant. Actually UNIX sockets are the default for psycopg2, had forgotten that. I get 7400 using UNIX sockets and 3000 using TCP (host="localhost")