Re: [PERFORM] Slow join using network address function

2004-06-07 Thread Josh Berkus
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

Re: [PERFORM] Slow join using network address function

2004-02-24 Thread Tom Lane
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

Re: [PERFORM] Slow join using network address function

2004-02-24 Thread Nick Barr
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

Re: [PERFORM] Slow join using network address function

2004-02-24 Thread Steve Atkins
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.

Re: [PERFORM] Slow join using network address function

2004-02-24 Thread Steve Atkins
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

Re: [PERFORM] Slow join using network address function

2004-02-24 Thread Steve Atkins
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,

[PERFORM] Slow join using network address function

2004-02-23 Thread Eric Jain
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

Re: [PERFORM] Slow join using network address function

2004-02-23 Thread Markus Bertheau
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