I have queries that use like operators and regex patterns to determine if an ip address is internal or external (this is against a table with say 100 million distinct ip addresses).
Does the inet data type offer comparison/search performance benefits over plain text for ip addresses..