Miguel <[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

Bill Moran
Potential Technologies
freebsd-questions@freebsd.org mailing list
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to