Question about unlogged to logged conversion

Поиск
Список
Период
Сортировка
От Bhavin Gandhi
Тема Question about unlogged to logged conversion
Дата
Msg-id CAPRu3+kryziCtrOt9Vv+xu=BTu6xhebAZVoX00LTpQ5Y8k25MQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Question about unlogged to logged conversion
Список pgsql-general
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Ipv6 address stored differently while using Inet type
Следующее
От: Ravi Krishna
Дата:
Сообщение: Re: Question about unlogged to logged conversion