Обсуждение: Is dropping pg_ts_* harmful?
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
On Mon, Feb 02, 2009 at 09:40:16AM -0500, Eric Brown wrote: > 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? > There should be an uninstall_tsearch2.sql script somewhere on your system if you have a relatively recent 8.2. That should scrub everything :) Cheers, David. > Thanks folks -- > > -- Eric Brown / Director of IT / www.mediweightlossclinics.com -- David Fetter <david@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate