On Fri, 2006-04-07 at 16:41 +0200, Gábriel Ákos wrote:

> >  
> > Any ideas of what I can test/configurate to find out why this happens?
> > Thanks in advance.
> 
> Increase work_mem to 50% of memory, and don't care about 
> maintenance_work_mem and effective_cache_size, they don't matter in this 
> case.
> 

The problem is not the amount of memory. It works much faster with only
16M and 7.4.12 than 8.0.7.

-- 
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Oslo, Norway

PGP Public Key: http://folk.uio.no/rafael/


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to