terrible performance in 6.1beta4

[Bill Moran]

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
table.

-- 
Bill Moran
Potential Technologies
http://www.potentialtech.com