On 5/20/19 3:43 PM, Will Hartung wrote:
On May 20, 2019, at 2:55 PM, Ron <ronljohnsonjr@xxxxxxxxx> wrote:
And it pathologically loads even when there's just a PK on the numeric field?
Yea, that works fine.
Drop all indexes, load data, recreate indexes?
No, I use the incremental load as it gives a much better indication when the process has gone off the deep end.
But pg_restore only creates indexes AFTER the data loads.
Yes. Demonstrating that it doesn’t work either incrementally or all at once.
So the issue is building the index(s) not loading the data, correct?
(No, I have no confidence that the Aurora build will ever finish in any reasonable amount of time.)
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
