Miguel <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] 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 _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"