Date: Fri, 31 Mar 2006 08:02:36 +0200 From: usleepless@gmail.com To: Miguel <mmiranda@123.com.sv> Cc: freebsd-questions@freebsd.org Subject: Re: terrible performance in 6.1beta4 Message-ID: <c39ec84c0603302202t6c820af2l10c30cda2ae96093@mail.gmail.com> In-Reply-To: <442C6CAF.7020601@123.com.sv> References: <442B2FC6.9040001@123.com.sv> <20060330011834.GA84658@xor.obsecurity.org> <c39ec84c0603300047u5530fc1fjb1ba93fcafcd490d@mail.gmail.com> <442BF0BB.8010504@123.com.sv> <20060330150136.GA12982@xor.obsecurity.org> <c39ec84c0603301151s77b37291x3ac1f79582cd753e@mail.gmail.com> <442C3B17.4060308@123.com.sv> <c39ec84c0603301258j4b31df83g2ab9481a8fc3761f@mail.gmail.com> <442C6CAF.7020601@123.com.sv>
next in thread | previous in thread | raw e-mail | index | archive | help
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 >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?c39ec84c0603302202t6c820af2l10c30cda2ae96093>