Hacker News new | ask | show | jobs
by snuxoll 146 days 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.

1 comments

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.

> 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.