Re: Optimize massive data ingestion - Need Advice

2022-08-02 Thread Pierre Yager
Thank you for the warning. I'll double check what happens with my indexes. Le mardi 2 août 2022 à 17:07:13 UTC+2, Jeremy Evans a écrit : > On Tue, Aug 2, 2022 at 5:25 AM Pierre Yager > wrote: > >> Hello, >> >> Still working on this GeoNames database. >> >> After reading this guide in the Postgr

Re: Optimize massive data ingestion - Need Advice

2022-08-02 Thread Jeremy Evans
On Tue, Aug 2, 2022 at 5:25 AM Pierre Yager wrote: > Hello, > > Still working on this GeoNames database. > > After reading this guide in the PostgreSQL documentation ( > https://www.postgresql.org/docs/current/populate.html) i see some room of > improvement in my GeoNames dataset injestion proces

Optimize massive data ingestion - Need Advice

2022-08-02 Thread Pierre Yager
Hello, Still working on this GeoNames database. After reading this guide in the PostgreSQL documentation (https://www.postgresql.org/docs/current/populate.html) i see some room of improvement in my GeoNames dataset injestion process. I should drop indexes and foreign key prior to data injectio