Re: [GENERAL] appropriate column for storing ipv4 address

Поиск
Список
Период
Сортировка
От Emre Hasegeli
Тема Re: [GENERAL] appropriate column for storing ipv4 address
Дата
Msg-id CAE2gYzxnTyB0qqnuadXtosObimxq8G4JxJA3B7Jy0OwKr_VH6g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] appropriate column for storing ipv4 address  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Список pgsql-general
> Maybe it will be useful for you! Or maybe there is already some built-in way
> to treat cidr columns like ranges?

There is GiST operator class since version 9.4 and SP-GiST operator
class on version 9.6:

CREATE INDEX ON tracked_ip_address USING gist (ip_address inet_ops);

CREATE INDEX ON tracked_ip_address USING spgist (ip_address);

Performance would change depending on the dataset.  I am more
confident from SP-GiST one.


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

Предыдущее
От: Neslisah Demirci
Дата:
Сообщение: Ynt: [GENERAL] column "waiting" does not exist
Следующее
От: subash
Дата:
Сообщение: Re: [GENERAL] Setup pgpool-II with streaming replication