Performance of query from this schema
What is the PRIMARY KEY of the table?  Probably commentID is unique to each row??  If so, add PRIMARY KEY(commentID).

For WHERE postID = "...", you should add INDEX(postID).  That will make that query fast even for a billion rows.

Read about "indexes" (aka, "keys").