On Tue, Apr 18, 2017 at 2:45 AM, Daniel Blanch Bataller <daniel.blanch.batal...@gmail.com> wrote: > > But if you are going to move a record at a time you are going to be limited > by the fastest transaction rate you can achieve, which is going to be a few > hundred per second, and limited at the end by the disk hardware you have, . > Out of the box and on commodity hardware it can take you up to then days to > move 100M records.
RDS usually is not commodity hardware, most RDS instances will have some form of SSD storage, so performance could be much higher than what you'd get on your laptop. I'd have to second David's advice: test with pgbench first. It can quite accurately simulate your use case. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
