Programming, Sql, Postgresql, Performance, Data Engineering.
urls, pages, duration urls: Since we’d like to avoid duplication of extremely large url strings across the table, we normalize it in a dedicated table. Also notice that we already have all of our tables partitioned by account_id. So there is no possible scenario of one large account overwhelming