Hello,
I'm trying to understand for a given unlogged table of a specific size and
# of rows, if I do "alter table" on it to convert it to logged table, is
there a performance difference between 9.5, 9.6 and 10? in other words are
there specific improvements in this area that may not be available in all
Postgres versions?
Also, at a high level, what happens when the table is converted from
Unlogged to logged? Is the operation time dependent on size and number of
rows?
Thanks.