Re: Patch: Write Amplification Reduction Method (WARM)

Pavan Deolasee <pavan.deolasee@gmail.com>

From: Pavan Deolasee <pavan.deolasee@gmail.com>

To: Jaime Casanova <jaime.casanova@2ndquadrant.com>

Cc: Haribabu Kommi <kommi.haribabu@gmail.com>, Tomas Vondra <tomas.vondra@2ndquadrant.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2017-01-03T04:13:38Z

Lists: pgsql-hackers

Attachments

interesting-attrs-2.patch (application/octet-stream) patch
0001_track_root_lp_v7.patch (application/octet-stream) patch v7
0002_warm_updates_v7.patch (application/octet-stream) patch v7
(unnamed) (text/plain)

On Tue, Dec 27, 2016 at 6:51 PM, Pavan Deolasee <pavan.deolasee@gmail.com>
wrote:

>
>
> Thanks Jaime for the tests and bug reports. I'm attaching an add-on patch
> which fixes these issues for me. I'm deliberately not sending a fresh
> revision because the changes are still minor.
>
>

Per Alvaro's request in another thread, I've rebased these patches on his
patch to refactor HeapSatisfiesHOTandKeyUpdate(). I've also attached that
patch here for easy reference.

The fixes based on bug reports by Jaime are also included in this patch
set. Other than that there are not any significant changes. The patch still
disables WARM on system tables, something I would like to fix. But I've
been delaying that because it will require changes at several places since
indexes on system tables are managed separately. In addition to that, the
patch only works with btree and hash indexes. We must implement the recheck
method for other index types so as to support them.

Thanks,
Pavan

-- 
 Pavan Deolasee                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Commits

Implement SortSupport for macaddr data type
- f90d23d0c518 10.0 cited
Simplify check of modified attributes in heap_update
- 2fd8685e7fd9 10.0 landed
Remove direct uses of ItemPointer.{ip_blkid,ip_posid}
- ce96ce60ca22 10.0 landed
Fix CatalogTupleInsert/Update abstraction for case of shared indstate.
- aedd554f84bb 10.0 landed
Provide CatalogTupleDelete() as a wrapper around simple_heap_delete().
- ab02896510e2 10.0 landed
Band-aid fix for incorrect use of view options as StdRdOptions.
- e3e66d8a9813 10.0 cited
Update visibility map in the second phase of vacuum.
- fdf9e21196a6 9.3.0 cited
Avoid having two copies of the HOT-chain search logic.
- 4da99ea4231e 9.2.0 cited
Postgres95 1.01 Distribution - Virgin Sources
- d31084e9d111 7.1.1 cited