Benchmark two separate SELECTs versus one LEFT JOIN

From: Miles Keaton <mileskeaton(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Benchmark two separate SELECTs versus one LEFT JOIN
Date: 2005-01-06 02:31:49
Message-ID: 59b2d39b0501051831643e90f2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Has anyone seen a benchmark on the speed difference between:

SELECT * FROM item WHERE id=123;
and
SELECT * FROM vendor WHERE id=515;

versus:

SELECT * FROM item LEFT JOIN vendor ON item.vendor_id=vendor.id WHERE
item.id=123;

I only have a laptop here so I can't really benchmark properly.
I'm hoping maybe someone else has, or just knows which would be faster
under high traffic/quantity.

Thanks!

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message William Yu 2005-01-06 03:31:10 Re: Low Performance for big hospital server ..
Previous Message Jeffrey Tenny 2005-01-05 19:09:11 Null integer columns