Date: Thu, 30 Mar 2006 19:33:55 -0500 From: Bill Moran <wmoran@collaborativefusion.com> To: Miguel <mmiranda@123.com.sv> Cc: freebsd-questions@freebsd.org, usleepless@gmail.com Subject: Re: terrible performance in 6.1beta4 Message-ID: <20060330193355.66256357.wmoran@collaborativefusion.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 <mmiranda@123.com.sv> wrote: > usleepless@gmail.com wrote: > > >Miguel > > > >>attached is my config file, shared_buffers are 25% of total RAM > >>im guessing that this is a disk controlled bug or something, when i > >>execute any query involving many rows, the server response is very low, > >>ssh, su, even copy or rename a file, cpu usage remains ~87% idle though > >> > >you are not inserting into an indexed table, are you? > > yes, i am... > is that a problem? Yes. BIG problem. 1) Create the tables without indexes 2) Insert data 3) Create the indexes This will be much, much faster than inserting 3G of data into an indexed table. -- Bill Moran Potential Technologies http://www.potentialtech.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060330193355.66256357.wmoran>