terrible performance in 6.1beta4

Bill Moran wmoran at collaborativefusion.com
Fri Mar 31 00:34:01 UTC 2006

Miguel <mmiranda at 123.com.sv> wrote:

> usleepless at 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

Bill Moran
Potential Technologies

More information about the freebsd-questions mailing list