Re: Redhat 7.2.93 performance (was:Re: PostgreSQL 7.2.1-2PGDG RPMs available for RedHat-skipjack 7.2.93 and RedHat 6.2/SPARC)

From: Luciano Miguel Ferreira Rocha <strange(at)nsk(dot)yi(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Redhat 7.2.93 performance (was:Re: PostgreSQL 7.2.1-2PGDG RPMs available for RedHat-skipjack 7.2.93 and RedHat 6.2/SPARC)
Date: 2002-04-14 20:00:18
Message-ID: 20020414210018.A9457@nsk.yi.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-ports

On Sun, Apr 14, 2002 at 03:15:39PM -0400, Lamar Owen wrote:
> ISTM that improving interactive performance would also improve multiuser
> performance in a server, as low latency and kernel preemption can increase
> multiuser server responsiveness.
I doubt any performance will increase, either on a multiuser or on a
singleuser system.

Having faster response on mouse clicks or keyboard input doesn't translate
on better overall performance, the user just has the felling that it's so.

As an example, a part of those patches causes brakes in the middle of some
loops (saving buffers to disk, etc). Then other applications that don't
depend on disk activity can have change to run, so the system seems
faster, it's more responsive. But it won't actually be faster, the system
still has to lock again and continue saving the buffers. Actually, in this
case there will be an overhead caused by checking if the kernel should
brake.

However, both projects review the Linux code, and may find, if they
haven't already, some places were a finer locking may be used, giving a
better performance in a SMP system. But it could also break some
integrity.

Those patches are not recomended for a server, and now I'm curious to
check if the -enterprise configuration has them active.

> Did you happen to report it to Red Hat's Skipjack list, or to
> bugzilla.redhat.com/bugzilla? Helps make a better dist!
Alas, a bug report saying: the system crashed, I can't login remotely,
doesn't help a lot...

Regards,
Luciano Rocha

--
Luciano Rocha, strange(at)nsk(dot)yi(dot)org

The trouble with computers is that they do what you tell them, not what
you want.
-- D. Cohen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sean Chittenden 2002-04-14 21:09:19 OT: Re: Scaling postgres
Previous Message Michael Loftis 2002-04-14 19:59:09 Re: Redhat 7.2.93 performance (was:Re: PostgreSQL 7.2.1-2PGDG RPMs available for RedHat-skipjack 7.2.93 and RedHat 6.2/SPARC)

Browse pgsql-hackers by date

  From Date Subject
Next Message Karel Zak 2002-04-14 20:13:17 Re: experimental pg_qcache patch
Previous Message Michael Loftis 2002-04-14 19:59:09 Re: Redhat 7.2.93 performance (was:Re: PostgreSQL 7.2.1-2PGDG RPMs available for RedHat-skipjack 7.2.93 and RedHat 6.2/SPARC)

Browse pgsql-ports by date

  From Date Subject
Next Message Tom Lane 2002-04-15 14:54:15 Re: PGSQL 7.2.1 compile error on Red Hat 5.2 due to peercred
Previous Message Michael Loftis 2002-04-14 19:59:09 Re: Redhat 7.2.93 performance (was:Re: PostgreSQL 7.2.1-2PGDG RPMs available for RedHat-skipjack 7.2.93 and RedHat 6.2/SPARC)