X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2E5BFD1CACB for ; Wed, 11 Feb 2004 14:01:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 17517-07 for ; Wed, 11 Feb 2004 10:01:43 -0400 (AST) Received: from gate.rsb.ro (unknown [194.102.189.2]) by svr1.postgresql.org (Postfix) with ESMTP id 905AED1D8B7 for ; Wed, 11 Feb 2004 10:01:34 -0400 (AST) Received: from cec.ro (mail.cec.ro [194.102.189.5]) by gate.rsb.ro (STRONG Version/8.11.2) with ESMTP id i1BIQie32030 for ; Wed, 11 Feb 2004 19:26:44 +0100 Received: from [10.43.1.20] (account sbogdan HELO rsb.ro) by cec.ro (CommuniGate Pro SMTP 3.5.9) with ESMTP id 13294523 for pgsql-performance@postgresql.org; Wed, 11 Feb 2004 15:46:17 +0200 Message-ID: <402A3747.8000906@rsb.ro> Date: Wed, 11 Feb 2004 16:08:07 +0200 From: stefan bogdan User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: update performance Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/120 X-Sequence-Number: 5644 hello i have postgres 7.3.2.,linux redhat 9.0 a database,and 20 tables a lot of fields are char(x) when i have to make update for all the fields except index postgres works verry hard what should i've changed in configuration to make it work faster thanks bogdan