all, whereas pg_statistic is only readable by a superuser. (This prevents unprivileged users from learning something about the contents of other people’s tables from the statistics. The pg_stats view is 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

all, whereas pg_statistic is only readable by a superuser. (This prevents unprivileged users from learning something about the contents of other people’s tables from the statistics. The pg_stats view is 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

all, whereas pg_statistic is only readable by a superuser. (This prevents unprivileged users from learning something about the contents of other people’s tables from the statistics. The pg_stats view is 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

all, whereas pg_statistic is only readable by a superuser. (This prevents unprivileged users from learning something about the contents of other people’s tables from the statistics. The pg_stats view is 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

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 all, whereas pg_statistic is only readable by a superuser. (This prevents unprivileged users from learning something about the contents of other people’s tables from the statistics. The pg_stats view is 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

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 all, whereas pg_statistic is only readable by a superuser. (This prevents unprivileged users from learning something about the contents of other people’s tables from the statistics. The pg_stats view is 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

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 all, whereas pg_statistic is only readable by a superuser. (This prevents unprivileged users from learning something about the contents of other people’s tables from the statistics. The pg_stats view is 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

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 all, whereas pg_statistic is only readable by a superuser. (This prevents unprivileged users from learning something about the contents of other people’s tables from the statistics. The pg_stats view is 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

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 all, whereas pg_statistic is only readable by a superuser. (This prevents unprivileged users from learning something about the contents of other people’s tables from the statistics. The pg_stats view is 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

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 all, whereas pg_statistic is only readable by a superuser. (This prevents unprivileged users from learning something about the contents of other people’s tables from the statistics. The pg_stats view is 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