Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id E29809FA1DB for ; Mon, 20 Nov 2006 09:21:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 54635-10 for ; Mon, 20 Nov 2006 13:21:25 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id 51AA79FA154 for ; Mon, 20 Nov 2006 09:21:23 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so968412ugf for ; Mon, 20 Nov 2006 05:21:20 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=Lh/zpA/+SaTuVoTVyxq6789ffumBo4pK28885pClT9ouBbX6eEydh8L3F1akgJ1BeT4/gOkKskpVzEbOe8Gad3WexmqjSQpsGIQWBUkcRjGcETX/3spSLCufdjuhTjsNX5WhRZ49MpkG+GmsPpPgqiC/9eNAbKNhc7GZGmLJ9HI= Received: by 10.78.201.10 with SMTP id y10mr5231918huf.1164028880641; Mon, 20 Nov 2006 05:21:20 -0800 (PST) Received: by 10.78.139.19 with HTTP; Mon, 20 Nov 2006 05:21:20 -0800 (PST) Message-ID: <69f2062a0611200521x5bf10321u906d8ca215485fd6@mail.gmail.com> Date: Mon, 20 Nov 2006 13:21:20 +0000 From: "jose fuenmayor" To: pgsql-admin@postgresql.org Subject: Settings for writing! MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_79462_17158914.1164028880611" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/185 X-Sequence-Number: 23712 ------=_Part_79462_17158914.1164028880611 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all, which paramaters can I modify in order to improve performance in wirting tasks (updates,inserts,copy), I have a database where there is a lot of writing, i have increase the shared_buffers but it seems to improve just the reading which are really fast (I have a table with like 87 000 000 rows, the problem goes when writing) I am using Mandiva linux 2006 x86_64 kernel 2.6.17 Postgresql 8.0.8 in a ML350G4 I really apreciate the help! Thanks in advance! ------=_Part_79462_17158914.1164028880611 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all, which paramaters can I modify in order to improve performance in wirting tasks (updates,inserts,copy), I have a database where there is a lot of writing, i have increase the shared_buffers but it seems to improve just the reading which are really fast (I have a table with like
87 000 000  rows, the problem goes when writing)

I am using Mandiva linux 2006 x86_64 kernel 2.6.17
Postgresql 8.0.8
in a ML350G4
I really apreciate the help!
Thanks in advance!
------=_Part_79462_17158914.1164028880611--