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) > ->

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: > > > is a datatype that contains > > > a range of IPv4 addresses, and which has the various operators to > > > make it GIST indexable.

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: > > 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 betw

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: > >> is a datatype that contains > >> a range of IPv4 addresses, and which has the various operators to > >> make it GIST indexable. > > > Great, this looks v

Re: [PERFORM] Slow join using network address function

2004-02-24 Thread Nick Barr
Tom Lane wrote: "Eric Jain" <[EMAIL PROTECTED]> writes: 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

Re: [PERFORM] Slow join using network address function

2004-02-24 Thread Tom Lane
"Eric Jain" <[EMAIL PROTECTED]> writes: >> 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. > An

Re: [PERFORM] Slow join using network address function

2004-02-24 Thread Eric Jain
> 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 around this, short of dumping a

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) > >-> Materi

Re: [PERFORM] Slow join using network address function

2004-02-23 Thread Steve Atkins
On Mon, Feb 23, 2004 at 12:48:02PM +0100, Eric Jain wrote: > 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: > >

[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