Skip site navigation (1) Skip section navigation (2)

Re: Upgrading rant.

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: mlw <pgsql(at)mohawksoft(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hannu Krosing <hannu(at)tm(dot)ee>,Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Upgrading rant.
Date: 2003-01-06 03:21:10
Message-ID: 200301060321.h063LBh26523@candle.pha.pa.us (view raw or flat)
Thread:
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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers by date

Next:From: Dan LangilleDate: 2003-01-06 03:21:49
Subject: Re: New Portal in Place, DNS switched ...
Previous:From: Bruce MomjianDate: 2003-01-06 03:18:48
Subject: Re: IPv6 patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group