Re: Limit on number of users in postgresql? - Mailing list pgsql-general

From John D. Burger
Subject Re: Limit on number of users in postgresql?
Date
Msg-id 97D0358D-4DF2-4A1B-A42D-8D393ABFFAF7@mitre.org
Whole thread Raw
In response to Re: Limit on number of users in postgresql?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Limit on number of users in postgresql?
List 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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: PostgreSQL 9.0
Next
From: Tom Lane
Date:
Subject: Re: 8.2 planner and "like"