Re: single task postgresql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: single task postgresql
Date
Msg-id 18183.1014767036@sss.pgh.pa.us
Whole thread Raw
In response to single task postgresql  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: single task postgresql
List pgsql-hackers
Oleg Bartunov <oleg@sai.msu.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


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: eWeek Poll: Which database is most critical to your
Next
From: John Gray
Date:
Subject: Re: Refactoring of command.c