indices and cidr/inet type

Поиск
Список
Период
Сортировка
От Richard Welty
Тема indices and cidr/inet type
Дата
Msg-id E19k5j4-0003s2-Vg@skipper.averillpark.net
обсуждение исходный текст
Ответы Re: indices and cidr/inet type  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
in looking over the section of the users manual on indices, i see that
R-Tree indices are recommended for <<, but this advice is clearly tied to
the geometric interpretation of << ("to the left of") rather than the
network interpretation ("is contained in").

what type of index is recommended when the dominant lookup on a field is

'<networkaddress>' << ipblock

where the ipblock column is of type cidr?

thanks,
  richard
--
Richard Welty                                         rwelty@averillpark.net
Averill Park Networking                                         518-573-7592
    Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security

В списке pgsql-general по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: plPHP -- sort of an announcement.. but not commercial
Следующее
От: "Williams, Travis L, NPONS"
Дата:
Сообщение: multiple insert into's (may be NEWBIE question)