8 New Oracle compatibility features in EnterpriseDB PPAS 9.2 Beta

Some of new Oracle feature included in PostgresPlus Advanced Server 9.2 beta. Most of them are charm to the product and needed if anyone has migrated from Oracle to PostgreSQL. Many more new features in the product itself, however I would like to walk-through few of them which are related to Oracle compatibility. 1. Object Type Support: In this version, member functions are supported, but not yet MAP member functions.

Continue reading →

pgmemcache vs Infinite Cache

In my recent post on pgmemcache, there were couple of questions asked which were really interesting and made me to work on it. I should thank for it :) Questions: 1. Is pgmemcache application transparent ? 2. Is there any synchronization between memcached and PostgreSQL Shared buffers ? Answer: pgmemcache(memcached) is not application transparent, you need to do changes in the application for pushing or retreiving the data from the cache.

Continue reading →