create table profiles ( profile_id serial primary key, user_id integer not null references users(user_id) ); insert into users select x from generate_series(1, 99999) as seq(x); insert into profiles select x, 100000 - x from generate_series(1, 99999) as seq(x); Select u.user_id, p.profile_id, p.user_id as profile_user_id From users u Join profiles p on u.users_id = p.user_id