Combine Row and Columnar Storage in one Table to Optimize Database Performance.
Create a single table in which recent data is stored in a row-based format while older data is stored in a columnar format.
.. We use the gdelt dataset(link is external) containing hundreds of millions of news events as a reference. This use-case will benefit greatly from using row-based storage for recent data, and columnar storage for older data, so let’s see how we will be able to do this in PostgreSQL 9.5.