Postgres Pro
Downloads
Home   >   mailing lists

Re: joining two tables slow due to sequential scan - Mailing list pgsql-performance

From Tom Lane
Subject Re: joining two tables slow due to sequential scan
Date
Msg-id 2937.1139611910@sss.pgh.pa.us
Whole thread Raw
In response to Re: joining two tables slow due to sequential scan  ("Tim Jones" <TJones@optio.com>)
List pgsql-performance
Tree view 
"Tim Jones" <TJones@optio.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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: joining two tables slow due to sequential scan
Next
From: "Tim Jones"
Date:
Subject: Re: joining two tables slow due to sequential scan