Re: Postgresql on SUN Server

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql on SUN Server
Date: 2003-05-27 21:03:50
Message-ID: 20030527210350.GI4459@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Tue, May 27, 2003 at 02:08:12PM -0600, scott.marlowe wrote:

> I just think SYSV shared memory isn't built for handling large amounts of
> memory.

That's sort of my feeling, too, and corresponds with something Tom
Lane said recently on -performance (where I guess this oughta move)
to the effect that, since OS guys have spent years and (in some
cases) millions of dollars optimising the filesystem buffer
algorithms; and since he tried one time to alter the PostgreSQL
buffer management algorithm, and that attempt was unsuccessful;
therefore there is bound to be some point of diminishing returns in
increasing the postmaster's shared buffers, and that point is likely
to show up sooner rather than later.

> I could stand out here at the fence and chat all day... :-)

Me, too, but the fields keep a-growin'.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2003-05-27 21:35:03 Re: pl-pgsql question
Previous Message scott.marlowe 2003-05-27 20:52:31 Re: How to obtain serial generate when doing an insert?

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2003-05-27 21:38:43 Re: RBLs ... I'm tired of spam ...
Previous Message Marc G. Fournier 2003-05-27 20:41:37 RBLs ... I'm tired of spam ...