Re: PostgreSQL as a local in-memory cache

From: "Pierre C" <lists(at)peufeu(dot)com>
To: "jgardner(at)jonathangardner(dot)net" <jgardner(at)jonathangardner(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL as a local in-memory cache
Date: 2010-06-16 07:53:58
Message-ID: op.veduv8kqeorkce@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> 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")

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2010-06-16 08:27:00 Re: PostgreSQL as a local in-memory cache
Previous Message Pierre C 2010-06-16 07:51:14 Re: PostgreSQL as a local in-memory cache