table extra_data
   id integer primary key
   big_table_id integer
   large_data_seldom_used varchar(65000)

SELECT large_data_seldom_used FROM bigtable b
INNER JOIN extra_data e ON (e.big_table_id = b.id)