Re: Restricting Postgres - Mailing list pgsql-performance

From Matt Clark
Subject Re: Restricting Postgres
Date
Msg-id 003301c4c29a$f052d910$8300a8c0@solent
Whole thread Raw
In response to Re: Restricting Postgres  (Martin Foster <martin@ethereal-realms.org>)
Responses Re: Restricting Postgres  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
Re: Restricting Postgres  (Martin Foster <martin@ethereal-realms.org>)
List pgsql-performance
> Correct the 75% of all hits are on a script that can take
> anywhere from
> a few seconds to a half an hour to complete.    The script
> essentially
> auto-flushes to the browser so they get new information as it arrives
> creating the illusion of on demand generation.

This is more like a streaming data server, which is a very different beast
from a webserver, and probably better suited to the job.  Usually either
multithreaded or single-process using select() (just like Squid).  You could
probably build one pretty easily.  Using a 30MB Apache process to serve one
client for half an hour seems like a hell of a waste of RAM.

> A squid proxy would probably cause severe problems when
> dealing with a
> script that does not complete output for a variable rate of time.

No, it's fine, squid gives it to the client as it gets it, but can receive
from the server faster.


pgsql-performance by date:

Previous
From: Martin Foster
Date:
Subject: Re: Restricting Postgres
Next
From: Simon Riggs
Date:
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?