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.iso-8859-1.charter.com
Whole thread Raw
In response to Re: PostgreSQL as a local in-memory cache  (Pavel Stehule <pavel.stehule@gmail.com>)
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: Greg Smith
Date:
Subject: Re: Occasional giant spikes in CPU load
Next
From: Robert Haas
Date:
Subject: Re: requested shared memory size overflows size_t