| From: | Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Locking B-tree leafs immediately in exclusive mode |
| Date: | 2018-06-14 15:40:44 |
| Message-ID: | CAPpHfduUMFYUOeu-bbkZ2dJX36rWTU_tdx6TWNhF+TAgPwPbSQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Jun 14, 2018 at 6:32 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> On Thu, Jun 14, 2018 at 5:43 AM, Alexander Korotkov
> <a(dot)korotkov(at)postgrespro(dot)ru> wrote:
> > However, that doesn't
> > look like inevitable shortcoming, because we could store heap TID in
> > t_tid of pivot index tuples.
>
> But the offset doesn't have enough space for an entire TID.
Sorry, my bad. It slipped my mind that we use t_tid.ip_blkid of pivot
tuples to store downlinks :)
So, yes, additional attribute is required to store heap TID in pivot tuple.
Anyway, I'm looking forward seeing your patch posted, if even it would
be not yet perfect shape.
------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masahiko Sawada | 2018-06-14 16:19:35 | Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) |
| Previous Message | Rui DeSousa | 2018-06-14 15:39:05 | Re: Remove mention in docs that foreign keys on partitioned tables are not supported |