pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedHow much ram is too much
20+ messages / 11 participants
[nested] [flat]
* How much ram is too much
@ 2007-06-08 16:31 Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:46 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-08 16:52 ` Re: How much ram is too much Ben <bench@silentmedia.com>
2007-06-11 03:11 ` Re: How much ram is too much Jim Nasby <decibel@decibel.org>
0 siblings, 3 replies; 20+ messages in thread
From: Dave Cramer @ 2007-06-08 16:31 UTC (permalink / raw)
To: pgsql-performance
Is it possible that providing 128G of ram is too much ? Will other
systems in the server bottleneck ?
Dave
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
@ 2007-06-08 16:46 ` Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-08 17:08 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
2 siblings, 1 reply; 20+ messages in thread
From: Guy Rouillier @ 2007-06-08 16:46 UTC (permalink / raw)
To: pgsql-performance
Dave Cramer wrote:
> Is it possible that providing 128G of ram is too much ? Will other
> systems in the server bottleneck ?
What CPU and OS are you considering?
--
Guy Rouillier
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:46 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
@ 2007-06-08 17:08 ` Dave Cramer <pg@fastcrypt.com>
2007-06-08 17:38 ` [OT] Re: How much ram is too much Zoltan Boszormenyi <zb@cybertec.at>
2007-06-08 19:41 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
0 siblings, 2 replies; 20+ messages in thread
From: Dave Cramer @ 2007-06-08 17:08 UTC (permalink / raw)
To: Guy Rouillier <guyr-ml1@burntmail.com>; +Cc: pgsql-performance
It's an IBM x3850 using linux redhat 4.0
On 8-Jun-07, at 12:46 PM, Guy Rouillier wrote:
> Dave Cramer wrote:
>> Is it possible that providing 128G of ram is too much ? Will other
>> systems in the server bottleneck ?
>
> What CPU and OS are you considering?
>
> --
> Guy Rouillier
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
^ permalink raw reply [nested|flat] 20+ messages in thread
* [OT] Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:46 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-08 17:08 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
@ 2007-06-08 17:38 ` Zoltan Boszormenyi <zb@cybertec.at>
2007-06-08 18:10 ` Re: [OT] Re: How much ram is too much Joshua D. Drake <jd@commandprompt.com>
1 sibling, 1 reply; 20+ messages in thread
From: Zoltan Boszormenyi @ 2007-06-08 17:38 UTC (permalink / raw)
To: Dave Cramer <pg@fastcrypt.com>; +Cc: Guy Rouillier <guyr-ml1@burntmail.com>; pgsql-performance
Dave Cramer írta:
> It's an IBM x3850 using linux redhat 4.0
Isn't that a bit old? I have a RedHat 4.2 somewhere
that was bundled with Applixware 3. :-)
--
----------------------------------
Zoltán Böszörményi
Cybertec Geschwinde & Schönig GmbH
http://www.postgresql.at/
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [OT] Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:46 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-08 17:08 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 17:38 ` [OT] Re: How much ram is too much Zoltan Boszormenyi <zb@cybertec.at>
@ 2007-06-08 18:10 ` Joshua D. Drake <jd@commandprompt.com>
2007-06-08 18:52 ` Re: [OT] Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 18:54 ` Re: [OT] Re: How much ram is too much Zoltan Boszormenyi <zb@cybertec.at>
0 siblings, 2 replies; 20+ messages in thread
From: Joshua D. Drake @ 2007-06-08 18:10 UTC (permalink / raw)
To: Zoltan Boszormenyi <zb@cybertec.at>; +Cc: Dave Cramer <pg@fastcrypt.com>; Guy Rouillier <guyr-ml1@burntmail.com>; pgsql-performance
Zoltan Boszormenyi wrote:
> Dave Cramer írta:
>> It's an IBM x3850 using linux redhat 4.0
>
> Isn't that a bit old? I have a RedHat 4.2 somewhere
> that was bundled with Applixware 3. :-)
He means redhat ES/AS 4 I assume.
J
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [OT] Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:46 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-08 17:08 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 17:38 ` [OT] Re: How much ram is too much Zoltan Boszormenyi <zb@cybertec.at>
2007-06-08 18:10 ` Re: [OT] Re: How much ram is too much Joshua D. Drake <jd@commandprompt.com>
@ 2007-06-08 18:52 ` Dave Cramer <pg@fastcrypt.com>
1 sibling, 0 replies; 20+ messages in thread
From: Dave Cramer @ 2007-06-08 18:52 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Zoltan Boszormenyi <zb@cybertec.at>; Guy Rouillier <guyr-ml1@burntmail.com>; pgsql-performance
On 8-Jun-07, at 2:10 PM, Joshua D. Drake wrote:
> Zoltan Boszormenyi wrote:
>> Dave Cramer írta:
>>> It's an IBM x3850 using linux redhat 4.0
>> Isn't that a bit old? I have a RedHat 4.2 somewhere
>> that was bundled with Applixware 3. :-)
>
> He means redhat ES/AS 4 I assume.
>
Yes AS4
> J
>
>
>
>
> --
>
> === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
> Providing the most comprehensive PostgreSQL solutions since 1997
> http://www.commandprompt.com/
>
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/
> donate
> PostgreSQL Replication: http://www.commandprompt.com/products/
>
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [OT] Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:46 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-08 17:08 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 17:38 ` [OT] Re: How much ram is too much Zoltan Boszormenyi <zb@cybertec.at>
2007-06-08 18:10 ` Re: [OT] Re: How much ram is too much Joshua D. Drake <jd@commandprompt.com>
@ 2007-06-08 18:54 ` Zoltan Boszormenyi <zb@cybertec.at>
2007-06-08 19:00 ` Re: [OT] Re: How much ram is too much mark@mark.mielke.cc
2007-06-08 21:43 ` Re: [OT] Re: How much ram is too much Andreas Kostyrka <andreas@kostyrka.org>
1 sibling, 2 replies; 20+ messages in thread
From: Zoltan Boszormenyi @ 2007-06-08 18:54 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Dave Cramer <pg@fastcrypt.com>; Guy Rouillier <guyr-ml1@burntmail.com>; pgsql-performance
Joshua D. Drake írta:
> Zoltan Boszormenyi wrote:
>> Dave Cramer írta:
>>> It's an IBM x3850 using linux redhat 4.0
>>
>> Isn't that a bit old? I have a RedHat 4.2 somewhere
>> that was bundled with Applixware 3. :-)
>
> He means redhat ES/AS 4 I assume.
>
> J
I guessed that, hence the smiley.
But it's very unfortunate that version numbers
are reused - it can cause confusion.
There was a RH 4.0 already a long ago,
when the commercial and the community
version were the same. I think Microsoft
will avoid reusing its versions when year 2095 comes. :-)
--
----------------------------------
Zoltán Böszörményi
Cybertec Geschwinde & Schönig GmbH
http://www.postgresql.at/
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [OT] Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:46 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-08 17:08 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 17:38 ` [OT] Re: How much ram is too much Zoltan Boszormenyi <zb@cybertec.at>
2007-06-08 18:10 ` Re: [OT] Re: How much ram is too much Joshua D. Drake <jd@commandprompt.com>
2007-06-08 18:54 ` Re: [OT] Re: How much ram is too much Zoltan Boszormenyi <zb@cybertec.at>
@ 2007-06-08 19:00 ` mark@mark.mielke.cc
2007-06-08 19:14 ` Re: [OT] Re: How much ram is too much Zoltan Boszormenyi <zb@cybertec.at>
1 sibling, 1 reply; 20+ messages in thread
From: mark@mark.mielke.cc @ 2007-06-08 19:00 UTC (permalink / raw)
To: Zoltan Boszormenyi <zb@cybertec.at>; +Cc: Joshua D. Drake <jd@commandprompt.com>; Dave Cramer <pg@fastcrypt.com>; Guy Rouillier <guyr-ml1@burntmail.com>; pgsql-performance
On Fri, Jun 08, 2007 at 08:54:39PM +0200, Zoltan Boszormenyi wrote:
> Joshua D. Drake írta:
> >Zoltan Boszormenyi wrote:
> >>Dave Cramer írta:
> >>>It's an IBM x3850 using linux redhat 4.0
> >>Isn't that a bit old? I have a RedHat 4.2 somewhere
> >>that was bundled with Applixware 3. :-)
> >He means redhat ES/AS 4 I assume.
> I guessed that, hence the smiley.
> But it's very unfortunate that version numbers
> are reused - it can cause confusion.
> There was a RH 4.0 already a long ago,
> when the commercial and the community
> version were the same. I think Microsoft
> will avoid reusing its versions when year 2095 comes. :-)
He should have written RHEL 4.0. RH 4.0 is long enough ago, though,
that I think few would assume it meant the much older release.
You'll find a similar thing with products like "CuteFTP 7.0" or
"CuteFTP Pro 3.0".
Cheers,
mark
--
mark@mielke.cc / markm@ncf.ca / markm@nortel.com __________________________
. . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder
|\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ |
| | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada
One ring to rule them all, one ring to find them, one ring to bring them all
and in the darkness bind them...
http://mark.mielke.cc/
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [OT] Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:46 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-08 17:08 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 17:38 ` [OT] Re: How much ram is too much Zoltan Boszormenyi <zb@cybertec.at>
2007-06-08 18:10 ` Re: [OT] Re: How much ram is too much Joshua D. Drake <jd@commandprompt.com>
2007-06-08 18:54 ` Re: [OT] Re: How much ram is too much Zoltan Boszormenyi <zb@cybertec.at>
2007-06-08 19:00 ` Re: [OT] Re: How much ram is too much mark@mark.mielke.cc
@ 2007-06-08 19:14 ` Zoltan Boszormenyi <zb@cybertec.at>
0 siblings, 0 replies; 20+ messages in thread
From: Zoltan Boszormenyi @ 2007-06-08 19:14 UTC (permalink / raw)
To: mark@mark.mielke.cc; +Cc: Joshua D. Drake <jd@commandprompt.com>; Dave Cramer <pg@fastcrypt.com>; Guy Rouillier <guyr-ml1@burntmail.com>; pgsql-performance
mark@mark.mielke.cc írta:
> On Fri, Jun 08, 2007 at 08:54:39PM +0200, Zoltan Boszormenyi wrote:
>
>> Joshua D. Drake írta:
>>
>>> Zoltan Boszormenyi wrote:
>>>
>>>> Dave Cramer írta:
>>>>
>>>>> It's an IBM x3850 using linux redhat 4.0
>>>>>
>>>> Isn't that a bit old? I have a RedHat 4.2 somewhere
>>>> that was bundled with Applixware 3. :-)
>>>>
>>> He means redhat ES/AS 4 I assume.
>>>
>> I guessed that, hence the smiley.
>> But it's very unfortunate that version numbers
>> are reused - it can cause confusion.
>> There was a RH 4.0 already a long ago,
>> when the commercial and the community
>> version were the same. I think Microsoft
>> will avoid reusing its versions when year 2095 comes. :-)
>>
>
> He should have written RHEL 4.0. RH 4.0 is long enough ago, though,
> that I think few would assume it meant the much older release.
>
Yes. But up until RHEL 8.0/9.0 ( or plain 9 without decimals ;-) )
I can make cheap jokes telling that I can give you a free upgrade. :-)
> You'll find a similar thing with products like "CuteFTP 7.0" or
> "CuteFTP Pro 3.0".
>
I am sure there are others, too. But enough of this OT,
I am really interested in the main thread's topic.
Best regards,
--
----------------------------------
Zoltán Böszörményi
Cybertec Geschwinde & Schönig GmbH
http://www.postgresql.at/
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [OT] Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:46 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-08 17:08 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 17:38 ` [OT] Re: How much ram is too much Zoltan Boszormenyi <zb@cybertec.at>
2007-06-08 18:10 ` Re: [OT] Re: How much ram is too much Joshua D. Drake <jd@commandprompt.com>
2007-06-08 18:54 ` Re: [OT] Re: How much ram is too much Zoltan Boszormenyi <zb@cybertec.at>
@ 2007-06-08 21:43 ` Andreas Kostyrka <andreas@kostyrka.org>
1 sibling, 0 replies; 20+ messages in thread
From: Andreas Kostyrka @ 2007-06-08 21:43 UTC (permalink / raw)
To: Zoltan Boszormenyi <zb@cybertec.at>; +Cc: Joshua D. Drake <jd@commandprompt.com>; Dave Cramer <pg@fastcrypt.com>; Guy Rouillier <guyr-ml1@burntmail.com>; pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Zoltan Boszormenyi wrote:
> Joshua D. Drake írta:
>> Zoltan Boszormenyi wrote:
>>> Dave Cramer írta:
>>>> It's an IBM x3850 using linux redhat 4.0
>>>
>>> Isn't that a bit old? I have a RedHat 4.2 somewhere
>>> that was bundled with Applixware 3. :-)
>>
>> He means redhat ES/AS 4 I assume.
>>
>> J
>
> I guessed that, hence the smiley.
> But it's very unfortunate that version numbers
> are reused - it can cause confusion.
> There was a RH 4.0 already a long ago,
> when the commercial and the community
> version were the same. I think Microsoft
> will avoid reusing its versions when year 2095 comes. :-)
Well, RedHat Linux, and RedHat Linux Enterprise Server/Advanced Servers
are clearly different products :-P
And yes, I even owned Applix :)
Andreas
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGac2FHJdudm4KnO0RAkpcAJwI+RTIJgAc5Db1bnsu7tRNiU9vzACeIGvl
LP0CSxc5dML0BMerI+u1xYc=
=qiye
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:46 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-08 17:08 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
@ 2007-06-08 19:41 ` Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-11 10:55 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
1 sibling, 1 reply; 20+ messages in thread
From: Guy Rouillier @ 2007-06-08 19:41 UTC (permalink / raw)
To: pgsql-performance
Dave Cramer wrote:
> It's an IBM x3850 using linux redhat 4.0
I had to look that up, web site says it is a 4-processor, dual-core (so
8 cores) Intel Xeon system. It also says "Up to 64GB DDR II ECC
memory", so are you sure you can even get 128 GB RAM?
If you could, I'd expect diminishing returns from the Xeon northbridge
memory access. If you are willing to spend that kind of money on
memory, you'd be better off with Opteron or Sparc.
--
Guy Rouillier
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:46 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-08 17:08 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 19:41 ` Re: How much ram is too much Guy Rouillier <guyr-ml1@burntmail.com>
@ 2007-06-11 10:55 ` Dave Cramer <pg@fastcrypt.com>
0 siblings, 0 replies; 20+ messages in thread
From: Dave Cramer @ 2007-06-11 10:55 UTC (permalink / raw)
To: Guy Rouillier <guyr-ml1@burntmail.com>; +Cc: pgsql-performance
Actually this one is an opteron, so it looks like it's all good.
Dave
On 8-Jun-07, at 3:41 PM, Guy Rouillier wrote:
> Dave Cramer wrote:
>> It's an IBM x3850 using linux redhat 4.0
>
> I had to look that up, web site says it is a 4-processor, dual-core
> (so 8 cores) Intel Xeon system. It also says "Up to 64GB DDR II
> ECC memory", so are you sure you can even get 128 GB RAM?
>
> If you could, I'd expect diminishing returns from the Xeon
> northbridge memory access. If you are willing to spend that kind
> of money on memory, you'd be better off with Opteron or Sparc.
>
> --
> Guy Rouillier
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
@ 2007-06-08 16:52 ` Ben <bench@silentmedia.com>
2007-06-08 17:30 ` Re: How much ram is too much david@lang.hm
2 siblings, 1 reply; 20+ messages in thread
From: Ben @ 2007-06-08 16:52 UTC (permalink / raw)
To: Dave Cramer <pg@fastcrypt.com>; +Cc: pgsql-performance
What is your expected data size and usage pattern? What are the other
components in the system?
On Fri, 8 Jun 2007, Dave Cramer wrote:
> Is it possible that providing 128G of ram is too much ? Will other systems in
> the server bottleneck ?
>
> Dave
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:52 ` Re: How much ram is too much Ben <bench@silentmedia.com>
@ 2007-06-08 17:30 ` david@lang.hm
2007-06-08 17:38 ` Re: How much ram is too much Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 20+ messages in thread
From: david@lang.hm @ 2007-06-08 17:30 UTC (permalink / raw)
To: Ben <bench@silentmedia.com>; +Cc: Dave Cramer <pg@fastcrypt.com>; pgsql-performance
> On Fri, 8 Jun 2007, Dave Cramer wrote:
>
>> Is it possible that providing 128G of ram is too much ? Will other systems
>> in the server bottleneck ?
the only way 128G of ram would be too much is if your total database size
(including indexes) is smaller then this.
now it may not gain you as much of an advantage going from 64G to 128G as
it does going from 32G to 64G, but that depends on many variables as
others have been asking.
David Lang
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:52 ` Re: How much ram is too much Ben <bench@silentmedia.com>
2007-06-08 17:30 ` Re: How much ram is too much david@lang.hm
@ 2007-06-08 17:38 ` Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 20+ messages in thread
From: Joshua D. Drake @ 2007-06-08 17:38 UTC (permalink / raw)
To: david@lang.hm; +Cc: Ben <bench@silentmedia.com>; Dave Cramer <pg@fastcrypt.com>; pgsql-performance
david@lang.hm wrote:
>> On Fri, 8 Jun 2007, Dave Cramer wrote:
>>
>>> Is it possible that providing 128G of ram is too much ? Will other
>>> systems
>>> in the server bottleneck ?
>
> the only way 128G of ram would be too much is if your total database
> size (including indexes) is smaller then this.
>
> now it may not gain you as much of an advantage going from 64G to 128G
> as it does going from 32G to 64G, but that depends on many variables as
> others have been asking.
I don't know about the IBM but I know some of the HPs require slower ram
to actually get to 128G.
Joshua D. Drake
>
> David Lang
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
@ 2007-06-11 03:11 ` Jim Nasby <decibel@decibel.org>
2007-06-11 15:09 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
2 siblings, 1 reply; 20+ messages in thread
From: Jim Nasby @ 2007-06-11 03:11 UTC (permalink / raw)
To: Dave Cramer <pg@fastcrypt.com>; +Cc: pgsql-performance
On Jun 8, 2007, at 11:31 AM, Dave Cramer wrote:
> Is it possible that providing 128G of ram is too much ? Will other
> systems in the server bottleneck ?
Providing to what? PostgreSQL? The OS? My bet is that you'll run into
issues with how shared_buffers are managed if you actually try and
set them to anything remotely close to 128GB.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-11 03:11 ` Re: How much ram is too much Jim Nasby <decibel@decibel.org>
@ 2007-06-11 15:09 ` Dave Cramer <pg@fastcrypt.com>
2007-06-11 15:34 ` Re: How much ram is too much Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 20+ messages in thread
From: Dave Cramer @ 2007-06-11 15:09 UTC (permalink / raw)
To: Jim Nasby <decibel@decibel.org>; +Cc: pgsql-performance
On 10-Jun-07, at 11:11 PM, Jim Nasby wrote:
> On Jun 8, 2007, at 11:31 AM, Dave Cramer wrote:
>> Is it possible that providing 128G of ram is too much ? Will other
>> systems in the server bottleneck ?
>
> Providing to what? PostgreSQL? The OS? My bet is that you'll run
> into issues with how shared_buffers are managed if you actually try
> and set them to anything remotely close to 128GB.
Well, we'd give 25% of it to postgres, and the rest to the OS.
What is it specifically you are referring to ?
Dave
> --
> Jim Nasby jim@nasby.net
> EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-11 03:11 ` Re: How much ram is too much Jim Nasby <decibel@decibel.org>
2007-06-11 15:09 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
@ 2007-06-11 15:34 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-06-11 17:22 ` Re: How much ram is too much Dave Cramer <davec@fastcrypt.com>
2007-06-11 17:59 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
0 siblings, 2 replies; 20+ messages in thread
From: Andrew Sullivan @ 2007-06-11 15:34 UTC (permalink / raw)
To: pgsql-performance
On Mon, Jun 11, 2007 at 11:09:42AM -0400, Dave Cramer wrote:
> >and set them to anything remotely close to 128GB.
>
> Well, we'd give 25% of it to postgres, and the rest to the OS.
Are you quite sure that PostgreSQL's management of the buffers is
efficient with such a large one? In the past, that wasn't the case
for relatively small buffers; with the replacement of single-pass
LRU, that has certainly changed, but I'd be surprised if anyone
tested a buffer as large as 32G.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
--George Orwell
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-11 03:11 ` Re: How much ram is too much Jim Nasby <decibel@decibel.org>
2007-06-11 15:09 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-11 15:34 ` Re: How much ram is too much Andrew Sullivan <ajs@crankycanuck.ca>
@ 2007-06-11 17:22 ` Dave Cramer <davec@fastcrypt.com>
1 sibling, 0 replies; 20+ messages in thread
From: Dave Cramer @ 2007-06-11 17:22 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; +Cc: pgsql-performance
Hi Andrew
On 11-Jun-07, at 11:34 AM, Andrew Sullivan wrote:
> On Mon, Jun 11, 2007 at 11:09:42AM -0400, Dave Cramer wrote:
>>> and set them to anything remotely close to 128GB.
>>
>> Well, we'd give 25% of it to postgres, and the rest to the OS.
>
> Are you quite sure that PostgreSQL's management of the buffers is
> efficient with such a large one?
No, I'm not sure of this.
> In the past, that wasn't the case
> for relatively small buffers; with the replacement of single-pass
> LRU, that has certainly changed, but I'd be surprised if anyone
> tested a buffer as large as 32G.
So does anyone have experience above 32G ?
Dave
>
> A
>
> --
> Andrew Sullivan | ajs@crankycanuck.ca
> The whole tendency of modern prose is away from concreteness.
> --George Orwell
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: How much ram is too much
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-11 03:11 ` Re: How much ram is too much Jim Nasby <decibel@decibel.org>
2007-06-11 15:09 ` Re: How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-11 15:34 ` Re: How much ram is too much Andrew Sullivan <ajs@crankycanuck.ca>
@ 2007-06-11 17:59 ` Dave Cramer <pg@fastcrypt.com>
1 sibling, 0 replies; 20+ messages in thread
From: Dave Cramer @ 2007-06-11 17:59 UTC (permalink / raw)
To: pgsql-performance
Hi Andrew
On 11-Jun-07, at 11:34 AM, Andrew Sullivan wrote:
> On Mon, Jun 11, 2007 at 11:09:42AM -0400, Dave Cramer wrote:
>>> and set them to anything remotely close to 128GB.
>>
>> Well, we'd give 25% of it to postgres, and the rest to the OS.
>
> Are you quite sure that PostgreSQL's management of the buffers is
> efficient with such a large one?
No, I'm not sure of this.
> In the past, that wasn't the case
> for relatively small buffers; with the replacement of single-pass
> LRU, that has certainly changed, but I'd be surprised if anyone
> tested a buffer as large as 32G.
So does anyone have experience above 32G ?
Dave
>
> A
>
> -- Andrew Sullivan | ajs@crankycanuck.ca
> The whole tendency of modern prose is away from concreteness.
> --George Orwell
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
^ permalink raw reply [nested|flat] 20+ messages in thread
end of thread, other threads:[~2007-06-11 17:59 UTC | newest]
Thread overview: 20+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-08 16:31 How much ram is too much Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:46 ` Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-08 17:08 ` Dave Cramer <pg@fastcrypt.com>
2007-06-08 17:38 ` Zoltan Boszormenyi <zb@cybertec.at>
2007-06-08 18:10 ` Joshua D. Drake <jd@commandprompt.com>
2007-06-08 18:52 ` Dave Cramer <pg@fastcrypt.com>
2007-06-08 18:54 ` Zoltan Boszormenyi <zb@cybertec.at>
2007-06-08 19:00 ` mark@mark.mielke.cc
2007-06-08 19:14 ` Zoltan Boszormenyi <zb@cybertec.at>
2007-06-08 21:43 ` Andreas Kostyrka <andreas@kostyrka.org>
2007-06-08 19:41 ` Guy Rouillier <guyr-ml1@burntmail.com>
2007-06-11 10:55 ` Dave Cramer <pg@fastcrypt.com>
2007-06-08 16:52 ` Ben <bench@silentmedia.com>
2007-06-08 17:30 ` david@lang.hm
2007-06-08 17:38 ` Joshua D. Drake <jd@commandprompt.com>
2007-06-11 03:11 ` Jim Nasby <decibel@decibel.org>
2007-06-11 15:09 ` Dave Cramer <pg@fastcrypt.com>
2007-06-11 15:34 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-06-11 17:22 ` Dave Cramer <davec@fastcrypt.com>
2007-06-11 17:59 ` Dave Cramer <pg@fastcrypt.com>
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