Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group