I like this proposal. This would bring big benefit to both the
PostgreSQL and the pgpool project.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to