Re: Does anyone use in ram postgres database? - Mailing list pgsql-general

From Chris Barnes
Subject Re: Does anyone use in ram postgres database?
Date
Msg-id BLU149-W3964154899F61BF66B07D4D4230@phx.gbl
Whole thread Raw
In response to Re: Does anyone use in ram postgres database?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
 
I just looked into timesten, at 46K for perpetual licence or 10k for yearly plus support.
 
Is there anything else available? LOL
 
Chris
 
> Date: Fri, 26 Mar 2010 10:39:37 -0700
> From: pierce@hogranch.com
> To: compuguruchrisbarnes@hotmail.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Does anyone use in ram postgres database?
>
> Chris Barnes wrote:
> >
> >
> > We are testing in memory postgres database and have questions about
> > configuring the ram mount point and whether there is great gains in
> > setting it up this way? Are there any considerations for postgres?
> >
> > If you have experience, can you please give us some ideas on how you
> > have accomplished this?
> >
>
> you might look into TimesTen... Oracle bought them a couple years ago,
> they have an SQL database thats heavily optimized for memory rather than
> block oriented disk. it optionally uses a disk as a persistence backing
> store. Of course, the entire database has to fit in ram, and they
> charge proportional to database size. its extremely fast.
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


Take your contacts everywhere. Try Messenger for mobile

pgsql-general by date:

Previous
From: Justin Graf
Date:
Subject: Re: round(x) function
Next
From: Tom Lane
Date:
Subject: Re: Error 42501 permission denied for schema