| From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
|---|---|
| To: | Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Hash Indexes |
| Date: | 2016-08-05 11:36:13 |
| Message-ID: | CAA4eK1LkQ_Udism-Z2Dq6cUvjH3dB5FNFNnEzZBPsRjw0haFqA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Aug 4, 2016 at 8:02 PM, Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com> wrote:
> I did some basic testing of same. In that I found one issue with cursor.
>
Thanks for the testing. The reason for failure was that the patch
didn't take into account the fact that for scrolling cursors, scan can
reacquire the lock and pin on bucket buffer multiple times. I have
fixed it such that we release the pin on bucket buffers after we scan
the last overflow page in bucket. Attached patch fixes the issue for
me, let me know if you still see the issue.
--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| concurrent_hash_index_v4.patch | application/octet-stream | 100.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2016-08-05 11:51:14 | Re: Declarative partitioning |
| Previous Message | David Rowley | 2016-08-05 11:12:39 | Re: [RFC] Change the default of update_process_title to off |