logoalt Hacker News

edmundsautotoday at 3:02 AM1 replyview on HN

Pg moves the data between positions on update?


Replies

bandramitoday at 3:51 AM

If you are updating the parent table and the partition key is correctly defined, then an update that puts a row in a different partition is translated into a delete on the original child table and an insert on the new child table, since v11 IIRC. But this can lead to some weird results if you're using multiple inheritance so, well, don't.

show 1 reply