Postgres Pro
Downloads
Home   >   mailing lists

Connection pooling by apache tomcat - Mailing list pgsql-admin

From srinivas oguri
Subject Connection pooling by apache tomcat
Date
Msg-id CADfH0yvnYvhoO0P=zM3UjheogQevjXyUnv4-djpyesBk_SDL_g@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
Hi Experts,

We are using apache connection pooling and we want to use the temporary tables. 

I know pgbouncer and pgpool provide DISCARD ALL command when the connection given back to pool so that temporary tables created in a session are dropped. 

Is there any way in apache connection pooling. Do anyone have experience ?

My PostgreSQL version is 9.6.

NOTE: I know that I can insist my application team to put drop temporary table in their code but there are some situations where they are not dropping.

Thanks
Srinivas

pgsql-admin by date:

Previous
From: legrand legrand
Date:
Subject: Re: pg_stat_reset influence the plan chosen ?
Next
From: "Brandl, Wolfgang"
Date:
Subject: AW: postgres pg_basebackup