RE: Full text Indexing -out of contrib and into main..

From: Magnus Hagander <mha(at)sollentuna(dot)net>
To: "'Hannu Krosing'" <hannu(at)tm(dot)ee>, john huttley <john(at)mwk(dot)co(dot)nz>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Don Baccus <dhogaza(at)pacifier(dot)com>, Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: RE: Full text Indexing -out of contrib and into main..
Date: 2000-11-28 09:52:43
Message-ID: 215896B6B5E1CF11BC5600805FFEA82103D9850D@sirius.edu.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > b) Check out MSSQL 7's capabilities and weep.
>
> BTW, have you studied MSSQL enough to tell me if it has a
> separate/standalone
> (as a process) fti engine or just another index type.
It is standalone - separate process, data is stored in separate files (not
in db).

In SQL Server 7.0, you also have to manually update the index. Just updating
the values in the table does *NOT* update the index. (Can be scheduled, of
course, but not live)
In SQL Server 2000 the index can be auto-updated when rows change, but it's
not default.

//Magnus

Browse pgsql-hackers by date

  From Date Subject
Next Message Pete Forman 2000-11-28 09:59:38 Re: Question about Oracle compatibility
Previous Message Zeugswetter Andreas SB 2000-11-28 09:51:28 AW: 8192 BLCKSZ ?