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

From Joshua D. Drake
Subject Re: PostgreSQL as a local in-memory cache
Date
Msg-id 1277408866.19443.23.camel@jd-desktop.unknown.charter.com
Whole thread Raw
In response to Re: PostgreSQL as a local in-memory cache  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: PostgreSQL as a local in-memory cache
List pgsql-performance
On Thu, 2010-06-24 at 21:14 +0200, Pavel Stehule wrote:
> 2010/6/24 Josh Berkus <josh@agliodbs.com>:
> >
> >> And I'm also planning to implement unlogged tables, which have the
> >> same contents for all sessions but are not WAL-logged (and are
> >> truncated on startup).
>
> this is similar MySQL's memory tables. Personally, I don't see any
> practical sense do same work on PostgreSQL now, when memcached exists.

Because memcache is yet another layer and increases overhead to the
application developers by adding yet another layer to work with. Non
logged tables would rock.

SELECT * FROM foo;

:D

JD




--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: PostgreSQL as a local in-memory cache
Next
From: Pavel Stehule
Date:
Subject: Re: PostgreSQL as a local in-memory cache