On Thu, 2009-01-22 at 14:52 +0200, Heikki Linnakangas wrote:
> Oleg Bartunov wrote:
> > as I understand, there are already plans to utilize this feature. If so,
> > we need to be more attentive by now.
>
> Is there? If I understood Simon correctly in the last paragraphs of
> these emails:
>
> http://archives.postgresql.org/message-id/1221470800.3913.1229.camel@ebony.2ndQuadrant
> http://archives.postgresql.org/message-id/1221555881.3913.1761.camel@ebony.2ndQuadrant
>
> he has no immediate use for this.
Immediate use cases for me would be
* ability to filter WAL records based on database or relation
* ability to recover quickly from various types of bug, for example if
new freespace code caused a corruption we would be able to sidestep it
and get the database up again quickly without doing resetxlog and losing
data.
Medium term
* bit map indexes
But this isn't just for me...
-- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support