Skip site navigation (1) Skip section navigation (2)

Re: Re: Red Hat to support PostgreSQL

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: Philip Molter <philip(at)datafoundry(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: Red Hat to support PostgreSQL
Date: 2001-06-28 14:45:30
Message-ID: Pine.BSO.4.10.10106281044060.7004-100000@spider.pilosoft.com (view raw or flat)
Thread:
Lists: pgsql-general
On Wed, 27 Jun 2001, Philip Molter wrote:

> On Wed, Jun 27, 2001 at 06:58:18PM -0400, Bruce Momjian wrote:
> : My guess on this one is that Solaris is slower for PostgreSQL because
> : process switching is _much_ heavier on Solaris than other OS's.  This is
> : because of the way they implemented processes in SVr4.  They got quite
> : heavy, almost requiring kernel threads so you weren't switching
> : processes all the time.   
> : 
> : In a sense threads were a solution to a process bloating problem. 
> : Linux/BSD have much lighter processes and hence work better for
> : PostgreSQL.  Again, this is only a guess.
> : 
> : MySQL does more stuff with threads while PostgreSQL switches process
> : because each backend is a process.
> 
> Does more stuff with threads?  It does all stuff with threads.  Your
> guess was our guess, which is why we tried shoving the thing over to a
> Linux box.  Now if I only I could figure out why kernel CPU usage keeps
> going up incrementally over time (went from roughly a 5% average to a
> 16% average in two days) the more we run the system.  All signs are
> pointing to postgres.
Or Linux. Try 2.4 kernel which is far better as far as SMP goes.

Regarding threads, there's a very good quote from Linus:
"Solution to slow process switching is fast process switching, not another
kernel abstraction".

> VACUUM ANALYZE-ing the tables used to reduce it back down, but now, it
> doesn't appear to be as effective (might go from 16% back down to
> 13%).  Anyone know what causes that, and better yet, anyone know how to
> fix it?  We see similar behavior under Solaris.
Look at linux profiling tools.

-alex


In response to

Responses

pgsql-general by date

Next:From: Alex PilosovDate: 2001-06-28 14:47:06
Subject: Re: Bytea?
Previous:From: Philip MolterDate: 2001-06-28 14:44:20
Subject: Re: vacuum job taking very long time to complete

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group