[Pgpool-general] [ADMIN] Using Postgresql as application server

[sad at bestmx.ru]

Scott Marlowe пишет:
> 2011/8/16 sad at bestmx.ru<sad at bestmx.ru>:
>> Scott Marlowe пишет:
>>> 2011/8/16 sad at bestmx.ru<sad at bestmx.ru>:
>>>> Scott Marlowe пишет:
>>>>> On Mon, Aug 15, 2011 at 11:33 AM, sad at bestmx.ru<sad at bestmx.ru>      wrote:
>>>>>> Scott Marlowe пишет:
>>>>>>> On Sat, Aug 13, 2011 at 9:57 AM, c k<shreeseva.learning at gmail.com>
>>>>>>>   wrote:
>>>>>>>> Dear Postgres users,
>>>>>>>> from last few months I am reading and searching for can postgresql
>>>>>>>> used
>>>>>>>> as
>>>>>>>> application server? As postgresql supports many languages like
>>>>>>>> pl/perl,
>>>>>>> Besides the previously mentioned nginx module there's apache's mod
>>>>>>> libpq http://asmith.id.au/mod_libpq.html
>>>>>>>
>>>>>>> But I'd stick to a language to wrap stuff in like php etc.
>>>>>> BTW, string concatenation in postgresql (plpgsql) is FASTER than in PHP
>>>>> But I can throw 1,000 cores at a large load with php.  Much harder to
>>>>> do with plpgsql.
>>>> and?
>>>> all of them would inevitably connect the same postgresql
>>> And they'd each need postgresql to do a concat?  I'd hope nobody was
>>> dumb enough to program the app layer to do something like that.  PG
>>> might make a decent app server, but there's no way you could scale it
>>> to millions of users like you could a farm of app servers.
>> compare concat to index scan
> Lemme see.  Hit memcached, get data cat it on one of 1,000 cores in a
> farm. OR hit the pg server for every single request, watch my 48 core
> db server collapse in sheets of flame.  Yeah, I can see why the pg
> solution makes so much sense there.

oh! it looks like you have no need in DBMS at all
that's good for you.