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.
