|
Hello,
I guess most of you guys heard about In Memory Database.I have a small
question regarding it.I need to create an In Memory Database for postgresql
through which I have to perform various operations on postgresql
database(queries,procedures,programs using pqxx API etc...).I didn't have any
idea of how to start and where to start this issue.Please comment on this
issue,so that it will be really helpful to me .
>>
If you have lots of memory on your system, PostgreSQL will
hold the frequently used tables in memory. So the burning question is:
What do you really want to do this for?
There are existing in memory database systems with a free
license like PostgreSQL:
FastDB:
http://www.garret.ru/databases.html
MonetDB:
http://monetdb.cwi.nl/
FastDB is an embedded, single writer – multiple reader
type solution.
MonetDB is a column oriented database, especially suitable for
database warehouse designs.
There are additional solutions found in this article:
http://en.wikipedia.org/wiki/In-memory_database
Now, I think it would be very nice to have in-memory or column
oriented tables in PostgreSQL, but that would be a heavy-duty major difficult
project.
If you are volunteering to take that on, I suspect it is going
to be harder than you think, and if you want someone else to do it, I guess
it is not on the horizon yet.
<<
|
