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 587445659B for ; Wed, 9 Mar 2005 17:48:56 +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 91769-10 for ; Wed, 9 Mar 2005 17:48:54 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.193]) by svr1.postgresql.org (Postfix) with ESMTP id 03A955658A for ; Wed, 9 Mar 2005 17:48:53 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id a41so265427rng for ; Wed, 09 Mar 2005 09:48:53 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=KSJViY3WCPItnW17Titi/KD6/LX9WIlktLBa7tFudYpIAeW/rVccdHJ4f6QeusX0Cy9iP5hwJgrW2LZa+DB//rmCG9OLiR9GIvcBYcbislspvZGjmaIk4n/E5A3IXUulYJ/3rHv1UudeCst18kFi/pZ3PQLROiJl8WrnP7NkSXs= Received: by 10.38.24.17 with SMTP id 17mr983054rnx; Wed, 09 Mar 2005 09:48:53 -0800 (PST) Received: by 10.38.149.54 with HTTP; Wed, 9 Mar 2005 09:48:53 -0800 (PST) Message-ID: <7c1574a9050309094823c6dfc6@mail.gmail.com> Date: Wed, 9 Mar 2005 09:48:53 -0800 From: Lonni J Friedman Reply-To: Lonni J Friedman To: marcelo Cortez Subject: Re: segmentation fault Cc: pgsql-general@postgresql.org In-Reply-To: <20050309172855.16912.qmail@web50306.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <20050309172855.16912.qmail@web50306.mail.yahoo.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.242 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200503/335 X-Sequence-Number: 74651 On Wed, 9 Mar 2005 14:28:55 -0300 (ART), marcelo Cortez wrote: > > hello to all > I have the following problem, when making massive > update of a table, I received the message > "segmentation fault" without no other data of the > error in log. > Some idea of because it gives east message? > I am using > gentoo > postgres 7.4.6 > dual processor HP proliant > 5 gigabyte of ram > 147 gigabytes of hd. > 47 free . > > BTW the column to update is the one of indice gist of > FTS and the table has 22 million registries. > any clue? You're doing this from within psql or elsewhere? What logging level are you using? How 'massive' is this update? What kind of parameters have you set for this database? -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@gmail.com LlamaLand http://netllama.linux-sxs.org