This question may sound very rudimentary.
To my surprise, after several hours of searching and referring many books, I could not figure out ...
How to CREATE/MAKE SURE the below table that is created in Postgresql is STORED in Columnar format and is effective for analytical queries. We have 500 million records in this table. We never update this table.
Question is how can if its a ANALYTICAL/COLUMNAR table vs a transactional table ?
CREATE TABLE dwh.access_log
(
ts timestamp with time zone,
remote_address text,
remote_user text,
url text,
domain text,
status_code int,
body_size int,
http_referer text,
http_user_agent text
);
Thanks