Re: SQL Perfomance during autovacuum

2018-12-21 Thread Jeff Janes
On Wed, Dec 19, 2018 at 1:04 AM anand086 wrote: > > The Execution time for the above sql is 17841.467 ms during normal > operations but when autovacuum runs on table test_table, the same sql took > 1628495.850 ms (from the postgres log). > > We have noticed this increase in execution times for t

psql cli tool and connection pooling

2018-12-21 Thread DJ Coertzen
I would love to see a feature on psql cli tool where i can point it to a connection pool provider back end instead of a postgres host. I read that pgpool2 emulates a postgres server, but i've never tried it myself. I know that some languages provide connection pooling, but i'm relying heavily on ps

Re: database crash during pgbench run

2018-12-21 Thread Merlin Moncure
On Tue, Dec 11, 2018 at 10:01 AM Tom Lane wrote: > > Greg Clough writes: > >>> 2018-12-10 19:11:56 IST 23647 LOG: received fast shutdown request > >>> any idea what can cause it ? > > >> Something sent SIGINT to the postmaster. > > > My money is on the OoM (Out of Memory) killer. > > That usua