Inet performance

[Tanya Mamedalin]

Hi -

Has anyone noticed a significant performance hit using the inet/cidr
data types? I'm debating between setting up the my database using the
12 byte inet type or 4 columns of 1-byte tinyints to represent ip
address octets.

Thanks,
Tanya


------------------------------------------->

Tanya Mamedalin
Network Engineer
Register.com
575 Eighth Avenue
New York, New York 10018

p: 212.798.9212
c: 917.817.5670

------------------------------------------->

This e-mail message, and any attachments thereto, is for the sole use of
the intended recipient(s) and may contain legally privileged and/or
confidential information. Any unauthorized review, use, disclosure or
distribution is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and permanently
delete all copies of the original message.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Vivek Khera]

>>>>> "TM" == Tanya Mamedalin <tm********@register.com> writes:

TM> Has anyone noticed a significant performance hit using the inet/cidr
TM> data types? I'm debating between setting up the my database using the

No, but then all I ever do is write them, or display them when the
whole record is pulled. Any kind of performance issue depends
entirely on how you plan to use the feature in question...
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: kh***@kciLink.com Rockville, MD [phone] x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Vivek Khera]

>>>>> "TM" == Tanya Mamedalin <tm********@register.com> writes:

TM> Has anyone noticed a significant performance hit using the inet/cidr
TM> data types? I'm debating between setting up the my database using the

No, but then all I ever do is write them, or display them when the
whole record is pulled. Any kind of performance issue depends
entirely on how you plan to use the feature in question...
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: kh***@kciLink.com Rockville, MD [phone] x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org