Re: Mnogosearch (Was: Re: website doc search is ... )

Marc G. Fournier <scrappy@postgresql.org>

From: "Marc G. Fournier" <scrappy@postgresql.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "Marc G. Fournier" <scrappy@postgresql.org>, Bruce Momjian <pgman@candle.pha.pa.us>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2004-01-02T04:28:31Z
Lists: pgsql-general
On Thu, 1 Jan 2004, Tom Lane wrote:

> "Marc G. Fournier" <scrappy@postgresql.org> writes:
> > I take it there is no way of drop'ng OIDs after the fact, eh? :)
>
> I think we have an ALTER TABLE DROP OIDS command, but it won't instantly
> remove the OIDS from the table --- removal happens incrementally as rows
> get updated.  Maybe that's good enough for your situation though.

actually, that would be perfect ... saves having to spend the many many
hours to re-index all the URLs, and will at least give a gradual
improvement :)

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664