Kaarel <kaarel@future.ee> writes:
>> No, the default is still 63, and will probably stay there.
> Isn't the SQL standard 128 chars?
Yes. We tested that a few months ago when we raised the limit from 31
to 63, and determined that there was a nontrivial additional speed and
space penalty to raising it to 128. Since nobody could muster a
real-world use case that actually required 128, we didn't go there.
But if you feel you need to check off that particular SQL-compliance
box, see NAMEDATALEN in postgres_ext.h.
regards, tom lane