X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 56BB85655B for ; Wed, 9 Mar 2005 20:18:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35167-06 for ; Wed, 9 Mar 2005 20:18:32 +0000 (GMT) Received: from web50306.mail.yahoo.com (web50306.mail.yahoo.com [206.190.38.60]) by svr1.postgresql.org (Postfix) with SMTP id 6C49E559C2 for ; Wed, 9 Mar 2005 20:18:30 +0000 (GMT) Received: (qmail 80978 invoked by uid 60001); 9 Mar 2005 20:18:30 -0000 Message-ID: <20050309201830.80976.qmail@web50306.mail.yahoo.com> Received: from [168.226.113.88] by web50306.mail.yahoo.com via HTTP; Wed, 09 Mar 2005 17:18:30 ART Date: Wed, 9 Mar 2005 17:18:30 -0300 (ART) From: marcelo Cortez Subject: Re: segmentation fault To: Lonni J Friedman Cc: pgsql-general@postgresql.org In-Reply-To: 6667 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.026 tagged_above=0 required=5 tests=RCVD_IN_NJABL_PROXY X-Spam-Level: * X-Archive-Number: 200503/356 X-Sequence-Number: 74672 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