4 ms·
It was actually a combination of several queries in the first database followed by several inserts into postgresql.
by zenogais 12y ago
It was actually a combination of several queries in the first database followed by several inserts into postgresql.
- bsg75 12y agoRatio of query time vs insert time?
- jerrysievert 12y agoi'm curious as well - even if the data was only somewhat structured on the mongo side, an import into a single column table with JSON should be fairly quick with \COPY, then with a couple of indexes applied on your disparate data in the JSON data you should have been able to query that into a new table structure quite easily. just wondering what the tradeoffs were in OP's eyes.