Date: Mon, 3 Apr 2006 15:23:10 +0200 From: usleepless@gmail.com To: "Norberto Meijome" <freebsd@meijome.net> Cc: Miguel <mmiranda@123.com.sv>, freebsd-questions@freebsd.org Subject: Re: terrible performance in 6.1beta4 Message-ID: <c39ec84c0604030623v66807b37p77155e326745d78b@mail.gmail.com> In-Reply-To: <c39ec84c0604030618s475606fela22c091ea5ce7cf3@mail.gmail.com> References: <442B2FC6.9040001@123.com.sv> <20060403225821.45fcc26e@localhost> <c39ec84c0604030618s475606fela22c091ea5ce7cf3@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
i just thought of another possible cause: what is the location of the to-be-imported file? local disk? because if it is on the network, check your NIC if you are running at the maximum rate, nfs buffers, etc ( i was fooled by such a situation once ). regards, usleep On 4/3/06, usleepless@gmail.com <usleepless@gmail.com> wrote: > Beto, > > i believe he has given up. > > i would say that on a dedicated database machine 50-75% > dedicated(shared) memory is not overkill. > > wasn't there some other switch which determined wether to page > shared-memory out? > > regards, > > usleep > > On 4/3/06, Norberto Meijome <freebsd@meijome.net> wrote: > > On Wed, 29 Mar 2006 19:09:26 -0600 > > Miguel <mmiranda@123.com.sv> wrote: > > > > > Hi, im loading a lot of information to a postgresql 8.1.3 database, > > > im using the copy command, using the same file and version of > > > postgres in gentoo it spend a few minutes (~4-5), in freebsd > > > 6.1-beta4 it has already spent 25 minutes and the server apparently > > > is doing nothing, > > > > [...] > > > > Hey Miguel, > > I would agree with all the comments about memory and buffers - tweak > > them till you allocate the right amount (i.e., make sure you don't OVER > > allocate...though i'm sure you'd see those errors in the pgsql log. > > > > what does ktrace show when you attach it to the process that is > > importing the data (client and server processes,actually). > > > > - have you tried doing a binary export and import? I've found them to > > be faster, though they may not work for what you need (I think I'm > > using them for backups... ). my hardware is pretty much the same as > > yours, though 4 GB RAM and 4 drives., but my DB is somewhat larger > > > > > and the reponse time of remote logins or running > > > simple commands like ls -l /etc takes a lot of time (35 secs ort so), > > > cpu usage is very low: > > > > ... and all these commands become responsive as usual the minute you > > kill the import process? > > > > btw, you definitely want to kill the indices / FKs in that table until > > you're finished with the initial import - it'll speed things up a lot. > > > > Beto > > _______________________________________________ > > freebsd-questions@freebsd.org mailing list > > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" > > >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?c39ec84c0604030623v66807b37p77155e326745d78b>