You mean import the raw data into a json column and then SELECT DISTINCT INTO? T... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		_3u10 on Sept 24, 2014 \| parent \| context \| favorite \| on: How to Migrate 50M Records from Mongo to PostgreSQ... You mean import the raw data into a json column and then SELECT DISTINCT INTO? There are only 50 million rows... this sounds like a 5 minute query.

rjbrock on Sept 24, 2014 [–]

I was assuming he was moving the json into a structured foreign key-> data type of relationship

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact