3 ms·
Does pg have the concept of a clustered index? If so, for frequent inserts/updates it could actually matter.
by hobs 13y ago
Does pg have the concept of a clustered index? If so, for frequent inserts/updates it could actually matter.
- effn 13y agoIt has a index clustering operation but this is a one-time operation that will not affect further inserts/updates. But it shouldn't matter, the implicit constraint on a VARCHAR(n) does not affect indexing.
- hobs 13y agoInteresting, I was just thinking about a variable width item on the disk expanding or contracting, and if it had to be arranged in a serial physical order it would (necessarily) be forced to move the other bits if it wasn't inserted at the end.