Does Postgresql have index size limits? I know in SQL server one thing that can bite you using varchar(max) is that if later you want to index it, it can fail if anything is over 900 bytes as that is the index size limit.
Its a run-time error too so the index may get created no problem then later someone tries to insert a >900 bytes value and it throws.
Its a run-time error too so the index may get created no problem then later someone tries to insert a >900 bytes value and it throws.