this is very helpful information. thanks again!
> On Jul 16, 2015, at 8:16 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Yiqing Jin <yiqing(dot)jin(at)gmail(dot)com> writes:
>> Yes it finished successfully after changing it to 50G!
>
> OK. That's only a workaround of course. I believe the actual problem
> is explained here:
> http://www.postgresql.org/message-id/flat/25168(dot)1437091531(at)sss(dot)pgh(dot)pa(dot)us
> If you need a fix before the next minor releases, see
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b8f368276916b677f0678982e81723fe30e5c582
>
> regards, tom lane