3 ms·
I've disabled all constraints, but I haven't removed indexing during loading. I'll look into doing that, with adding the indexing later
by koeng 6y ago
I've disabled all constraints, but I haven't removed indexing during loading. I'll look into doing that, with adding the indexing later
- mulmen 6y agoI don’t often work with Postgres itself but I do work with a derivative (Redshift) at $dayjob. Indexes don’t exist. Constraints are present in the syntax and the planner relies on them but they are never enforced. Our ETL layer deals with checking constraints at load time. Load performance is good. I’ve never run a rows/minute metric because it’s never been a problem.
- mulmen 6y agoComing back to this just to provide a datapoint. I just loaded 10m rows into a table in less than one minute using Redshift. The data is encoded (compressed) at insert time but is not sorted until a vacuum runs.