Re: Question about memory allocations

From: Ron <rjpeace(at)earthlink(dot)net>
To: Steve <cheetah(at)tanabi(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Question about memory allocations
Date: 2007-04-13 18:23:08
Message-ID: E1HcQQa-0004MS-5s@elasmtp-masked.atl.sa.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

At 12:38 PM 4/13/2007, Steve wrote:
>>Really?
>>
>>Wow!
>>
>>Common wisdom in the past has been that values above a couple of hundred
>>MB will degrade performance. Have you done any benchmarks on 8.2.x that
>>show that you get an improvement from this, or did you just take the
>>"too much of a good thing is wonderful" approach?
>
> Not to be rude, but there's more common wisdom on this
> particular subject than anything else in postgres I'd say ;) I
> think I recently read someone else on this list who's
> laundry-listed the recommended memory values that are out there
> these days and pretty much it ranges from what you've just said to
> "half of system memory".
>
> I've tried many memory layouts, and in my own experience
> with this huge DB, more -does- appear to be better but marginally
> so; more memory alone won't fix a speed problem. It may be a
> function of how much reading/writing is done to the DB and if fsync
> is used or not if that makes any sense :) Seems there's no "silver
> bullet" to the shared_memory question. Or if there is, nobody can
> agree on it ;)

One of the reasons for the wide variance in suggested values for pg
memory use is that pg 7.x and pg 8.x are =very= different beasts.

If you break the advice into pg 7.x and pg 8.x categories, you find
that there is far less variation in the suggestions.

Bottom line: pg 7.x could not take advantage of larger sums of memory
anywhere near as well as pg 8.x can.

Cheers,
Ron

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Carlos Moreno 2007-04-13 18:53:53 Re: Question about memory allocations
Previous Message Steve 2007-04-13 16:38:17 Re: Question about memory allocations