Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL as a local in-memory cache - Mailing list pgsql-performance

From Pierre C
Subject Re: PostgreSQL as a local in-memory cache
Date
Msg-id op.veduv8kqeorkce@apollo13
Whole thread Raw
In response to Re: PostgreSQL as a local in-memory cache  ("jgardner@jonathangardner.net" <jgardner@jonathangardner.net>)
List pgsql-performance
Tree view 
> 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")

pgsql-performance by date:

Previous
From: "Pierre C"
Date:
Subject: Re: PostgreSQL as a local in-memory cache
Next
From: Greg Smith
Date:
Subject: Re: PostgreSQL as a local in-memory cache