public inbox for [email protected]  

help / color / mirror / Atom feed

From: Shridhar Daithankar <[email protected]>
To: Tom Lane <[email protected]>
Cc: Robert Treat <[email protected]>
Cc: Bruce Momjian <[email protected]>
Cc: [email protected]
Subject: Re: [pgsql-www] NuSphere and PostgreSQL for windows
Date: Thu, 25 Sep 2003 19:44:50 +0530
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<1064492591.25702.2084.camel@camel>
	<[email protected]>
	<[email protected]>
	<[email protected]>

Tom Lane wrote:

> Shridhar Daithankar <[email protected]> writes:
> 
>>Considering this could be a configure time option, you mean to say
>>that even on Unix we could get threaded postgresql which would not
>>require any shared buffers but instead operate upon local shared
>>buffers only?
> 
> 
> Only if we were prepared to support multiple, no doubt incompatible
> threading libraries, which is exactly what I wasn't volunteering us for.

In my view, we have a advantage here. If we say that we would support a 
reasonable pthreads implementation, that would be good enough, because we have a 
working product in process model.

So we can let that platform catchup with threading model at it's own pace.  Till 
that time it can work in older model. We need not push really hard for platform 
incompatible threading models like say mysql have to do.

The little pthreads programming I did on linux/freeBSD tells me that it supports 
majority of features except TLS(linux2.4/linuxthreads) and per thread signals. 
IIRC HP-UX supports pthreads as well and recommends moving to that threading 
model. Solaris surely does support pthreads.

>>I am sure local buffers would be lot cheaper than shared buffers.
> On what do you base that?  It sounds like pure fantasy to me.  RAM is RAM.

For sure that is correct. But kernel interaction would matter. e.g. a linux 
kernel without pre-emption/low latency and one with all those features would 
certainly register speed and latency differences for heavily contended buffers. 
The issue will be even more grave for small amount of buffers since they will be 
contended more.

Its not about RAM. Its about how lightweight and/or efficient kernel 
implementaion of shared memory and cross-process synchronisation object is. 
Surely say linux and solaris are going to register differences..:-)

  Shridhar

view thread (25+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: [pgsql-www] NuSphere and PostgreSQL for windows
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox