Re: [HACKERS] now 6.4

>
> 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)