> My statistics(Athlon 1.8Ghz)
> ----------------
> 20,000 items            Takes on average 0.078seconds/room
> 385,000 items          Takes on average .11seconds/room
> 690,000 items          takes on average .270seconds/room
> 1,028,000 items       Takes on average .475seconds/room
[snip]
>  I am running Red hat 8. Some of my conf entries that I have changed 
> follow
> shared_buffers = 3700
> effective_cache_size = 4000
> sort_mem = 32168

Have you twiddled with your wal_buffers or checkpoint_segments?  Might
be something to look at.

-sc

-- 
Sean Chittenden

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to