Robert Haas: PostgreSQL as an In-Memory Only Database

Robert Haas Chief Architect, Database Server @ EnterpriseDB, PostgreSQL Major Contributor and Committer corrects IE6 width calculation google_ad_section_start(name=default) Thursday, June 24, 2010 There's been some recent, interesting discussion on the pgsql-performance mailing list on using PostgreSQL as an in-memory only database. In other words, you basically want to use it as a cache, similar to the way that you would use memcached or a NoSQL solution, but with a lot more features. If you're interested in doing this, you'll need to configure the system so that you have a convenient, automatic way erase the database cluster and reinitialize it (using initdb) after an operating system crash. Per discussion on the mail...

Linked on 2014-10-17 18:56:47 | Similar Links