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 [EMAIL PROTECTED]
