Eric,
Nested Loop
(cost=189.00..27359887.76 rows=607947200 width=22)
Join Filter: (outer.address = inner.address)
- Seq Scan on clients c
(cost=0.00..2074.76 rows=102176 width=11)
- Materialize
(cost=189.00..308.00 rows=11900 width=11)
- Seq Scan on
Eric Jain [EMAIL PROTECTED] writes:
http://word-to-the-wise.com/ipr.tgz is a datatype that contains
a range of IPv4 addresses, and which has the various operators to
make it GIST indexable.
Great, this looks very promising.
No cast operators between ipr and inet types.
Any way to work
Tom Lane wrote:
Eric Jain [EMAIL PROTECTED] writes:
http://word-to-the-wise.com/ipr.tgz is a datatype that contains
a range of IPv4 addresses, and which has the various operators to
make it GIST indexable.
Great, this looks very promising.
No cast operators between ipr and
On Tue, Feb 24, 2004 at 10:23:22AM -0500, Tom Lane wrote:
Eric Jain [EMAIL PROTECTED] writes:
http://word-to-the-wise.com/ipr.tgz is a datatype that contains
a range of IPv4 addresses, and which has the various operators to
make it GIST indexable.
Great, this looks very promising.
On Tue, Feb 24, 2004 at 01:07:10PM +0100, Eric Jain wrote:
http://word-to-the-wise.com/ipr.tgz is a datatype that contains
a range of IPv4 addresses, and which has the various operators to
make it GIST indexable.
Great, this looks very promising.
No cast operators between ipr and
On Tue, Feb 24, 2004 at 09:14:42AM -0800, Steve Atkins wrote:
On Tue, Feb 24, 2004 at 01:07:10PM +0100, Eric Jain wrote:
http://word-to-the-wise.com/ipr.tgz is a datatype that contains
a range of IPv4 addresses, and which has the various operators to
make it GIST indexable.
Great,
I'm trying to join two tables on an inet column, where one of the
columns may contain a subnet rather than a single host. Somehow the
operation isn't completing quite fast enough, even though neither table
is very large:
table| rows
+
clients
On , 2004-02-23 at 12:04 -0800, Josh Berkus wrote:
Eric,
Nested Loop
(cost=189.00..27359887.76 rows=607947200 width=22)
Join Filter: (outer.address = inner.address)
- Seq Scan on clients c
(cost=0.00..2074.76 rows=102176 width=11)
- Materialize