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 |
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 |