Data Loading in a Multi-CPU Environment
It can be faster to use COPY instead of fastload if the load is being done in a multi-CPU environment. Copy is faster because it uses two processes and can use two CPUs, whereas fastload uses only one CPU. Use COPY if a large amount of sorting is required to load the data. If there is more than one CPU available on the system, fastload can become CPU-bound on a single CPU.
Last modified date: 08/28/2024