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, <r.m.guerrero@usit.uio.no>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/