Re: single task postgresql

On Wed, 27 Feb 2002, mlw wrote:

> Oleg Bartunov wrote:
> >
> > we have to support earlier windows which have no shared memory support.
>
> I'm pretty sure it could a configuration option then. Using a file is just
> plain stupid. "Every" version of Windows has supported shared memory in one
> form or another.
>
> What version are you wishing to support which the cygwin guys claim does not
> have shared memory?

We've tried windows 98 and would like to have support for ALL versions
beginning from W95.

>
> I'm prety sure I can write a shared memory interface for Windows which should
> work across all "supported" versions.
>
> (BTW I have been a Windows developer since version 1.03.)
>

great ! We have had success to run our OpenFTS under Windows but need
postgresql runs a bit faster. It'd be great if you write such interface,
so postgresql could run under older windows without shared memory.
btw, BeoS seems is supported in similar way. I think people would appreciate
this. There are still many old hardware with Windows95 installed which
could be used for desktop application based on postgresql.

>
>
> >
> > On Tue, 26 Feb 2002, mlw wrote:
> >
> > > Oleg Bartunov wrote:
> > > >
> > > > 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.
> > > >
> > > > Regards,
> > >
> > > How does cygwin do shared memory on Windows? Windows support real shared
> > > memory, surely the cygwin guys are using "real" shared memory. Are you sure
> > > that this is the problem? If so, might we not be able to use a few
> > > macros/#ifdefs to do it right?
> > >
> > > I'll be up for that if you guys don't mind some "ifdef/endif" stuff here and
> > > there.
> > >
> >
> > Regards,
> > Oleg
> > _____________________________________________________________
> > Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> > Sternberg Astronomical Institute, Moscow University (Russia)
> > Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> > phone: +007(095)939-16-83, +007(095)939-23-83
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83