Not super familiar with the internals of postgres, but what sort of performance would something like this have?

  SELECT person_id
  FROM person_l
  WHERE state_id = (SELECT id FROM state_l WHERE name = 'Burgenland');