Benchmark two separate SELECTs versus one LEFT JOIN - Mailing list pgsql-performance

From Miles Keaton
Subject Benchmark two separate SELECTs versus one LEFT JOIN
Date
Msg-id 59b2d39b0501051831643e90f2@mail.gmail.com
Whole thread Raw
Responses Re: Benchmark two separate SELECTs versus one LEFT JOIN  (Josh Berkus <josh@agliodbs.com>)
List 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!

pgsql-performance by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Low Performance for big hospital server ..
Next
From: William Yu
Date:
Subject: Re: Low Performance for big hospital server ..