On Thu, Mar 8, 2012 at 8:01 PM, Andy Colson <andy@xxxxxxxxxxxxxxx> wrote: > On 03/08/2012 01:40 PM, Stefan Keller wrote: >> >> Hi >> >> I do have a student who is interested in participating at the Google >> Summer of Code (GSoC) 2012 >> Now I have the "burden" to look for a cool project... Any ideas? >> >> -Stefan >> > > How about one of: > > 1) on disk page level compression (maybe with LZF or snappy) (maybe not page > level, any level really) > > I know toast compresses, but I believe its only one row. page level would > compress better because there is more data, and it would also decrease the > amount of IO, so it might speed up disk access. > > 2) better partitioning support. Something much more automatic. > > 3) take a nice big table, have it inserted/updated a few times a second. > Then make "select * from bigtable where indexed_field = 'somevalue'; work > 10 times faster than it does today. > > > I think there is also a wish list on the wiki somewhere. Nice ideas Those aren't projects we should be giving to summer students. I don't suppose many people could do those things in two months, let alone people with the least experience in both their career and our codebase. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
