Posts are sorted by using ORDER BY p.post_time. As far as postgres is concerned, the sorting for rows with the same post time is undefined. It apparently only depends on which row is loaded from the database backend first.

This should be changed to also sort by post_id.