Re: Regarding drop index

e. > > Regards, > Abinaya K > > -- Ivan Novick, Product Manager Pivotal Greenplum inov...@pivotal.io -- (Mobile) 408-230-6491 https://www.youtube.com/GreenplumDatabase

Re: Built-in connection pooling

> The simplest thing sounds like a GUC that will automitcally end a connection > > idle for X seconds. > > Uh, we already have idle_in_transaction_session_timeout so we would just > need a simpler version. > Oh i see its in 9.6, AWESOME! Cheers

Re: Built-in connection pooling

On Sat, Jan 27, 2018 at 4:40 PM, Bruce Momjian wrote: > On Mon, Jan 22, 2018 at 06:51:08PM +0100, Tomas Vondra wrote: > Right now, if you hit max_connections, we start rejecting new > connections. Would it make sense to allow an option to exit idle > connections when this happens so new users ca

Re: Builtin connection polling

is why attempt to start pgbench with multistatement transactions > (-N) will fail if number of threads (-j) is smaller than number of > connections (-c). > 6. The approach with passing socket descriptors between processes was > implemented only for Unix and tested only at Linux, although is expected to > work also as MacOS and other Unix dialects. Windows is not supported now. > > I will be glad to receive an feedback and suggestion concerning > perspectives of embedded connection pooling. > > -- > Konstantin Knizhnik > Postgres Professional: http://www.postgrespro.com > The Russian Postgres Company > > -- Ivan Novick, Product Manager Pivotal Greenplum inov...@pivotal.io -- (Mobile) 408-230-6491 https://www.youtube.com/GreenplumDatabase