Hi, On Wednesday 23 February 2011 19:31:58 Gary Fu wrote: > 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). I think some additional information would be useful: * pg version * kernel version * distribution Andres -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
