How to store two states of one object in database?

Question

PostgreSQL

There is an ad site, each phenomenon has a bunch of attributes depending on its category. To get online, each ad is checked by a moderator, if the user changes the ad, then it is again sent for moderation (version 2, let's say so) and the first one remains published on the site. Except duplication of tables what to store the Checked and Not checked infa what options are?

Answer 1

add
is_approved
version fields

select id, is_approved , version from board;

id | is_approved | version
-------------------------------
99 false 6
97 true 5

Answer 2

Except duplication of tables what to store the Checked and Not checked infa what options are?

1) partitioning;
2) build indexes.