Re: slow building index and reference after Sybase to Pg

Gary Fu <gfu(at)sigmaspace(dot)com> writes:
> I'm testing on converting a big Sybase db to Pg. It took about 45 hours
> to convert all sybase tables (bcp) to Pg (copy) without index and
> reference. After that I built the index (one by one, sequentially) and
> it took about 25 hours and then I started to add the references (one by
> one), however, it has been more than 30 hours and still has no sign of
> finishing. I wonder, is there any suggestion that may speed up the index
> and reference building (on Pg).

Have you read
http://www.postgresql.org/docs/9.0/static/populate.html
? In particular I'm wondering what you have maintenance_work_mem
set to.

regards, tom lane