Horton

Re: 9.3 Pre-proposal: Range Merge Join

Jay Levitt <jay.levitt@gmail.com>

View thread
From: Jay Levitt <jay.levitt@gmail.com>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Jeff Davis <pgsql@j-davis.com>, Alexander Korotkov <aekorotkov@gmail.com>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, pgsql-hackers@postgresql.org
Date: 2012-04-16T21:52:54Z
Lists: pgsql-hackers 
Simon Riggs wrote:
> I'd like to see something along the lines of demand-created optional
> indexes, that we reclaim space/maintenance overhead on according to
> some cache management scheme. More space you have, the more of the
> important ones hang around. The rough same idea applies to
> materialised views.

+10; this sort of demand-driven optimization could be the database 
equivalent of Java's HotSpot (which accomplished the amazing task of making 
Java kinda fastish sometimes).

Jay