Re: [HACKERS] now 6.4 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] now 6.4
Date
Msg-id 199806110233.WAA01530@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] now 6.4  (Vadim Mikheev <vadim@krs.ru>)
Responses Re: [HACKERS] now 6.4  (The Hermit Hacker <scrappy@hub.org>)
List 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@candle.pha.pa.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)

pgsql-hackers by date:

Previous
From: t-ishii@sra.co.jp
Date:
Subject: Re: [HACKERS] now 6.4
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] now 6.4