Re: Re: Red Hat to support PostgreSQL

So does this impact Postgresql's performance on Windows as well?  I think Apache
had to rewrite their Windows port to use threads instead of processes before
they got decent performance on that platform.  Any chance of Postgresql doing
that sort of thing?  Not that I'm asking for the change; I'd just as soon use
this as one more reason to keep running it on linux.  :-)

--Wes




Bruce Momjian <pgman%candle.pha.pa.us@interlock.lexmark.com> on 06/27/2001
06:58:18 PM

To:   Philip Molter <philip%datafoundry.net@interlock.lexmark.com>
cc:   Lamar Owen <lamar.owen%wgcr.org@interlock.lexmark.com>, Tim Barnard
      <tbarnard%povn.com@interlock.lexmark.com>,
      pgsql-general%postgresql.org@interlock.lexmark.com (bcc: Wesley
      Sheldahl/Lex/Lexmark)
Subject:  Re: [GENERAL] Re: Red Hat to support PostgreSQL


> I had almost given up on using Postgres for this system because under
> Solaris, it just couldn't cut it (MySQL could do the work with one CPU
> while Postgres took up even more CPU and required *both* CPUs to be
> enabled), but when we moved the system to a Linux box, things worked
> much better.

Ah, back to a PostgreSQL topic.  :-)

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.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster