Synchronized Scan patch

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Synchronized Scan patch
Date: 2006-12-10 21:15:40
Message-ID: 457C78FC.3060601@j-davis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

This is the Synchronized Scan patch.

This patch only implements the simplest Synchronized Scan features; I
removed some of the other features for simplicity of testing.

This patch:
(1) allocates shared memory to store a table of (relation oid,
blocknumber) pairs.
(2) When fetching a new page in a scan, it hashes the Oid of the
relation and stores a hint entry in the shared memory table
(2) When starting a new scan, it reads the shared memory table for the
hint and starts the scan at that location (which is, hopefully, near an
already-existing scan).

This isn't complete. I still plan to add some features and do a lot of
testing, depending on feedback. I am posting it here so that anyone can
test it, and so when I show results I can refer to this specific patch.

Regards,
Jeff Davis

Attachment Content-Type Size
sync-scan.diff text/plain 10.9 KB

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-12-10 22:18:02 Re: 8.2.0 pdf
Previous Message Peter Eisentraut 2006-12-10 20:47:22 Re: 8.2.0 pdf