SEO

#1 (**permalink**) 04-09-2008, 08:25 AM

Hi,

I will have an aplication on the web that will have many connections
because it will be looking for data.

I'm doing the main functions that will be used in PL/PGSQL, they use the
PREPARE resource, but in order to use it, I need the connection to be
permanent because the PLAN generated by PREPARE only exists while the
connection is opened.

This means, if each visitor of the website opens and closes the
connection, PREPARE is useless.

I need the connection pool for POSTGRESQL for Linux, but i don't know
how to do this.

Thanks in advance.

Marcos.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

#2 (**permalink**) 04-09-2008, 08:25 AM

On Fri, Feb 17, 2006 at 10:47:16AM +0000, Marcos wrote:
>
> Hi,
>
> I will have an aplication on the web that will have many connections
> because it will be looking for data.

<snip>

> This means, if each visitor of the website opens and closes the
> connection, PREPARE is useless.
>
> I need the connection pool for POSTGRESQL for Linux, but i don't know
> how to do this.

It's called pgpool.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFD9c3PIB7bNG8LQkwRAoXbAJ9vF11FFJlAubak40tJF+ Z5S4tUjwCbB0f8
3Ui/vzHNWnCX3IOufT5qjXE=
=THiE
-----END PGP SIGNATURE-----

#3 (**permalink**) 04-09-2008, 08:25 AM

> It's called pgpool.

I've installed it in my computer, that's o.k.

Now, how do I to know if it's working with Postgresql?

Thanks

)

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Take advantage of PREPARE (Pool of Conections)