Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cWK8o-0002cj-21 for pgsql-performance@arkaria.postgresql.org; Wed, 25 Jan 2017 09:45:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cWK8n-0002OB-3X for pgsql-performance@arkaria.postgresql.org; Wed, 25 Jan 2017 09:45:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cWK8d-0002Bh-CN for pgsql-performance@postgresql.org; Wed, 25 Jan 2017 09:45:11 +0000 Received: from webmail.os-ux.com ([78.46.104.104]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cWK8U-0006ga-Ks for pgsql-performance@postgresql.org; Wed, 25 Jan 2017 09:45:10 +0000 Received: from localhost (localhost [127.0.0.1]) by webmail.os-ux.com (Postfix) with ESMTP id 146C03BDBC1 for ; Wed, 25 Jan 2017 10:45:01 +0100 (CET) Received: from webmail.os-ux.com ([127.0.0.1]) by localhost (webmail.os-ux.com [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id ST2FAL83mqeA for ; Wed, 25 Jan 2017 10:45:01 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by webmail.os-ux.com (Postfix) with ESMTP id 92D993BDBC2 for ; Wed, 25 Jan 2017 10:45:00 +0100 (CET) DKIM-Filter: OpenDKIM Filter v2.9.2 webmail.os-ux.com 92D993BDBC2 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=os-ux.com; s=8262FE2E-C2B5-11E2-BC5C-8AEC8B26ED38; t=1485337500; bh=bNqL8yWDo254Mo+PM7sAJs35AXnGMUZdBzIOQD4Ib6c=; h=Date:From:To:Message-ID:Subject:MIME-Version:Content-Type; b=DffQQF7bEaN6x+2MQE68yEwZpMc6neGGMvwDmn3/EuaTqn5a8sbLAopDtB/ebNvqy qOL8gtumBubhygOxKkK0ZigeL3iHNoDI4eEEUOPaYs5RjH1Y5Ujagv6rT0moccyWDk zFA5/Y12p9xdLBjI+qnfLeDg3ERjcfBkVIiJWjws= X-Virus-Scanned: amavisd-new at os-ux.com Received: from webmail.os-ux.com ([127.0.0.1]) by localhost (webmail.os-ux.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id oIvIla_-TgZ5 for ; Wed, 25 Jan 2017 10:45:00 +0100 (CET) Received: from webmail.os-ux.com (localhost [127.0.0.1]) by webmail.os-ux.com (Postfix) with ESMTP id 36DF73BDBC1 for ; Wed, 25 Jan 2017 10:45:00 +0100 (CET) Date: Wed, 25 Jan 2017 10:44:59 +0100 (CET) From: Vucomir Ianculov To: pgsql-performance@postgresql.org Message-ID: <475267568.900.1485337495692.JavaMail.vukomir@DESKTOP-9I7P6HN> In-Reply-To: <199526991.862.1485336217892.JavaMail.vukomir@DESKTOP-9I7P6HN> References: <199526991.862.1485336217892.JavaMail.vukomir@DESKTOP-9I7P6HN> Subject: Re: pgsql connection timeone MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_899_1866530185.1485337495690" X-Originating-IP: [78.46.104.104] X-Mailer: Zimbra 8.6.0_GA_1153 (Zimbra Desktop/7.2.8_12102_Windows) Thread-Topic: pgsql connection timeone Thread-Index: mMz1WZa2RYoUV9GvQhyI4vzgiZCVijdYPQC7 X-Pg-Spam-Score: -5.2 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org ------=_Part_899_1866530185.1485337495690 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Hi, before timeout started this was the last automatic vacuum entry's: 2017-01-25 10:47:07 EET [5995-1] LOG: automatic vacuum of table "13Tim07Tuning.pg_catalog.pg_attribute": index scans: 1 pages: 0 removed, 261 remain tuples: 3547 removed, 8812 remain buffer usage: 927 hits, 112 misses, 161 dirtied avg read rate: 1.438 MB/s, avg write rate: 2.067 MB/s system usage: CPU 0.02s/0.00u sec elapsed 0.60 sec 2017-01-25 10:47:07 EET [5995-2] LOG: automatic analyze of table "13Tim07Tuning.pg_catalog.pg_class" system usage: CPU 0.00s/0.00u sec elapsed 0.08 sec 2017-01-25 10:47:07 EET [5995-3] LOG: automatic vacuum of table "13Tim07Tuning.pg_catalog.pg_index": index scans: 1 pages: 0 removed, 10 remain tuples: 14 removed, 312 remain buffer usage: 62 hits, 5 misses, 15 dirtied avg read rate: 0.767 MB/s, avg write rate: 2.301 MB/s system usage: CPU 0.00s/0.00u sec elapsed 0.05 sec 2017-01-25 10:47:10 EET [6060-1] LOG: automatic analyze of table "12westm11.pg_catalog.pg_type" system usage: CPU 0.00s/0.00u sec elapsed 0.08 sec 2017-01-25 10:47:10 EET [6060-2] LOG: automatic analyze of table "12westm11.pg_catalog.pg_attribute" system usage: CPU 0.02s/0.01u sec elapsed 0.12 sec 2017-01-25 10:48:30 EET [28355-4597] LOG: checkpoint starting: time 2017-01-25 10:49:34 EET [6222-1]XXXX@YYYY FATAL: canceling authentication due to timeout ----- Original Message ----- From: "Vucomir Ianculov" To: pgsql-performance@postgresql.org Sent: Wednesday, January 25, 2017 11:23:39 AM Subject: [PERFORM] pgsql connection timeone Hi, i'm seeing a lot of connection time out in postgresql log 2017-01-25 11:09:47 EET [6897-1] XXX@YYY FATAL: canceling authentication due to timeout 2017-01-25 11:10:15 EET [6901-1] XXX@YYY FATAL: canceling authentication due to timeout 2017-01-25 11:10:17 EET [6902-1] xxx@YYY FATAL: canceling authentication due to timeout 2017-01-25 11:10:33 EET [6906-1] xxxx@YYY FATAL: canceling authentication due to timeout 2017-01-25 11:10:44 EET [6912-1] xxx@YYY FATAL: canceling authentication due to timeout 2017-01-25 11:10:48 EET [6913-1] xxx@YYY FATAL: canceling authentication due to timeout 2017-01-25 11:10:52 EET [6920-1] xxx@YYY: canceling authentication due to timeout 2017-01-25 11:10:52 EET [6930-1] postgres@postgres FATAL: canceling authentication due to timeout 2017-01-25 11:10:53 EET [6921-1] xxx@YYY FATAL: canceling authentication due to timeout 2017-01-25 11:11:08 EET [6933-1] xxx@YYY FATAL: canceling authentication due to timeout i also tired to login as postgres user from command line. postgres@sppgsql01:~$ psql psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. server load is ok, under 1, memory usage is also ok. root@server ~ # free -m total used free shared buff/cache available Mem: 128908 3398 795 31671 124714 92980 Swap: 8191 1418 6773 system is a ubuntu 16.04 and i'm using postgresql 9.3 connection limit is at 500 at the moment i have 180 connection, authentication_timeout is default 1 min. here is the postgresql.conf data_directory = '/var/lib/postgresql/9.3/main' # use data in another directory # (change requires restart) hba_file = '/etc/postgresql/9.3/main/pg_hba.conf' # host-based authentication file # (change requires restart) ident_file = '/etc/postgresql/9.3/main/pg_ident.conf' # ident configuration file # (change requires restart) external_pid_file = '/var/run/postgresql/9.3-main.pid' # write an extra PID file # (change requires restart) listen_addresses = '*' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost'; use '*' for all # (change requires restart) port = 5432 # (change requires restart) max_connections = 500 # (change requires restart) unix_socket_directories = '/var/run/postgresql' # comma-separated list of directories # (change requires restart) # (change requires restart) # (change requires restart) # (change requires restart) ssl = on # (change requires restart) ssl_ciphers = 'DEFAULT:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers # (change requires restart) ssl_cert_file = 'server.crt' # (change requires restart) ssl_key_file = 'server.key' # (change requires restart) password_encryption = on # 0 selects the system default # 0 selects the system default # 0 selects the system default # (change requires restart) # (change requires restart) # in kB, or -1 for no limit max_files_per_process = 5000 # min 25 # (change requires restart) vacuum_cost_delay = 20 # 0-100 milliseconds vacuum_cost_page_hit = 1 # 0-10000 credits vacuum_cost_page_miss = 10 # 0-10000 credits vacuum_cost_page_dirty = 20 # 0-10000 credits vacuum_cost_limit = 200 # 1-10000 credits # (change requires restart) fsync = on # turns forced synchronization on or off synchronous_commit = on # synchronization level; # off, local, remote_write, or on wal_sync_method = fsync # the default is the first option # supported by the operating system: # open_datasync # fdatasync (default on Linux) # fsync # fsync_writethrough # open_sync full_page_writes = on # recover from partial page writes wal_buffers = -1 # min 32kB, -1 sets based on shared_buffers # (change requires restart) wal_writer_delay = 200ms # 1-10000 milliseconds commit_delay = 0 # range 0-100000, in microseconds commit_siblings = 5 # range 1-1000 checkpoint_segments = 64 # in logfile segments, min 1, 16MB each checkpoint_timeout = 15min # range 30s-1h checkpoint_completion_target = 0.9 # checkpoint target duration, 0.0 - 1.0 checkpoint_warning = 30s # 0 disables log_checkpoints = on log_line_prefix = '%t [%p-%l] %q%u@%d ' # special values: log_timezone = 'Europe/Bucharest' track_activities = on track_counts = on stats_temp_directory = '/var/run/postgresql/9.3-main.pg_stat_tmp' autovacuum = on # Enable autovacuum subprocess? 'on' # requires track_counts to also be on. log_autovacuum_min_duration = 0 # -1 disables, 0 logs all actions and autovacuum_max_workers = 5 # max number of autovacuum subprocesses # (change requires restart) autovacuum_naptime = 5min # time between autovacuum runs autovacuum_vacuum_threshold = 500 # min number of row updates before # vacuum autovacuum_analyze_threshold = 500 # min number of row updates before # analyze autovacuum_vacuum_scale_factor = 0.4 # fraction of table size before vacuum autovacuum_analyze_scale_factor = 0.2 # fraction of table size before analyze autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for datestyle = 'iso, mdy' timezone = 'Europe/Bucharest' client_encoding = sql_ascii # actually, defaults to database # encoding lc_messages = 'C' # locale for system error message # strings lc_monetary = 'C' # locale for monetary formatting lc_numeric = 'C' # locale for number formatting lc_time = 'C' # locale for time formatting default_text_search_config = 'pg_catalog.english' # (change requires restart) # (change requires restart) # directory 'conf.d' default_statistics_target = 100 # pgtune wizard 2016-12-11 maintenance_work_mem = 1GB # pgtune wizard 2016-12-11 constraint_exclusion = on # pgtune wizard 2016-12-11 effective_cache_size = 88GB # pgtune wizard 2016-12-11 work_mem = 64MB # pgtune wizard 2016-12-11 wal_buffers = 32MB # pgtune wizard 2016-12-11 shared_buffers = 30GB # pgtune wizard 2016-12-11 dose anyone know why this thing are happening? Thanks. Br, Vuko ------=_Part_899_1866530185.1485337495690 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <= div style=3D'font-family: arial,helvetica,sans-serif; font-size: 10pt; colo= r: #000000'>Hi,

before timeout started this was the last automatic v= acuum entry's:



2017-01-25 10:47:07 EET [5995-1] LOG:  a= utomatic vacuum of table "13Tim07Tuning.pg_catalog.pg_attribute": index sca= ns: 1
        pages: 0 removed, 261 r= emain
        tuples: 3547 removed, 8= 812 remain
        buffer usage: 927 = hits, 112 misses, 161 dirtied
       = avg read rate: 1.438 MB/s, avg write rate: 2.067 MB/s
   = ;     system usage: CPU 0.02s/0.00u sec elapsed 0.60 se= c
2017-01-25 10:47:07 EET [5995-2] LOG:  automatic analyze of table= "13Tim07Tuning.pg_catalog.pg_class" system usage: CPU 0.00s/0.00u sec elap= sed 0.08 sec
2017-01-25 10:47:07 EET [5995-3] LOG:  automatic vacuu= m of table "13Tim07Tuning.pg_catalog.pg_index": index scans: 1
 &nb= sp;      pages: 0 removed, 10 remain
 &nbs= p;      tuples: 14 removed, 312 remain
 &n= bsp;      buffer usage: 62 hits, 5 misses, 15 dirt= ied
        avg read rate: 0.767 MB/s= , avg write rate: 2.301 MB/s
        = system usage: CPU 0.00s/0.00u sec elapsed 0.05 sec
2017-01-25 10:47:10 E= ET [6060-1] LOG:  automatic analyze of table "12westm11.pg_catalog.pg_= type" system usage: CPU 0.00s/0.00u sec elapsed 0.08 sec
2017-01-25 10:4= 7:10 EET [6060-2] LOG:  automatic analyze of table "12westm11.pg_catal= og.pg_attribute" system usage: CPU 0.02s/0.01u sec elapsed 0.12 sec
2017= -01-25 10:48:30 EET [28355-4597] LOG:  checkpoint starting: time
20= 17-01-25 10:49:34 EET [6222-1]XXXX@YYYY FATAL:  canceling authenticati= on due to timeout



From: "Vucomir Ianculov" <vukomir@os-ux.com= >
To: pgsql-performance@postgresql.org
Sent: Wednesd= ay, January 25, 2017 11:23:39 AM
Subject: [PERFORM] pgsql connect= ion timeone

Hi,
i'm seeing a lot of connection time out in postgresql log

2017-= 01-25 11:09:47 EET [6897-1] XXX@YYY FATAL:  canceling authentication d= ue to timeout
2017-01-25 11:10:15 EET [6901-1] XXX@YYY FATAL:  canc= eling authentication due to timeout
2017-01-25 11:10:17 EET [6902-1] xxx= @YYY FATAL:  canceling authentication due to timeout
2017-01-25 11:= 10:33 EET [6906-1] xxxx@YYY FATAL:  canceling authentication due to ti= meout
2017-01-25 11:10:44 EET [6912-1] xxx@YYY FATAL:  canceling au= thentication due to timeout
2017-01-25 11:10:48 EET [6913-1] xxx@YYY FAT= AL:  canceling authentication due to timeout
2017-01-25 11:10:52 EE= T [6920-1] xxx@YYY:  canceling authentication due to timeout
2017-01-25 11:10:52 EET [6930-1] postgres@post= gres FATAL:  canceling authentication due to timeout
2017-01= -25 11:10:53 EET [6921-1] xxx@YYY FATAL:  canceling authentication due= to timeout
2017-01-25 11:11:08 EET [6933-1] xxx@YYY FATAL:  cancel= ing authentication due to timeout

i also tired to login as postgres = user from command line.

postgres@sppgsql01:~$ psql
psql: server closed the connection unexpectedly=
 &= nbsp;      This probably means the server terminat= ed abnormally
        before or while pro= cessing the request.

server load is ok, under 1,

memo= ry usage is also ok.

root@server ~ # free -m
   &n= bsp;          total  = ;      used      &nb= sp; free      shared  buff/cache   = available
Mem:         128908&nb= sp;       3398     &= nbsp;   795       31671  =     124714       92980
Swap= :          8191  &nb= sp;     1418        = 6773

system is a ubuntu 16.04 and i'm using postgresql 9.3

co= nnection limit is at 500 at the moment i have 180 connection, authenticatio= n_timeout is default 1 min.

here is the postgresql.conf

data_direc= tory =3D '/var/lib/postgresql/9.3/main'      =    # use data in another directory
     = ;            &n= bsp;            = ;          # (change requires = restart)
hba_file =3D '/etc/postgresql/9.3/main/pg_hba.conf'  &n= bsp;    # host-based authentication file
   =             &nb= sp;            =             # (chang= e requires restart)
ident_file =3D '/etc/postgresql/9.3/main/pg_ident.conf= '   # ident configuration file
     &nb= sp;            =             &nb= sp;         # (change requires rest= art)
external_pid_file =3D '/var/run/postgresql/9.3-main.pid'  &= nbsp;           &nbs= p;   # write an extra PID file
     &nb= sp;            =             &nb= sp;         # (change requires rest= art)
listen_addresses =3D '*'       &nb= sp;  # what IP address(es) to listen on;
    &nbs= p;            &= nbsp;           &nbs= p;          # comma-separated = list of addresses;
         &= nbsp;           &nbs= p;            &= nbsp;     # defaults to 'localhost'; use '*' for all
&= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;  # (change requires restart)
port =3D 5432    =             &nb= sp;            # (ch= ange requires restart)
max_connections =3D 500 # (change requires restart= )
unix_socket_directories =3D '/var/run/postgresql' # comma-separated list= of directories
         &nbs= p;            &= nbsp;           &nbs= p;     # (change requires restart)
   &= nbsp;           &nbs= p;            &= nbsp;           # (change= requires restart)
         &= nbsp;           &nbs= p;            &= nbsp;     # (change requires restart)
  &n= bsp;            = ;            &n= bsp;            # (c= hange requires restart)
ssl =3D on      &nbs= p;            &= nbsp;            # (= change requires restart)
ssl_ciphers =3D 'DEFAULT:!LOW:!EXP:!MD5:@STRENGTH= '        # allowed SSL ciphers &n= bsp;            = ;            &n= bsp;            = ; # (change requires restart)
ssl_cert_file =3D 'server.crt'  &n= bsp;            = ; # (change requires restart)
ssl_key_file =3D 'server.key'  &nb= sp;      # (change requires restart)
password_enc= ryption =3D on
          = ;            &n= bsp;            = ;     # 0 selects the system default
   = ;            &n= bsp;            = ;            # 0 sel= ects the system default
        &n= bsp;            = ;            &n= bsp;      # 0 selects the system default &n= bsp;            = ;            &n= bsp;            = ; # (change requires restart)
       &n= bsp;            = ;            &n= bsp;       # (change requires restart)=
 = ;            &n= bsp;            = ;            &n= bsp; # in kB, or -1 for no limit
max_files_per_process =3D 5000  = ;          # min 25
 &nb= sp;            =             &nb= sp;            = # (change requires restart)
vacuum_cost_delay =3D    = 20            =   # 0-100 milliseconds
vacuum_cost_page_hit =3D 1   &n= bsp;            # 0-= 10000 credits
vacuum_cost_page_miss =3D 10     &n= bsp;        # 0-10000 credits
vacuum_co= st_page_dirty =3D 20         &= nbsp;   # 0-10000 credits
vacuum_cost_limit =3D 200  &= nbsp;      # 1-10000 credits
   &n= bsp;            = ;            &n= bsp;           # (change = requires restart)
fsync =3D on       &n= bsp;            = ;          # turns forced sync= hronization on or off
synchronous_commit =3D on    &= nbsp;            # s= ynchronization level;
        &n= bsp;            = ;            &n= bsp;      # off, local, remote_write, or on=
wal_s= ync_method =3D fsync         &= nbsp;       # the default is the first option=
    &= nbsp;           &nbs= p;            &= nbsp;          #   o= pen_datasync
          &= nbsp;           &nbs= p;            &= nbsp;    #   fdatasync (default on Linux) &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p; #   fsync
        &n= bsp;            = ;            &n= bsp;      #   fsync_writethrough<= br style=3D"font-style: italic;"> =             &nb= sp;            =             &nb= sp; #   open_sync
full_page_writes =3D on    = ;            &n= bsp;  # recover from partial page writes
wal_buffers =3D -1 &nbs= p;            &= nbsp;         # min 32kB, -1 sets b= ased on shared_buffers
        &n= bsp;            = ;            &n= bsp;      # (change requires restart)
wal_writer_= delay =3D 200ms          =       # 1-10000 milliseconds
commit_delay =3D 0&n= bsp;            = ;           # range 0-100= 000, in microseconds
commit_siblings =3D 5     &n= bsp;            = ;   # range 1-1000
checkpoint_segments =3D 64   &= nbsp;            # i= n logfile segments, min 1, 16MB each
checkpoint_timeout =3D 15min &nb= sp;            # ran= ge 30s-1h
checkpoint_completion_target =3D 0.9    &nbs= p; # checkpoint target duration, 0.0 - 1.0
checkpoint_warning =3D 30s = ;            &n= bsp;  # 0 disables
        &n= bsp;            = ;        
log_checkpoints =3D on<= /span>
log_line_prefix =3D '%t [%p-%l] %q%u@%d '     &nb= sp;           # special v= alues:
           &= nbsp;           &nbs= p;            &= nbsp; 
log_timezone =3D 'Europe/Bucharest'
track_activities =3D on<= /span>
track_counts =3D on
stats_temp_directory =3D '/var/run/postgresql/9.3-mai= n.pg_stat_tmp'
autovacuum =3D on       =             &nb= sp;     # Enable autovacuum subprocess?  'on'
&nb= sp;            =             &nb= sp;            =   # requires track_counts to also be on.
log_autovacuum_min_duration = =3D 0         # -1 disables, 0 logs= all actions and
         &nb= sp;            =             &nb= sp;   
autovacuum_max_workers =3D 5   &nbs= p;          # max number of au= tovacuum subprocesses
        &n= bsp;            = ;            &n= bsp;      # (change requires restart)
autovacuum_= naptime =3D 5min          = ;     # time between autovacuum runs
autovacuum_vacuum= _threshold =3D 500       # min number of row = updates before
          = ;            &n= bsp;            = ;     # vacuum
= autovacuum_analyze_threshold =3D 500&nb= sp;     # min number of row updates before
  = ;            &n= bsp;            = ;             #= analyze
autovacuum_vacuum_scale_factor =3D 0.4    # fracti= on of table size before vacuum
autovacuum_analyze_scale_factor =3D 0.2&nbs= p;  # fraction of table size before analyze
    &= nbsp;           &nbs= p;            &= nbsp;         
autovacuum_va= cuum_cost_delay =3D 20ms     # default vacuum cost dela= y for
           &n= bsp;            = ;            &n= bsp;
datestyle =3D 'iso, mdy'
timezone =3D 'Europe/Bucharest'
 &nb= sp;            =             &nb= sp;        
client_encoding =3D s= ql_ascii           &= nbsp; # actually, defaults to database
      = ;            &n= bsp;            = ;         # encoding
lc_messages = =3D 'C'           &n= bsp;           # locale f= or system error message
        &n= bsp;            = ;            &n= bsp;      # strings
lc_monetary =3D 'C' &nbs= p;            &= nbsp;        # locale for monetary forma= tting
lc_numeric =3D 'C'        &n= bsp;            = ;   # locale for number formatting
lc_time =3D 'C'  &n= bsp;            = ;            # local= e for time formatting
default_text_search_config =3D 'pg_catalog.english= '
            =             &nb= sp;            =    # (change requires restart)
     &nb= sp;            =             &nb= sp;         # (change requires rest= art)
           &nb= sp;            =             &nb= sp;   # directory 'conf.d'
default_statistics_target =3D 100 # p= gtune wizard 2016-12-11
maintenance_work_mem =3D 1GB # pgtune wizard 2016-= 12-11
constraint_exclusion =3D on # pgtune wizard 2016-12-11
effective_ca= che_size =3D 88GB # pgtune wizard 2016-12-11
work_mem =3D 64MB # pgtune wi= zard 2016-12-11
wal_buffers =3D 32MB # pgtune wizard 2016-12-11
shared_bu= ffers =3D 30GB # pgtune wizard 2016-12-11


=
dose anyone know why this thing are happening?

Thanks.

= Br,
Vuko

------=_Part_899_1866530185.1485337495690--