| From: | marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar> |
|---|---|
| To: | Lonni J Friedman <netllama(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: segmentation fault |
| Date: | 2005-03-09 20:18:30 |
| Message-ID: | 20050309201830.80976.qmail@web50306.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith C. Perry | 2005-03-09 20:34:31 | Re: PostgreSQL still for Linux only? |
| Previous Message | Magnus Hagander | 2005-03-09 20:08:20 | Re: PostgreSQL still for Linux only? |