From: | Mike Mascari <mascarim(at)yahoo(dot)com> |
---|---|
To: | Jan Wieck <wieck(at)debis(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] 7.0 status request |
Date: | 1999-11-19 22:48:21 |
Message-ID: | 19991119224821.22387.rocketmail@web2102.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
--- Jan Wieck <wieck(at)debis(dot)com> wrote:
> Bruce Momjian wrote:
>
> > > > Here are the major open issues for 7.0 that I remember:
> > > > Foreign Keys - Jan
> > > > WAL - Vadim
> > > > Function args - Tom
> > > > System indcxes - Bruce
> > > > Outer joins and new multi-query parse tree are questionable items
> for
> > > > 7.0.
> > >
> > > You might include "join syntax", which will be ready even if outer
> > > joins are not.
> > >
> > > Also, didn't some folks express concern that indices on system
> tables
> > > would make the backend more fragile? Did we resolve that issue?
> >
> > We have indexes on most system tables and it isn't a problem
> currently.
>
> It is, because a corrupted index on a system table cannot be
> corrected by drop/create, as a user defined index could be.
>
> I don't know why and when reindexdb disappeared, but that
> script was a last resort for exactly the situation of a
> corrupted system index. Let me take a look if this
> functionality could easily be recreated.
>
>
> Jan
>
> --
>
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me. #
> #========================================= wieck(at)debis(dot)com (Jan Wieck) #
For what its worth, TRUNCATE TABLE already rebuilds indexes on TRUNCATE'd
tables, so it shouldn't be that much of a leap, one would think.
Mike Mascari
(mascarim(at)yahoo(dot)com)
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1999-11-20 00:13:54 | Re: [HACKERS] 7.0 status request |
Previous Message | Bruce Momjian | 1999-11-19 22:39:52 | Re: [HACKERS] 7.0 status request |