Import stuck on creating search indexes

[juggernautt]

I'm importing planet file to database, not binary file. 3 days before setups script started to create search indexes. Since then nothing changed, no errors, no changes.
From your experience do I have to wait more or is it stack?
I'm running this import with 128GB Ram and 2TB SSD.

[mtmail]

I've seen this before. On the postgresql database run

SELECT pid,
       usename,
       pg_blocking_pids(pid) AS blocked_by,
       query AS blocked_query
FROM pg_stat_activity; 

If you see a line

 pid  |  usename  | blocked_by | blocked_query
-------+-----------+------------+---------------------------------------------------------------------------
 99441 | nominatim | {100472}   | CREATE INDEX idx_placex_rank_search ON placex USING BTREE (rank_search) ;

and the blocked_by pid points to an autovacuum process it's save to stop the autovacuum process. Otherwise it will go on forever (well at least very very long)

E.g.

SELECT pg_terminate_backend(100472) FROM pg_stat_activity; 

You might need to watch and repeat this another 3-5 times. With your hardware the searchindex creation step shouldn't take longer than 3 hours total.

[juggernautt]

Meanwhile the process is ended. Next time I'll take closer look at theses autovacuum processes.
Thanks

[MatthiasLohr]

Thanks, this issue helped a lot!