Re: [ADMIN] When postgres will be faster?

From: sk(dot)list(at)comset(dot)net
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Marcin Mazurek - Multinet SA - Poznan <m(dot)mazurek(at)multinet(dot)pl>, pgsql-admin(at)postgreSQL(dot)org, pgsql-hackers(at)postgreSQL(dot)org, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, sk(dot)list(at)comset(dot)net
Subject: Re: [ADMIN] When postgres will be faster?
Date: 1999-12-01 08:53:21
Message-ID: XFMail.991201115321.sk.list@comset.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

On 30-Nov-99 Bruce Momjian wrote:
> [Charset KOI8-R unsupported, filtering to ASCII...]
>> Hi!
>>
>> On 29-Nov-99 Oleg Bartunov wrote:
>> > I'm not concern very much about speed of Postgres but mostly
>> > about its connection schema. Every new connect to database postgres
>> > forks another children. It's impossible to work with different
>>
>> fork and fork/exec are some different. postmaster forks and execute backend
>> binary.
>
> postmaster forks() and does not do an exec().

>From postmaster log:

FindExec: found "/usr/comset/dbase/bin/postgres" using argv[0]

ps ax|grep pos

10665 ? R 0:01 /usr/comset/dbase/bin/postgres main.comset.com polithit pol
13329 ? S 0:24 /usr/comset/dbase/bin/postmaster -i -D/usr/comset/dbase/dat

These samples push me thinking it was fork/exec... :-(

SKiller
--------------------------
Sergei Keler
WebMaster of "ComSet"
E-Mail: skiller(at)comset(dot)net
http://www.comset.net
--------------------------

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message sk.list 1999-12-01 09:05:42 Re: [ADMIN] When postgres will be faster?
Previous Message Tom Lane 1999-12-01 05:17:51 Re: [HACKERS] Tricky query, tricky response