You can partition your table if it got anywhere near that large (with the shiny native partitioning introduced in PostgreSQL 10).