Horton
Menu

Re: Upgrading rant.

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: mlw <pgsql@mohawksoft.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Hannu Krosing <hannu@tm.ee>, Lamar Owen <lamar.owen@wgcr.org>, pgsql-hackers@postgresql.org
Date: 2003-01-06T03:21:10Z
Lists: pgsql-hackers 
mlw wrote:
> I have the USA tiger census data in a database, it is over 60G with 
> indexes, 30G+ of just data. Do you know how long that will take to dump 
> and restore? Making one index on some of the tables takes 20 minutes.

Oh, come on.  How many tigers are their in the USA?  Certainly not 30G+
worth.  ;-)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073