From owner-freebsd-questions@FreeBSD.ORG Fri Mar 31 06:02:37 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 DB9D816A400 for ; Fri, 31 Mar 2006 06:02:37 +0000 (UTC) (envelope-from usleepless@gmail.com) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.205]) by mx1.FreeBSD.org (Postfix) with ESMTP id 57F9543D4C for ; Fri, 31 Mar 2006 06:02:37 +0000 (GMT) (envelope-from usleepless@gmail.com) Received: by zproxy.gmail.com with SMTP id l8so693975nzf for ; Thu, 30 Mar 2006 22:02:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=h0tb8W9IX18/h5Yoi/kOFaudQSU3Y428+p18xlVozjFPk/daVx4l2kvjxtzPI31pZezPakdvT5OUTZDWSMy/zx4tYRWIKumfWJlv5TpbAqXvYnBJyb+BOijCgFckRv6m4S7rqfb4HtaYGdz7Fv8rNuGbVidfYg92b7nfA4lYXJM= Received: by 10.36.220.43 with SMTP id s43mr155511nzg; Thu, 30 Mar 2006 22:02:36 -0800 (PST) Received: by 10.36.154.7 with HTTP; Thu, 30 Mar 2006 22:02:36 -0800 (PST) Message-ID: Date: Fri, 31 Mar 2006 08:02:36 +0200 From: usleepless@gmail.com To: Miguel In-Reply-To: <442C6CAF.7020601@123.com.sv> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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> 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 06:02:37 -0000 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. 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. regards, usleep > > --- > Miguel >