Re: Assistance Needed: Issue with pg_upgrade and --link option

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Assistance Needed: Issue with pg_upgrade and --link option
Дата
Msg-id fed42cb3-a787-ec05-94fa-256760bf45b3@eisentraut.org
обсуждение исходный текст
Ответ на Re: Assistance Needed: Issue with pg_upgrade and --link option  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-hackers
On 28.06.23 12:46, Laurenz Albe wrote:
> On Wed, 2023-06-28 at 15:40 +0530, Pradeep Kumar wrote:
>>>> I was under the impression that the --link option would create hard links between the
>>>> old and new cluster's data files, but it appears that the entire old cluster data was
>>>> copied to the new cluster, resulting in a significant increase in the new cluster's size.
>>>
>>> Please provide some numbers, ideally
>>>
>>>    du -sk <old_data_directory> <new_data_directory>
>>
>> du -sk ~/pradeep_test/pg_upgrade_testing/postgres_11.4/master ~/pradeep_test/pg_upgrade_testing/postgres_14/new_pg
>> 11224524 /home/test/pradeep_test/pg_upgrade_testing/postgres_11.4/master
>> 41952 /home/test/pradeep_test/pg_upgrade_testing/postgres_14/new_pg
> 
> That looks fine.  The files exist only once, and the 41MB that only exist in
> the new data directory are catalog data and other stuff that is different
> on the new cluster.

Interesting, so it actually does count files with multiple hardlinks 
only once.




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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: tablecmds.c/MergeAttributes() cleanup
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bytea PL/Perl transform