Re: Solaris

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Solaris
Date: 2003-04-28 11:25:40
Message-ID: 20030428112540.GA15827@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 25, 2003 at 11:19:47PM +1200, Mark Kirkwood wrote:
> Just out of curiousity, where are you seeing the effect of this the most?
> (Running through my mind is the thought that VM management in Linux is
> not so hot either....)

The problems seem to be somewhat related to load. With no load, of
course, everything is real fast. But with any sort of load, we get
occasional spikes of unexpectedly slow performance, even on things
like INSERT. Some of this I have been able to attribute to
maintenance issues, but not all of it. We see from truss, however,
that a significant amount of timee is spent in the SYSV system
calls, so it appears that there is some kind of inefficiency there.
Sorry I'm not able to provide more detail; as I say, I'm not real
happy with the extent of the tests I've been able to conduct, and in
any case, the problems aren't reproducable at will.

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

  • Re: Solaris at 2003-04-25 11:19:47 from Mark Kirkwood

Responses

  • Re: Solaris at 2003-04-29 08:59:14 from Mark Kirkwood

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-28 14:10:21 Re: Estimating space required for indexes
Previous Message Keiko Kondo 2003-04-28 08:29:42 Re: How can I know the "configure" settings of a PostgreSQL installation ?