Specifying length of VARCHAR
In Vertica is there a benefit to frugally specifying length limits in VARCHAR columns? Does this allocate space, such that E.g.
VARCHAR(5) for ZIP codes is better than
VARCHAR? Conversely, is there a downside to specifying large values, e.g.
VARCHAR(65535) when the string length of possible values might be larger than 80 but the upper limit not known?
By contrast, I understand that in Postgres there's no advantage to specifying the length https://dba.stackexchange.com/questions/20974/should-i-add-an-arbitrary-length-limit-to-varchar-columns