3 ms·
I 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
by mulmen 6y ago
I 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.