Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Many to many join seems slow?

  • From: Drew Wilson <drewmwilson(at)gmail(dot)com>
  • To: Heikki Linnakangas <heikki(at)enterprisedb(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: Tue, 15 May 2007 09:45:07 -0700
  • Message-id: <A1B60119-8777-4CAF-AF80-B776751B8670(at)gmail(dot)com>
You're right. If I redirect output to /dev/null, the query completes in 1.4s. 

# \o /dev/null
# SELECT s.source_id, s.value as sourceValue, t.value as translationValue... 
...
Time: 1409.557 ms
#

That'll do for now.

Thanks,

Drew

On May 15, 2007, at 7:17 AM, Heikki Linnakangas wrote:


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
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group