| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, pgsql-hackers(at)postgreSQL(dot)org, hailong(dot)li(at)qunar(dot)com |
| Subject: | Re: SPGist "triple parity" concept doesn't work |
| Date: | 2013-06-14 12:15:08 |
| Message-ID: | 51BB094C.2020209@sigaev.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Anyway I now think that we might be better off with the other idea of
> abandoning an insertion and retrying if we get a lock conflict.
done, look at the patch.
I was faced with the fact that my mail is considered spam by postgresql.org, so
I repeat some hthoughts from previous mail:
I considered the idea to forbid placement of child on the same page as parent,
but this implementation a) could significantly increase size of index, b)
doesn't solve Greg's point.
We definetly need new idea of locking protocol and I'll return to this problem
at autumn (sorry, I havn't time in summer to do this research).
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
| Attachment | Content-Type | Size |
|---|---|---|
| spgist_deadlock-1.patch.gz | application/x-tar | 1.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2013-06-14 12:34:10 | Re: [PATCH] Add transforms feature |
| Previous Message | Amit Kapila | 2013-06-14 12:03:47 | Issue with PGC_BACKEND parameters |