From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com> |
Cc: | pgsql-general general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [pgsql-general] In memory tables/databases |
Date: | 2007-07-05 17:52:38 |
Message-ID: | 468D2FE6.8080405@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
A.M. wrote:
>
> On Jul 5, 2007, at 13:20 , Andrew Sullivan wrote:
>
>> On Sun, Jul 01, 2007 at 11:11:30PM +0200, Alexander Todorov wrote:
>>> The question was is there something else that exists in PostgreSQL and
>>> will do the same job.
> Why not have a table type that writes no WAL and is truncated whenever
> postgres starts? Such a table could then be put in a ramdisk tablespace
> and there would be no transaction atomicity repercussions. Is there
> something I'm missing?
>
> Claiming that postgresql is simply the wrong tool is silly, especially
> since it is so close to having the desired behavior.
Use pg_memcache.
Sincerely,
Joshua D. Drake
P.S. I agree with you, but you are barking up a very tall tree and you
don't have a chainsaw. The fact is, global temp tables that could be
assigned a static amount of memory to use that would recycle based on
some parameter would be infinitely useful, but likely won't get anywhere.
>
> Cheers,
> M
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-07-05 18:20:25 | Re: Way to determine index bloat stats? |
Previous Message | A.M. | 2007-07-05 17:43:59 | Re: [pgsql-general] In memory tables/databases |