Horton

Re: Compressed TOAST Slicing

Regina Obe <r@pcorp.us>

View thread
From: Regina Obe <r@pcorp.us>
To: pgsql-hackers@lists.postgresql.org
Cc: Paul Ramsey <pramsey@cleverelephant.ca>
Date: 2019-03-11T20:38:56Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add support for partial TOAST decompression

  2. Remove remaining hard-wired OID references in the initial catalog data.

  3. Rephrase references to "time qualification".

The following review has been posted through the commitfest application:
make installcheck-world:  tested, passed
Implements feature:       tested, passed
Spec compliant:           tested, passed
Documentation:            not tested

No need for documentation as this is a performance improvement patch

I tested on windows mingw64 (as of a week ago) and confirmed the patch applies cleanly and significantly faster for left, substr tests than head.