On Mon, Jun 10, 2019 at 5:26 PM Tom Lane wrote:
>
> Kuntal Ghosh writes:
> >> 2. If we only support "Read Committed" isolation level, is there a safe
> >> way to not index such data?
>
> > I can't think of a case where the RECENTLY_DELETED tuple needs to be
> > indexed in "Read Committed" cas
Kuntal Ghosh writes:
>> 2. If we only support "Read Committed" isolation level, is there a safe
>> way to not index such data?
> I can't think of a case where the RECENTLY_DELETED tuple needs to be
> indexed in "Read Committed" case.
I think you're making dangerously optimistic assumptions a
Thanks! Appreciate it for your time!
On Mon, Jun 10, 2019 at 5:34 PM Kuntal Ghosh
wrote:
> On Mon, Jun 10, 2019 at 2:12 PM Alex wrote:
> > On Mon, Jun 10, 2019 at 4:10 PM Kuntal Ghosh
> wrote:
> >> I think what I'm trying to say is different.
> >>
> >> For my case, the sequence is as following
On Mon, Jun 10, 2019 at 2:12 PM Alex wrote:
> On Mon, Jun 10, 2019 at 4:10 PM Kuntal Ghosh
> wrote:
>> I think what I'm trying to say is different.
>>
>> For my case, the sequence is as following:
>> 1. Transaction A has deleted a tuple, say t1 and got committed.
>> 2. Index A has been created s
On Mon, Jun 10, 2019 at 4:10 PM Kuntal Ghosh
wrote:
> On Mon, Jun 10, 2019 at 1:30 PM Alex wrote:
> >
> >
> >
> > On Mon, Jun 10, 2019 at 3:28 PM Kuntal Ghosh
> wrote:
> >>
> >> On Mon, Jun 10, 2019 at 12:15 PM Alex wrote:
> >>>
> >>> HEAPTUPLE_RECENTLY_DEAD, /* tuple is dead, but not deletab
On Mon, Jun 10, 2019 at 1:30 PM Alex wrote:
>
>
>
> On Mon, Jun 10, 2019 at 3:28 PM Kuntal Ghosh
> wrote:
>>
>> On Mon, Jun 10, 2019 at 12:15 PM Alex wrote:
>>>
>>> HEAPTUPLE_RECENTLY_DEAD, /* tuple is dead, but not deletable yet */
>>>
>>> It is a tuple which has been deleted AND committed b
On Mon, Jun 10, 2019 at 3:28 PM Kuntal Ghosh
wrote:
> On Mon, Jun 10, 2019 at 12:15 PM Alex wrote:
>
>> HEAPTUPLE_RECENTLY_DEAD, /* tuple is dead, but not deletable yet */
>>
>> It is a tuple which has been deleted AND committed but before the delete
>> there is a transaction started but not c
On Mon, Jun 10, 2019 at 12:15 PM Alex wrote:
> HEAPTUPLE_RECENTLY_DEAD, /* tuple is dead, but not deletable yet */
>
> It is a tuple which has been deleted AND committed but before the delete
> there is a transaction started but not committed. Let call this transaction
> as Transaction A.
>
> i
HEAPTUPLE_RECENTLY_DEAD, /* tuple is dead, but not deletable yet */
It is a tuple which has been deleted AND committed but before the delete
there is a transaction started but not committed. Let call this transaction
as Transaction A.
if we create index on this time, Let's call this index as In
