GSoC Proposal - Caching query results in pgpool-II

Hello<br /><br /> My name is Masanori Yamazaki. I am sending my proposal about <br />Google Summer Of Code2011. It
wouldbe nice if you could give <br />me your opinion.<br /><br /><br />・title<br /><br />Caching query results in
pgpool-II<br/><br /><br />・Synopsis<br /><br />Pgpool-II has query caching functionality using storage provided by<br
/>dedicated PostgreSQL ("system database"). This has several drawbacks<br />however. 1)it is slow because it needs to
accessdisk storage 2)it<br />does not invalidate the cache automatically.<br /><br />This proposal tries to solve these
problems.<br/><br />- To speed up the cache access, it will be placed on memory, rather<br />  than database. The
memorywill be put on shared memory or external<br />  memory services such as memcached so that the cache can be shared
by<br/>   multiple sessions. Old cache entries will be deleted by LRU manner.<br /><br />- The cache will be
invalidatedautomatically upon the timing when the<br />  relevant tables are updated. Note that this is not always
possible<br/>   because the query result might come from multiple tables, views or<br />  even functions. In this case
thecache will be invalidated by<br />  timeout(or they are not cached at all).<br /><br />- Fine tuning knobs need to
beinvented to control the cache behavior<br />   though they are not clear at this moment.<br /><br /><br />・Benefits
tothe PostgreSQL Community:<br /><br /><br />Query caching will effectively enhance the performance of PostgreSQL<br
/>andthis project will contribute to increase the number of users of<br /> PostgreSQL, who need more high performance
databasesystems.<br /><br />Note that implementing query cache in pgpool-II will bring merits not<br />only to the
latestversion of PostgreSQL but to the previous releases<br />of PostgreSQL.<br /><br /><br />・Project Schedule<br
/><br/>-April<br /> preparation <br /><br />-May 1 - May 22 <br /> write a specification<br /><br />-May 23 - June
19<br/> coding<br /><br />-June 20 - July 22<br /> test<br /><br />-July 23 - August 12<br /> complete of coding and
test,commit<br /><br /><br />・Personal Data and Biographical Information<br /><br /> Name : Masanori Yamazaki<br
/> Born: 23.1.1981<br /> School :Currently I learn contemporary philosophy, culture and literature at Waseda University
inJapan.<br /> Coding :<br />  1.About five years job as web application programer(PHP, Java).<br /> 2.I experienced
projectsused framework such as Symfony, Zend Framework, CakePHP, and Struts.<br /> 3.I am interested in OSS and like
coding.<br/><br /><br /> Regards<br />