Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
hobs
on Nov 21, 2013
|
parent
|
context
|
favorite
| on:
PostgreSQL: Don't use CHAR or VARCHAR
Does pg have the concept of a clustered index? If so, for frequent inserts/updates it could actually matter.
effn
on Nov 21, 2013
[–]
It 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
on Nov 22, 2013
|
parent
[–]
Interesting, 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.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search: