\timing create table log (line text); insert into log (line) select repeat('a',80) from generate_series(1,1e7); copy log to '/tmp/log.raw' (format 'raw', delimiter E'\n'); copy log to '/tmp/log.csv' (format 'csv'); copy log to '/tmp/log.text' (format 'text'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.raw' (format 'raw', delimiter E'\n'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.csv' (format 'csv'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.text' (format 'text'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.raw' (format 'raw', delimiter E'\n'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.csv' (format 'csv'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.text' (format 'text'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.raw' (format 'raw', delimiter E'\n'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.csv' (format 'csv'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.text' (format 'text'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.raw' (format 'raw', delimiter E'\n'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.csv' (format 'csv'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.text' (format 'text'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.raw' (format 'raw', delimiter E'\n'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.csv' (format 'csv'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.text' (format 'text'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.raw' (format 'raw', delimiter E'\n'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.csv' (format 'csv'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.text' (format 'text'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.raw' (format 'raw', delimiter E'\n'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.csv' (format 'csv'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.text' (format 'text'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.raw' (format 'raw', delimiter E'\n'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.csv' (format 'csv'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.text' (format 'text'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.raw' (format 'raw', delimiter E'\n'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.csv' (format 'csv'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.text' (format 'text'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.raw' (format 'raw', delimiter E'\n'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.csv' (format 'csv'); truncate log; checkpoint; vacuum; copy log from '/tmp/log.text' (format 'text');