Re: PostgreSQL performance problem -> tuning

From: Dennis Björklund <db(at)zigo(dot)dhs(dot)org>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Yaroslav Mazurak <yamazurak(at)Lviv(dot)Bank(dot)Gov(dot)UA>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PostgreSQL performance problem -> tuning
Date: 2003-08-07 08:23:04
Message-ID: Pine.LNX.4.44.0308071020110.26410-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 7 Aug 2003, Richard Huxton wrote:

> But this parameter controls how much memory can be allocated to sorts - I
> don't see how PG can figure out a reasonable maximum by itself.

One could have one setting for the total memory usage and pg could use
statistics or some heuristics to use the memory for different things in a
good way.

Then that setting could have an auto setting so it uses 40% of all memory
or something like that. Not perfect but okay for most people.

--
/Dennis

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Yaroslav Mazurak 2003-08-07 08:24:17 Re: PostgreSQL performance problem -> tuning
Previous Message Richard Huxton 2003-08-07 08:10:58 Re: PostgreSQL performance problem -> tuning