Re: joining two tables slow due to sequential scan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tim Jones" <TJones(at)optio(dot)com>
Cc: "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com>, "Dave Dutcher" <dave(at)tridecap(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: joining two tables slow due to sequential scan
Date: 2006-02-10 22:51:50
Message-ID: 2937.1139611910@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Tim Jones" <TJones(at)optio(dot)com> writes:
> QUERY PLAN
> 'Hash Join (cost=899.83..4384.17 rows=482 width=1350) (actual
> time=0.203..0.203 rows=0 loops=1)'
> ...
> 'Total runtime: 0.392 ms'

Hardly seems like evidence of a performance problem ...

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tim Jones 2006-02-10 22:59:03 Re: joining two tables slow due to sequential scan
Previous Message Scott Marlowe 2006-02-10 22:46:14 Re: joining two tables slow due to sequential scan