Subject: Re: PostgreSQL as a local in-memory cache
From: "Joshua D. Drake" <jd@commandprompt.com>
Reply-To: jd@commandprompt.com
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Josh Berkus <josh@agliodbs.com>,
	postgres performance list <pgsql-performance@postgresql.org>
In-Reply-To: <AANLkTikH3xhfGlxAdA42isKeHw4dcArnDIWX9iFMgHWx@mail.gmail.com>
References: <cb0fb58c-9134-4314-a1d0-08fc39f911a6@40g2000pry.googlegroups.com>
	<18287446-8677-46d6-a581-c4777f60ebda@40g2000pry.googlegroups.com>
	<4C1A5B81.8050908@agliodbs.com> <m2typ18ow0.fsf@hi-media.com>
	<op.vegnqzoxeorkce@apollo13>
	<alpine.DEB.2.00.1006181002360.2534@aragorn.flymine.org>
	<op.veho55mieorkce@apollo13> <4C1BDD40.9030806@agliodbs.com>
	<AANLkTin96FJbBv3kjGwjPKU-K1yAP2AHasAqrLokPqMv@mail.gmail.com>
	<AANLkTilDl2awfFVG7MCRIriToXCurxK_l9vYDhJBdV-W@mail.gmail.com>
	<4C23AA6C.60505@agliodbs.com>
	<AANLkTikH3xhfGlxAdA42isKeHw4dcArnDIWX9iFMgHWx@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Organization: Command Prompt, Inc.
Date: Thu, 24 Jun 2010 12:47:46 -0700
Message-ID: <1277408866.19443.23.camel@jd-desktop.unknown.charter.com>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

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