In article <mailman.3980.1364611804.2939.python-l...@python.org>, Chris Angelico <ros...@gmail.com> wrote:
> Especially facepalm because there's some way to do this that's faster > than straight INSERT statements, and it's not clearly documented as > "hey, guys, if you want to dump loads of data in, use COPY instead" > (it might be that, I don't know, but usually COPY isn't directly > transliterable with INSERT). We're actually using REPLACE INTO. For the initial data load, we could just as well do INSERT, but we need the REPLACE functionality as we roll in the daily incremental updates. This also explains why, even after provisioning our RDS instance for 2000 IOPS (that's AWS-speak for "we paid extra to get more disk bandwidth"), we didn't see any performance improvement! -- http://mail.python.org/mailman/listinfo/python-list
