Re: Many to many join seems slow?

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Drew Wilson <drewmwilson(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Many to many join seems slow?
Date: 2007-05-15 14:17:23
Message-ID: 4649C0F3.2070300@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Drew Wilson wrote:
> Merge Join (cost=524224.49..732216.29 rows=92447 width=97) (actual
> time=1088.871..1351.840 rows=170759 loops=1)
> ...
> Total runtime: 1366.757 ms

It looks like the query actual runs in less than 3 seconds, but it takes
some time to fetch 170759 rows to the client.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jason Pinnix 2007-05-15 15:16:04 bitmap index and IS NULL predicate
Previous Message Drew Wilson 2007-05-15 14:11:40 Re: Many to many join seems slow?