much for COPY itself, so this advice is only useful when you are using one or both of the above techniques. 13.4.6. Increase checkpoint_segments Temporarily increasing the checkpoint_segments configuration data-only dump, it is up to you to drop and recreate indexes and foreign keys if you wish to use those techniques. It’s still useful to increase checkpoint_segments while loading the data, but don’t bother increasing readline and readline-devel packages, if those are separate in your distribution. • The zlib compression library will be used by default. If you don’t want to use it then you must spec- ify the --without-zlib

of partitions are likely to increase query planning time considerably. Partitioning using these techniques will work well with up to perhaps a hundred partitions; don’t try to use many thousands of partitions much for COPY itself, so this advice is only useful when you are using one or both of the above techniques. 14.4.6. Increase checkpoint_segments Temporarily increasing the checkpoint_segments configuration data-only dump, it is up to you to drop and recreate indexes and foreign keys if you wish to use those techniques. It’s still useful to increase checkpoint_segments while loading the data, but don’t bother increasing

much for COPY itself, so this advice is only useful when you are using one or both of the above techniques. 13.4.6. Increase checkpoint_segments Temporarily increasing the checkpoint_segments configuration data-only dump, it is up to you to drop and recreate indexes and foreign keys if you wish to use those techniques. It’s still useful to increase checkpoint_segments while loading the data, but don’t bother increasing readline and readline-devel packages, if those are separate in your distribution. • The zlib compression library will be used by default. If you don’t want to use it then you must spec- ify the --without-zlib

of partitions are likely to increase query planning time considerably. Partitioning using these techniques will work well with up to perhaps a hundred partitions; don’t try to use many thousands of partitions much for COPY itself, so this advice is only useful when you are using one or both of the above techniques. 14.4.6. Increase checkpoint_segments Temporarily increasing the checkpoint_segments configuration data-only dump, it is up to you to drop and recreate indexes and foreign keys if you wish to use those techniques. It’s still useful to increase checkpoint_segments while loading the data, but don’t bother increasing

much for COPY itself, so this advice is only useful when you are using one or both of the above techniques. 13.4.6. Increase checkpoint_segments Temporarily increasing the checkpoint_segments configuration data-only dump, it is up to you to drop and recreate indexes and foreign keys if you wish to use those techniques. It’s still useful to increase checkpoint_segments while loading the data, but don’t bother increasing readline and readline-devel packages, if those are separate in your distribution. • The zlib compression library will be used by default. If you don’t want to use it then you must spec- ify the --without-zlib

of partitions are likely to increase query planning time considerably. Partitioning using these techniques will work well with up to perhaps a hundred partitions; don’t try to use many thousands of partitions much for COPY itself, so this advice is only useful when you are using one or both of the above techniques. 14.4.6. Increase checkpoint_segments Temporarily increasing the checkpoint_segments configuration data-only dump, it is up to you to drop and recreate indexes and foreign keys if you wish to use those techniques. It’s still useful to increase checkpoint_segments while loading the data, but don’t bother increasing

increase query planning time considerably. Partitioning 72 Chapter 5. Data Definition using these techniques will work well with up to perhaps a hundred partitions; don’t try to use many thousands of partitions much for COPY itself, so this advice is only useful when you are using one or both of the above techniques. 14.4.6. Increase checkpoint_segments Temporarily increasing the checkpoint_segments configuration data-only dump, it is up to you to drop and recreate indexes and foreign keys if you wish to use those techniques. It’s still useful to increase checkpoint_segments while loading the data, but don’t bother increasing

of partitions are likely to increase query planning time considerably. Partitioning using these techniques will work well with up to perhaps a hundred partitions; don’t try to use many thousands of partitions much for COPY itself, so this advice is only useful when you are using one or both of the above techniques. 14.4.6. Increase checkpoint_segments Temporarily increasing the checkpoint_segments configuration data-only dump, it is up to you to drop and recreate indexes and foreign keys if you wish to use those techniques. It’s still useful to increase checkpoint_segments while loading the data, but don’t bother increasing

of partitions are likely to increase query planning time considerably. Partitioning using these techniques will work well with up to perhaps a hundred partitions; don’t try to use many thousands of partitions much for COPY itself, so this advice is only useful when you are using one or both of the above techniques. 14.4.6. Increase checkpoint_segments Temporarily increasing the checkpoint_segments configuration data-only dump, it is up to you to drop and recreate indexes and foreign keys if you wish to use those techniques. It’s still useful to increase checkpoint_segments while loading the data, but don’t bother increasing

of partitions are likely to increase query planning time considerably. Partitioning using these techniques will work well with up to perhaps a hundred partitions; don’t try to use many thousands of partitions much for COPY itself, so this advice is only useful when you are using one or both of the above techniques. 14.4.6. Increase checkpoint_segments Temporarily increasing the checkpoint_segments configuration data-only dump, it is up to you to drop and recreate indexes and foreign keys if you wish to use those techniques. It’s still useful to increase checkpoint_segments while loading the data, but don’t bother increasing