From: Rafael Martinez <r.m.guerrero@usit.uio.no>
To: Gábriel Ákos <akos.gabriel@i-logic.hu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Same SQL, 104296ms of difference between 7.4.12 and
Date: Fri, 07 Apr 2006 16:53:40 +0200
Message-ID: <1144421620.6928.2.camel@linux.site> (raw)
In-Reply-To: <44367A1B.1090900@i-logic.hu>
References: <1144413933.24060.253.camel@bbking.uio.no>
<44367A1B.1090900@i-logic.hu>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: r.m.guerrero@usit.uio.no, akos.gabriel@i-logic.hu
Subject: Re: Same SQL, 104296ms of difference between 7.4.12 and
In-Reply-To: <1144421620.6928.2.camel@linux.site>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox