Shridhar Daithankar <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> And that helps how? The problem is to detect whether there are any
>> children left from the old postmaster, when what you have to work from
>> is the pid-file it left behind.
> fine. We need shared memory for that. How about us
Tom Lane wrote:
Shridhar Daithankar <[EMAIL PROTECTED]> writes:
I covered only first point in my post. IMO it is not such a unsolvable
problem. If a postmaster crashes hard but leaves a backend running,
would it clean pid file etc? I don't think so. So if a postmaster can
start on a 'pid-clean'
Shridhar Daithankar wrote:
> There seem to be two objections to mmap.
>
> 1. If a backend from last crashed running postmaster exists then it might
> have file etc. open and that is in general not such a good idea
>
> 2. For replacing stdio for data and WAL files with mmap, mmap does not
> guar
Tom Lane wrote:
> Shridhar Daithankar <[EMAIL PROTECTED]> writes:
> > I covered only first point in my post. IMO it is not such a unsolvable
> > problem. If a postmaster crashes hard but leaves a backend running,
> > would it clean pid file etc? I don't think so. So if a postmaster can
> > start o
Shridhar Daithankar <[EMAIL PROTECTED]> writes:
> I covered only first point in my post. IMO it is not such a unsolvable
> problem. If a postmaster crashes hard but leaves a backend running,
> would it clean pid file etc? I don't think so. So if a postmaster can
> start on a 'pid-clean' state, the
Tom Lane wrote:
Shridhar Daithankar <[EMAIL PROTECTED]> writes:
I was looking thr. the source and thought it would be worth to seek
opinion on this proposal.
This has been discussed and rejected before. See the archives.
I went thr. this for details.
http://developer.postgresql.org/cvsweb.cgi/pg
> In case of WAL per database, the operations done on a shared catalog from a
> backend would need flushing system WAL and database WAL to ensure such
> transaction commit. Otherwise only flushing database WAL would do.
I don't think that is a good idea. If you want databases separated you shou
Shridhar Daithankar <[EMAIL PROTECTED]> writes:
> I was looking thr. the source and thought it would be worth to seek
> opinion on this proposal.
This has been discussed and rejected before. See the archives.
regards, tom lane
---(end of broadcast
Hello All,
I was looking thr. the source and thought it would be worth to seek opinion on
this proposal.
From what I understood so far, the core shared memory handling is done in
pgsql/src/backend/port/sysv_shmem.c. It is linked by configure as per the
runtime environment.
So I need to write
