From owner-freebsd-questions@FreeBSD.ORG Fri Mar 31 17:43:24 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0705216A41F for ; Fri, 31 Mar 2006 17:43:24 +0000 (UTC) (envelope-from mmiranda@123.com.sv) Received: from asgard1.americatelsal.com (asgard.americatelsal.com [200.13.161.7]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5904743D45 for ; Fri, 31 Mar 2006 17:43:22 +0000 (GMT) (envelope-from mmiranda@123.com.sv) Received: (qmail 33584 invoked from network); 31 Mar 2006 18:05:33 -0000 Received: from unknown (HELO ?192.168.10.124?) (200.13.161.68) by asgard1.americatelsal.com with SMTP; 31 Mar 2006 18:05:33 -0000 Message-ID: <442D6B1E.6020107@123.com.sv> Date: Fri, 31 Mar 2006 11:47:10 -0600 From: Miguel User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: usleepless@gmail.com References: <442B2FC6.9040001@123.com.sv> <20060330011834.GA84658@xor.obsecurity.org> <442BF0BB.8010504@123.com.sv> <20060330150136.GA12982@xor.obsecurity.org> <442C3B17.4060308@123.com.sv> <442C6CAF.7020601@123.com.sv> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: terrible performance in 6.1beta4 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 31 Mar 2006 17:43:24 -0000 usleepless@gmail.com wrote: >Miguel, > > > >>>you are not inserting into an indexed table, are you? >>> >>> >>yes, i am... >>is that a problem? >> >> > >it used to be a problem, but since your gentoo box is doing the same >task in 4-5 minutes, i doubt it is currently the problem. > >i seem to recall some speedup of the copyin-command in one of the >latest releases of PostgreSQL. i don't know the details, maybe they >are deferring index-updates automagically when copying-in ( check >PostgreSQL release notes ). > >Miguel, you have not yet confirmed the two >postgresql.conf-files(gentoo vs fbsd) to be identical ( or i missed >that ). please let me know. > > Yes, thay are identical, except for he shared_buffers, >another issue pops to my mind: on 4.x i had to tweak some sysctl's >regarding shared-memory ( default settings would not allow PGSQL to >claim as much as i would like ). i don't know if this still needs to >be done on 6.x. if i recall correctly, postgresql would not start if >it could not allocate it's shared buffers. things may have changed: >check you postgresql.log to see if it is complaining. > >please let us know if you achieved any speed update at all. > > i increased the shred_buffers to 35% of fisical RAM, that doesnt helped very much, neither do fsync off. thanks for all folks,