Re: Slow join using network address function

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Eric Jain" <Eric(dot)Jain(at)isb-sib(dot)ch>, "pgsql-performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow join using network address function
Date: 2004-02-23 20:04:18
Message-ID: 200402231204.18760.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 clients_commercial cc
> (cost=0.00..189.00 rows=11900 width=11)

To help you, we need EXPLAIN ANALYZE, not just EXPLAIN. Thanks!

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2004-02-23 20:11:17 Re: General performance questions about postgres on Apple
Previous Message andrew 2004-02-23 20:00:53 Re: JOIN order, 15K, 15K, 7MM rows