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
