post to tag database relationship clarification?

Question

Hi Q2A experts,

I have noticed at the db level

in the posts table there is a column tags "string of tags separated by commas"

And there is a nother table posttags

So are post tags stored in the tags column or posttags table?

Is the data stored at two places for performance reasons to avoid joins?

thanks

Omar