On 14 Dec 2013, at 13:24, Валерій Степанюк <varela@uar.net> wrote:
And maybe slower... Tip: There is no performance difference among these three types, apart from increased storage space when using the blank-padded type, and a *few extra CPU cycles to check the length* when storing into a length-constrained column.
http://www.postgresql.org/docs/current/static/datatype-character.html
I found a comparison that indicated text was slightly faster, but not significantly so. Anyway, the overhead of changing the schema on a live server is enough to justify removing all the varchars (except the ones on op, as were unlikely to ever have len(op) > 2). -Arran Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2