top | item 46702918 (no title) snuxoll | 1 month ago That’s not at all what the child to me was saying in even a generous reading.But HOT updates are a thing, too. discuss order hn newest tomnipotent|1 month ago What do you think they were saying? I don't see any other way to read it.HOT updates write to the same tuple page and can avoid updating indexes, but it's still a write followed by marking the old tuple for deletion. snuxoll|1 month ago > Pg moves the data between positions on update?I assume they typo'd "partitions" as "positions", and thus the GP comment was the correct reply.
tomnipotent|1 month ago What do you think they were saying? I don't see any other way to read it.HOT updates write to the same tuple page and can avoid updating indexes, but it's still a write followed by marking the old tuple for deletion. snuxoll|1 month ago > Pg moves the data between positions on update?I assume they typo'd "partitions" as "positions", and thus the GP comment was the correct reply.
snuxoll|1 month ago > Pg moves the data between positions on update?I assume they typo'd "partitions" as "positions", and thus the GP comment was the correct reply.
tomnipotent|1 month ago
HOT updates write to the same tuple page and can avoid updating indexes, but it's still a write followed by marking the old tuple for deletion.
snuxoll|1 month ago
I assume they typo'd "partitions" as "positions", and thus the GP comment was the correct reply.