Re: pg_pconnect - ??

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



> Ok, so from what I see on here, pg_pconnect doesn't have any
> advantages over pg_connect in my situation. I have the web server
> running on the same machine as the database server and yes, I have
> allocated 16384 shared buffers (at 8 KB each, this is 128 MB of
> shared memory). I have not noticed any connect overhead when opening
> a web page which connects to the database (99% of them do), the
> connection is instantaneously, so I guess, I don't need to do
> anything here.

Well it does take time to startup another pg process, it's just a tiny
amount of time with your current utilization. Sometimes a few miliseconds
can add up (say if you were spawning many processes per second).. Still,
you're right, it doesn't look like persistant connections are going to offer
you much increase in performance so I wouldn't bother.. Note that I've
*alway* had problems getting them to even work correctly with PHP --
supposedly things were fixed in alter 4.0.x releases but I've not tested it
much to say for certain.

> I was under the impression, that a persistent connection would open
> one and only one process which then will be used all the time without
> creating more child processes which keep lingering about. I guess, I
> was wrong here ...

That's a pretty common misunderstanding about what persistent conenctions
are, no worries..


-Mitchell




[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux