| From: | Darafei Praliaskouski <me(at)komzpa(dot)net> |
|---|---|
| To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Cc: | Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> |
| Subject: | Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits |
| Date: | 2019-03-21 14:45:23 |
| Message-ID: | 155317952381.16480.6501291326861188403.pgcf@coridan.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
The following review has been posted through the commitfest application:
make installcheck-world: not tested
Implements feature: not tested
Spec compliant: not tested
Documentation: not tested
This patch is particularly helpful in processing OpenStreetMap Data in PostGIS.
OpenStreetMap is imported as a stream of 300-900 (depending on settings) gigabytes, that are needing a VACUUM after a COPY FREEZE.
With this patch, the first and usually the last transforming query is performed much faster after initial load.
I have read this patch and have no outstanding comments on it.
Pavan Deolasee demonstrates the expected speed improvement.
The new status of this patch is: Ready for Committer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jesper Pedersen | 2019-03-21 15:01:06 | Re: partitioned tables referenced by FKs |
| Previous Message | Pavan Deolasee | 2019-03-21 14:27:30 | Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits |