Search Postgresql Archives

Re: Deep integration of PostgreSQL with Apache

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



--- Thomas Hallgren <thhal@xxxxxxxxxxxxxx> wrote:
> Robin Boerdijk wrote:
> > Hi,
> > 
> > Apologies if this has been discussed before, but I was wondering if
> > there have been any efforts in the past to provide a deep
> integration
> > of PostgreSQL with Apache. What I mean by deep integration is that
> the
> > PostgreSQL server logic runs inside the Apache server processes,
> rather
> > than separate processes. In particular, the postmaster server logic
> > would run inside the Apache master process and the postgres server
> > logic would run inside Apache child processes.
> > 
> > The main advantage of this approach would be that it avoids the
> > Apache/PostgreSQL context switch when executing SQL requests from
> the
> > web server. It looks like the Apache server and PostgreSQL server
> > architectures are quite similar to make this feasible. Any
> thoughts?
> > 
> The PostgreSQL backend is inherently single-threaded and a new
> process 
> is forked each time you establish a new connection (session) so the 
> integration you ask for is not in anyway possible unless you are
> content 
> with one single database connection.

I agree that it is not trivial, but is it feasible? Specifically, I'm
thinking about the following approach:

1. Strip all networking logic and the logic that manages the postgres
child servers from the postmaster server. The logic that remains is
code that manages the auxiliary processes such as the bgwriter and
statistics collector. Integrate this remaining logic in the the Apache
master server.

2. Strip all networking logic from the postgres server. The logic that
remains is logic for executing queries against the database. Integrate
this remaining logic in the Apache child server.

The result of this is an integrated web/database server where all
networking is handled by Apache instead of postmaster/postgres. Other
than that, I see no difference with the way PostgreSQL works out of the
box. The Apache master server functions as the postmaster (i.e.
managing the child server processes) and the Apache child servers
function as the postgres servers (i.e. access the database). Why would
this web/database server be limited to using only one connection?

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux