0

I have a lookup table that only has 4 columns (bool, date, number, string) with 9,998,081 rows.

The CSV is relatively small (285mb), but it "blows up" when I upload it to CartoDB, I suspect, because of the other columns that CartoDB adds (the_geom, created_at, updated_at, etc).

It eats up the quota of my account and the table becomes 819.62 MB.

Would it be possible to tell CartoDB that this is just a lookup table that I'll use in joins, and I won't need these extra columns?

1

I had a similar problem where datasets in CartoDB would double or triple in size. The solution was to run the command VACUUM FULL <tablename>; in the SQL console.

https://twitter.com/juanignaciosl/status/561059817469775873

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.