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
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 ? |