Storage efficiency of Postgres index column
My question is, does the presence of the index make Postgres realize it does not have to store the group_id column behind-the-scenes?


No. PostgreSQL uses heaps, not index-organised tables.