Lonni , folks > Full meaning all the rows are being updated? What > kind of data is > this that you're updating? the fts engine using one tsvector field indexing with gist index the statement is something like this update from veryLargeTable set field = to_tsvector( coleace(field1) ); any indication to improve the one configuration the DB. thanks for your support. best regards MDC ___________________________________________________________ 250MB gratis, Antivirus y Antispam Correo Yahoo!, el mejor correo web del mundo http://correo.yahoo.com.ar ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
