Re: Same SQL, 104296ms of difference between 7.4.12 and

From: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
To: Gábriel Ákos <akos(dot)gabriel(at)i-logic(dot)hu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Same SQL, 104296ms of difference between 7.4.12 and
Date: 2006-04-07 14:53:40
Message-ID: 1144421620.6928.2.camel@linux.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
Center for Information Technology Services
University of Oslo, Norway

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matt Davies | Postgresql List 2006-04-07 14:54:26 Re: Loading the entire DB into RAM
Previous Message Richard Huxton 2006-04-07 14:40:51 Re: Same SQL, 104296ms of difference between 7.4.12 and