[SR-Users] SQL for ordered LCR rules

[Alex Balashov]

On Tue, Sep 05, 2017 at 05:26:04PM +0300, Dmitry Sinina wrote:

> Hi. You could use prefix_range indexing in postgresql for fast longest
> match lookup https://github.com/dimitri/prefixIt works pretty fast on
> millions routes for us.

+1.

-- 
Alex Balashov | Principal | Evariste Systems LLC

Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) 
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/