On Mon, Aug 27, 2012 at 2:37 PM, Georges Racinet <gracinet@xxxxxxxxx> wrote: > I guess one must also reindex in case some record changes as well, right ? > Through a trigger maybe ? You do not need to reindex it in case of record changes. The index values will be recalculated automatically after committing the changes. -- Sergey Konoplev a database and software architect http://www.linkedin.com/in/grayhemp Jabber: gray.ru@xxxxxxxxx Skype: gray-hemp Phone: +79160686204 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general