On 10/22/2013 3:44 PM, Tom Lane wrote:
andy <andy@xxxxxxxxxxxxxxx> writes:
On 10/22/2013 2:18 PM, John R Pierce wrote:
that style of php programming, you're getting some HUGE overhead in
connect/disconnect per web page. putting pg_bouncer in the middle
will make a HUGE improvement, possibly a second per page load on a busy
server.
No, actually, I don't think my connect overhead is huge. My apache and
postgres are on the same box, and it connects using unix socket.
You're ignoring the fact that PG backends have a pretty considerable
startup transient. By the time a backend has gotten its caches populated
enough to be efficient, it's expended a lot of cycles. You might be
getting away with this approach under low load, but it will bite you in
painful places eventually.
regards, tom lane
> but it will bite you in
> painful places eventually.
:-) heh.
Well I think PG is even more impressive now. My server is on a VM, and
I'm pretty much doing things the slow way, and I get a page back in
500ms. And this is a busy time of day.
Of course, I'm right next to the server. Anyone wanna check page times
for me?
http://jasper.iowaassessors.com/parcel.php?gid=99680
I'm talking JUST parcel.php ... the maps and photos don't count.
Thanks all.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
