too long Calling Station Ids
Josip Rodin
joy at entuzijast.net
Fri Dec 3 13:54:30 CET 2010
On Fri, Dec 03, 2010 at 12:12:52PM +0000, Phil Mayers wrote:
> On 03/12/10 11:51, Josip Rodin wrote:
>> I already told PostgreSQL to just stop limiting it, because AFAICT there's
>> no actual benefit.
>
> Under postgresql, there is NO performance benefit or storage space
> saving using varchar(N) or char(N) over "text". The latter should IMHO
> always be used, and we modified the SQL schema locally to do that.
I should note that the same is for varchar (character varying) with no
specified limit. IOW,
alter table radacct alter column callingstationid type varchar;
--
2. That which causes joy or happiness.
More information about the Freeradius-Users
mailing list