Operation towards very large tables takes too much time in database. To overcome this problem, Postgres introduced partitioning using pg_partman extension.
Steps to implement
1. Install extension
CREATE EXTENSION pg_partman;
2. Create table
CREATE TABLE events;
3. Create parent index table
SELECT create_parent('public.events', 'created_at', 'time', 'daily');
4. Run partitioning
SELECT run_maintenance();
Reference
https://blog.heroku.com/handling-very-large-tables-in-postgres-using-partitioning
