Re: Does anyone use in ram postgres database?

From: Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com>
To: <pierce(at)hogranch(dot)com>
Cc: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Does anyone use in ram postgres database?
Date: 2010-03-26 17:51:55
Message-ID: BLU149-W3964154899F61BF66B07D4D4230@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hogranch(dot)com
> To: compuguruchrisbarnes(at)hotmail(dot)com
> CC: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

_________________________________________________________________
Live connected with Messenger on your phone
http://go.microsoft.com/?linkid=9712958

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-03-26 18:19:09 Re: Error 42501 permission denied for schema
Previous Message Justin Graf 2010-03-26 17:44:26 Re: round(x) function