Re: pg_upgradecluster transfering only a portion of the data

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_upgradecluster transfering only a portion of the data
Дата
Msg-id 372205.1677515818@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_upgradecluster transfering only a portion of the data  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: pg_upgradecluster transfering only a portion of the data  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 2/27/23 07:44, Dávid Suchan wrote:
>> After a successful prompt finished, I checked the database and the size 
>> went from originally 20gb (in 9.6) to 700~ mb (in 14) while the disk 
>> space available shrank by about 2gb meaning that there is still the 20gb 
>> of data. I tried the entire process twice (since I had created an AWS 

> 1) How did you measure the size of the database clusters?

If it was based on something like "du", perhaps the measurement
was fooled by the fact that most of the data files will be hard-linked
between the old and new clusters.

            regards, tom lane



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_upgradecluster transfering only a portion of the data
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_upgradecluster transfering only a portion of the data