[Sqlrelay-discussion] SQLRelay and PostgreSQL session...

[Cristian P. <cri...@cl...>]

Hi, first at all I'm a new user of SQLRelay and I have a few questions:

1. Does SQLRelay keeps alive a PostgreSQL session? I say this cuz I have a
very intensive web database application. I always use and do the same query
in the database (just a call to a stored procedure as "select * from
mysp()") This sp is written in plpgsql, and each time I have to execute it
eats a lot of cpu. (mainly cuz I have to "recompile" the plpgsql, prepare
the queries and so on). The first time I run it takes around 114ms, but the
next time it would take just 15ms. I asked to the postgresql team and so on
and I get the same answer, in a web application the performance could be so
poor cuz there is no way to keep the same session alive for each web
"consumer" process. I guess is so stupid, because I'm doing the same query
everytime.
2. I've been using pgpool, and it doesn't help too much for me, certainly it
keeps a set of connection alive, but it doesn't share the same
session/connection between web consumers, so I just minimize the connection
time, not the compile/prepare time of the plpgsql stored procedures.
3. I need to have 10M connections per day, is this possible with sqlrelay?
Somebody has achieved similar performance?

Thanks a lot for your answers, Thanks again.

Cristian Prieto