3 ms·
PostgreSQL has multiversion concurrency, which means it will not do update-in-place (a strategy that makes concurrency very difficult); the result is that any p
by saurik 15y ago
PostgreSQL has multiversion concurrency, which means it will not do update-in-place (a strategy that makes concurrency very difficult); the result is that any part of an individual row, such as the entire hstore/xml field (but also including any other fields with types such as integer), cannot be "incrementally updated", and must be replaced (by which I mean, having a new one written and the old one effectively garbage collected at a later time) "whole hog".