Postgres Pro
Downloads
Home   >   mailing lists

Re: Many to many join seems slow? - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: Many to many join seems slow?
Date
Msg-id 4649C0F3.2070300@enterprisedb.com
Whole thread Raw
In response to Re: Many to many join seems slow?  (Drew Wilson <drewmwilson@gmail.com>)
Responses Re: Many to many join seems slow?  (Drew Wilson <drewmwilson@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Drew Wilson
Date:
Subject: Re: Many to many join seems slow?
Next
From: Jason Pinnix
Date:
Subject: bitmap index and IS NULL predicate