Re: SPGist "triple parity" concept doesn't work

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-11 17:58:38
Message-ID: 51B7654E.7060202@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. That
> would at least not create any performance penalty for non-concurrent
> scenarios; and even in concurrent cases, I suspect you'd have to be
> rather unlucky to get penalties as bad as the heavyweight-lock solution
> is showing.

Agree, it would be a better workaround for now. I will be able to do this at
this friday.

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/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2013-06-11 18:10:45 Re: JSON and unicode surrogate pairs
Previous Message Jon Nelson 2013-06-11 17:52:25 Re: fallocate / posix_fallocate for new WAL file creation (etc...)