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

Re: single task postgresql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: single task postgresql
Date: 2002-02-26 23:43:56
Message-ID: 18183.1014767036@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> Having frustrated with performance on Windows box I'm wondering if it's
> possible to get postgresql optimized for working without shared memory,
> say in single-task mode. It looks like it's shared memory emulation on disk
> (by cygipc daemon) is responsible for performance degradation.
> In our project we have to use Windows for desktop application and it's
> single task, so we don't need shared memory. In principle, it's possible
> to hack cygipc, so it wouldn't emulate shared memory and address calls
> to normal memory, but I'm wondering if it's possible from postgres side.

As mlw comments, that is probably not really the source of the
performance issue.  However, you should be able to hack it if you
want to check.  A standalone backend just malloc()s what would otherwise
be the shared memory area.  As a first approximation you could just fire
up a standalone backend and see if it seems any faster.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: John GrayDate: 2002-02-26 23:50:01
Subject: Re: Refactoring of command.c
Previous:From: Neil ConwayDate: 2002-02-26 23:42:11
Subject: Re: eWeek Poll: Which database is most critical to your

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