Gary Fu <g...@sigmaspace.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
