Description
PostgreSQL databases can store analytic tables in a columnar format through a foreign data wrapper. This is useful for large read-heavy datasets where scanning selected columns matters more than frequent row-by-row updates.
It is a database extension for administrators and developers. It must be enabled and configured inside PostgreSQL, and production use should be tested carefully because it changes how data is stored and queried.