Imho, the 2nd way is more normalized - you don't keep the same information (fullpath) twice. If you are afraid of join-effectivity, use some tool which imagines how is that query realized, in postgres it is

explain analyze select fullpath...
[download]

Something about database normal form:
http://www.databasejournal.com/sqletc/article.php/26861_1428511_4