Re: default_text_search_config and expression indexes

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Mike Rylander <mrylander(at)gmail(dot)com>
Cc: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: default_text_search_config and expression indexes
Date: 2007-08-14 20:38:51
Message-ID: 200708142038.l7EKcpn06631@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

Mike Rylander wrote:
> This is just my $0.02 as a fairly heavy user of the current tsearch2
> code, but I sincerely hope you do not cripple the system by removing
> the ability to store tsvectors built using arbitrary configurations in
> a single column. Yes, it can lead to unexpected results if you do not
> know what you are doing, but if you have gone beyond building a single
> tsearch2 configuration then you are required to know what you are
> doing. What's more, IMO the default configuration mechanism feels
> very much like a CONSTRAINT, as Oleg suggests. That point is one of
> cognizance, where if one has gone to the trouble of setting up
> multiple configurations and has learned enough to do so correctly,
> then one necessarily understands the importance of the setting and can
> use it (or not, and use explicit configurations) correctly. The
> default config lowers the bar to an acceptable level for beginners
> that have no need of multiple configurations, and while I don't feel
> too strongly, personally, about having a default, I think it is both
> useful and helpful for new users -- it was for me.

What has really hurt the default GUC idea is how to do restores from a
pg_dump. How do you make sure the right default is used on a restore,
particularly if multiple objects are being restored, and each has a
different default GUC. I suppose your trigger handles that but that
isn't going to help with an expression index, nor in cases where the
default of the old database is different from the new one.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Lukas Kahwe Smith 2007-08-14 20:46:33 Re: PostgreSQL vs. MySQL: fight
Previous Message Bruce Momjian 2007-08-14 20:35:50 Re: default_text_search_config and expression indexes

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-08-14 20:41:05 Re: tsearch2 in PostgreSQL 8.3?
Previous Message Alvaro Herrera 2007-08-14 20:38:06 Re: tsearch2 in PostgreSQL 8.3?