Nested Loops

2018-01-30 Thread Kumar, Virendra
Can somebody help me avoid nested loops in below query: -- ap_poc_db=# explain (analyze,buffers) ap_poc_db-# select site_id, account_id FROM ap.site_exposure se ap_poc_db-# WHERE se.portfolio_id=-1191836 ap_poc_db-# AND EXISTS (select 1 from ap.catevent_flood_sc_split sp where

Re: 8.2 Autovacuum BUG ?

2018-01-30 Thread Claudio Freire
On Tue, Jan 30, 2018 at 10:55 AM, pavan95 wrote: > Hello all, > > Will a sudden restart(stop/start) of a postgres database will generate this > huge WAL? Shouldn't

Re: SV: pgaudit and create postgis extension logs a lot inserts

2018-01-30 Thread Bruce Momjian
On Fri, Jan 19, 2018 at 11:03:42AM +, Svensson Peter wrote: > > A test to create postgis extension made 4 rsyslog processes run for several > minutes with high cpu util, > and when you have only 8 cpu:s this take lot of resources. > The create command also have to wait until all the log are

Re: 8.2 Autovacuum BUG ?

2018-01-30 Thread pavan95
Hello all, Will a sudden restart(stop/start) of a postgres database will generate this huge WAL? Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html