insufficient permission for postgres tables in FreeRADIUS 3.x

[Arran Cudbard-Bell]

On 14 Dec 2013, at 13:24, Валерій Степанюк <varela at 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 at freeradius.org>
FreeRADIUS Development Team

FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 881 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.freeradius.org/pipermail/freeradius-devel/attachments/20131217/d4bbde40/attachment.pgp>