title: pg upgrade saving database definition taking time
body: <p>I am in process of a pg_upgrade from 8.4 to 9.3. 
  I am using this technique:</p>
  
  <p><a href="http://momjian.us/main/writings/pgsql/pg_upgrade.pdf" rel="nofollow">http://momjian.us/main/writings/pgsql/pg_upgrade.pdf</a></p>
  
  <p>The upgrade has been running since 250 hours, and it has been on the step saving database definition since 160 hours. This is the current output of strace last few lines:</p>
  
  <pre><code>poll([{fd=5, events=POLLIN|.             
  POLLERR}], 1, -1) = 1 ([{fd=5,   
  revents=POLLIN}])
  recvfrom(5, "T\0\0\0F
  \0\2reltoastrelid\0\0\0\4\353\0\n
  \0\0\0\32\0"..., 16384, 0, NULL, 
  NULL) = 122
  (5, "Q\0\0\0\221SELECT 
  attname, attacl FROM"..., 146,  
  MSG_NOSIGNAL, NULL, 0) = 146
  poll([{fd=5, events=POLLIN|
  POLLERR}], 1, -1
  </code></pre>
  
  <p>Is there a way to estimate how much time it will take? 
  There are ~3,300,000 objects in pg_class and the database has around 765,000 tables. There are around 3-5 columns in most tables, and around 2,000,000 records in total. </p>