New answers tagged

0

A single "fat" table will be more efficient than joining 10 separate tables. While the disk IO will be the same in principle, a view will need to perform 9 joins - essentially 9 large sort/merge operations. Materialized views (https://www.postgresql.org/docs/14/sql-creatematerializedview.html) makes it easy to separate the physical layout of the '...


Top 50 recent answers are included