Date: Fri, 31 Mar 2006 11:47:10 -0600 From: Miguel <mmiranda@123.com.sv> To: usleepless@gmail.com Cc: freebsd-questions@freebsd.org Subject: Re: terrible performance in 6.1beta4 Message-ID: <442D6B1E.6020107@123.com.sv> In-Reply-To: <c39ec84c0603302202t6c820af2l10c30cda2ae96093@mail.gmail.com> 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> <c39ec84c0603302202t6c820af2l10c30cda2ae96093@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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,
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?442D6B1E.6020107>