How the data can be stored. Do you have historical data? If yes , then you can keep that data in archived tables or if that data is still required by business then store it in partitions monthly wise . You need to design the data storage with proper planning. Also, if you have dynamic and ever changing data and you have date records then store with respect to partitions and retain for last 3 or 6 months then move to archived tables or purge if not required .. keep track of indexes and capture long running SQL statements through pg_stat_statements extension and run explain plan to get the proper indexes created based on the output of that plan. Also, keep track of memory related parameters to check if any memory leak occurs resulting in EXCESSIVE swap space usage on OS.
That's my opinion but we have more experts here who can help us to understand more.
