Is dropping pg_ts_* harmful?

From: "Eric Brown" <ebrown(at)mediweightloss(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Is dropping pg_ts_* harmful?
Date: 2009-02-02 14:40:16
Message-ID: 47E8E4E7CD99804FAD1283997CAAF681050EFB@MEDI-HQ.medi.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a database running very happily in 8.2 (to be upgraded soon). The system was installed with tsearch2 enabled, however, we have yet to use it. I am going through an effort to reduce "cruft" in the database, which includes four tables: pg_ts_cfg, pg_ts_cfgmap, pg_ts_dict, pg_ts_parser. Are these tables safe to drop? Will the remnants of tsearch2 be anywhere else in the database if it was never used?

Thanks folks --

-- Eric Brown / Director of IT / www.mediweightlossclinics.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mohamed 2009-02-02 14:40:56 Re: Fulltext search configuration
Previous Message Scara Maccai 2009-02-02 14:30:38 Re: R: R: complex custom aggregate function