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

Re: [HACKERS] now 6.4

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: vadim(at)krs(dot)ru (Vadim Mikheev)
Cc: dg(at)illustra(dot)com, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] now 6.4
Date: 1998-06-11 02:33:42
Message-ID: 199806110233.WAA01530@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> 
> Bruce Momjian wrote:
> > 
> > > I have no problem with catalog changes and dumping the schema if we can
> > > write a script to help them do it. I would hope we can avoid having to make
> > > someone dump and reload their own data. I am thinking that it could be
> > > pretty inconvenient to dump/load and reindex something like a 50GB table with
> > > 6 indexes.
> > >
> > > Thanks for the clarification.
> > 
> > Yep, I think this is do'able, UNLESS Vadim decides he needs to change
> > the structure of the data/index files.  At that point, we are lost.
> 
> Unfortunately, I want to change btree!
> But not HeapTuple structure...

So we will just need to re-create indexes.  Sounds OK to me, but
frankly, I am not sure what the objection to dump/reload is.

Vadim, you make any changes you feel are necessary, and near release
time, we will develop the best migration script we can.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

In response to

Responses

pgsql-hackers by date

Next:From: Vadim MikheevDate: 1998-06-11 03:19:40
Subject: Re: [HACKERS] now 6.4
Previous:From: t-ishiiDate: 1998-06-11 01:45:46
Subject: Re: [HACKERS] now 6.4

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