Re: Limit on number of users in postgresql?

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Limit on number of users in postgresql?
Date: 2007-01-30 00:53:12
Message-ID: 97D0358D-4DF2-4A1B-A42D-8D393ABFFAF7@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I had some ideas about this slow flat file issue, but it's apparently
not yet much of an issue, in fact ...

Someone talked about the postmaster having to be "at arms' length"
from the actual tables. But I was looking at the postmaster code,
and it seems to fork a new backend as soon as select indicates
there's a new request, without checking authorization or anything
first. So why can't the new backend query the user table as normal?
Even if shared buffers are trashed, that'll only take down the new
backend, not the original postmaster, right?

Enlightenment welcome, or redirection to -developers if appropriate.

- John Burger
MITRE

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-01-30 01:00:43 Re: 8.2 planner and "like"
Previous Message Rich Shepard 2007-01-30 00:30:05 Re: PostgreSQL 9.0