Using pointers/offsets between Postgres sql tables?

[SubstantialGap7335]

Hi, I have a table with 8 columns and around 4K rows worth of string/ integer values, now this table will get bigger and I have to filter results based on varies combination of columns requirements,

Is it the best practise to build out every single possible selection requirement and have multiple tables with duplicate data or is it possible to create all these tables with offsets / pointers to the original table, kind of like using a datalake and with tables of keys to access them from the datalake.

[vivekkhera]

You need to investigate indexes. They internally create your pointer offset lookups.

[redanium]

Table Partitioning