Saturday, December 1, 2012

Patch for backend speed up for OLAP style workloads for PostgreSQL

A patch that gives speed up upto 25% in the backend for workloads that involve a lot of data being touched by the same transaction.The patch tries to mitigate the cost of I/O in this case by trying to mitigate the I/O.It involves maintaining a cache that can be used for determining the commit status of the transaction that last touched a tuple in cases of workloads as described above.

The idea belongs to my mentor,Merlin Moncure.My work is a simpler implementation of the idea,simpler as compared to Baba(I call Merlin as Baba)'s implementation.

The patch is under review.Thanks a ton Amit Kapila and Hari Babu.

More on it soon.

Peace,

Atri

No comments:

Post a Comment