Best practices for Large import in empty database?

Поиск
Список
Период
Сортировка
От Daniel Begin
Тема Best practices for Large import in empty database?
Дата
Msg-id COL129-DS24174E61E56DB5BB5E51F894B80@phx.gbl
обсуждение исходный текст
Ответы Re: Best practices for Large import in empty database?
Re: Best practices for Large import in empty database?
Список pgsql-general

I am about to feed an empty database with a large import of data (the size of csv files is about 500 GB). Tables are created but I haven't added any constraints or indexes yet. I wonder whether the best practice is to add them before or after the import. Are there other good practices that would ease the import process?

 

Cheers,

Daniel

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