From: marcelo Cortez <jmdc_marcelo@yahoo.com.ar>
To: Lonni J Friedman <netllama@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: segmentation fault
Date: Wed, 9 Mar 2005 17:18:30 -0300 (ART)
Message-ID: <20050309201830.80976.qmail@web50306.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: jmdc_marcelo@yahoo.com.ar, netllama@gmail.com
Subject: Re: segmentation fault
In-Reply-To: <20050309201830.80976.qmail@web50306.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox