On Tue, Jan 15, 2019 at 8:48 PM Darafei "Komяpa" Praliaskouski < m...@komzpa.net> wrote:
> Hello, > > Today I bumped into need to limit first VACUUM time on data import. > I'm using utility called osmium together with COPY FREEZE to import > openstreetmap data into database. > > osmium export -c osmium.config -f pg belarus-latest.osm.pbf -v --progress > | psql -1 -c 'create table byosm(geom geometry, osm_type text, osm_id > bigint, tags jsonb);copy byosm from stdin freeze;' > > However, first pass of VACUUM rewrites the whole table. Here is two logs > of VACUUM VERBOSE in a row: > > https://gist.github.com/Komzpa/e765c1c5e04623d83a6263d4833cf3a5 > > In Russian Postgres Telegram group I've been recommended this thread. > Can the patch be revived? What is needed to get it up for 12? > I posted a new patch [1] for consideration to include in PG12. I started a new thread because the patch is completely new and this thread was a bit too old. Thanks, Pavan [1] https://www.postgresql.org/message-id/CABOikdN-ptGv0mZntrK2Q8OtfUuAjqaYMGmkdU1dCKFtUxVLrg%40mail.gmail.com -- Pavan Deolasee http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services