title: PostgreSQL - INNER JOIN vs WHERE, which one will perform better?
body: <p>I've just made a quick search through the web but couldn't find exactly what I'm looking for.</p>
  
  <p>How much efficient an <strong>INNER JOIN</strong> is comparing to a regular <strong>WHERE</strong> statement?</p>
  
  <p>I have a couple of queries in PostgreSQL that need to use some tables (say four or five) "linked" together by key/foreign key conditions. To implement those queries I'm using the <strong>WHERE</strong> clause to join all the required tables.</p>
  
  <p>I wonder if any performance gains will bd achieved if I re-write those queries with the <strong>INNER JOIN</strong> clause (instead of a WHERE clause).</p>