terrible performance in 6.1beta4
wmoran at collaborativefusion.com
Fri Mar 31 00:34:01 UTC 2006
Miguel <mmiranda at 123.com.sv> wrote:
> usleepless at gmail.com wrote:
> >>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
More information about the freebsd-questions