Re: PostgreSQL performance problem -> tuning - Mailing list pgsql-performance

From Dennis Björklund
Subject Re: PostgreSQL performance problem -> tuning
Date
Msg-id Pine.LNX.4.44.0308071020110.26410-100000@zigo.dhs.org
Whole thread Raw
In response to Re: PostgreSQL performance problem -> tuning  (Richard Huxton <dev@archonet.com>)
List 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


pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: PostgreSQL performance problem -> tuning
Next
From: Yaroslav Mazurak
Date:
Subject: Re: PostgreSQL performance problem -> tuning