Hacker News new | ask | show | jobs
by BFLpL0QNek 1215 days ago
I’ve used it for bulk loading on time series data partitioned by date.

It’s a few years ago so details are blurry. We got daily snapshots and on ingest we created an unlogged temporary table then when complete used INSERT FROM to the destination table if I remember right.

As long as the application handles failure on bulk ingest and you copy the data to a logged table or enable logging on the table once ingested it worked really well.