Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e58ok-0006Dw-2A for pgsql-performance@arkaria.postgresql.org; Thu, 19 Oct 2017 11:16:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e58oj-000225-H4 for pgsql-performance@arkaria.postgresql.org; Thu, 19 Oct 2017 11:16:49 +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 1e4OBA-0003im-DG for pgsql-performance@postgresql.org; Tue, 17 Oct 2017 09:28:52 +0000 Received: from mail-oi0-x232.google.com ([2607:f8b0:4003:c06::232]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1e4OB6-0007yd-OW for pgsql-performance@postgresql.org; Tue, 17 Oct 2017 09:28:51 +0000 Received: by mail-oi0-x232.google.com with SMTP id h200so1680363oib.4 for ; Tue, 17 Oct 2017 02:28:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=6CdTHXumQfeWfWDIyWOsVELWOz8jPrxxqBU7T6CykYE=; b=l6kxqSWILOYBBy5TyWXfrKMOGLNXgppMbH8zaTJiTn/VBrfybi4UE2eCOG7wwOGfXG o5mu9ZrNtuDPSHasvuJpttY1EhsPnKullL/OyxzwzmLCh2GsRFTCobr0W6sDk33Wed94 eRo9g+CiDmNxE/VcVitfcISth/VyIaKJFpc5RNq4XjFpsAhySPGRDV466tXFshOuRCO4 D3sQhS0OaMYLF08D61NvWfTPqCntWLM+ihG8erSh0DQ7V5+hmY3cEI+rpx9yn6D+6w1H A1zW9bcyjLL/iB/HU0GuEvqY3a7RObLAXZnuFz6rBYBL19bY7PC63y01BGR4191Q7n/n nW6Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=6CdTHXumQfeWfWDIyWOsVELWOz8jPrxxqBU7T6CykYE=; b=R8Gc1orEx9pUsOwopxiW9UgM9XZRcXHTRuHwe00azzeOT9QC23VXMQfN6angwCqWow 8eNB/PSvDtLrsA7Q8xUIP/8lMd8CBjm8eIVuOLraxLUgdM2ONg8fudjBe1GrtI9TuEEh jSaGS3FH/7itRXbvq0bU/6uzy8nP96yJCaThykjnY/nZfTzJ0pxoOABSosKYV7+YLk/C tvGtb3m5CH9lzsLLCKauaTsGynWsUtzs8jFDrWdzZBLHIBQkQ1iL274HGQ68KBlFZpff OsPm6fJa2gBmtsy5jB9aROIF6O3VSzWYYPYcMoAHVf9cMtCpvBnphWQlnLdwTtcijpSH 1rBQ== X-Gm-Message-State: AMCzsaVvXfpecMxFlQykZkValma+dCn4LMqQ36ItLA4nRVZ67kMPgjxY BqL/J80YFJZHXaThMTk6zLFRFy/sl1EcX2vtsszFNtaV X-Google-Smtp-Source: ABhQp+RIJnYc9ukGg3s8jUFv/LIn+LqsjDsIxZmWSJgdrs0fvH+hEx3E+zdJs6G585tFIVVCavhoUNHGmlUa8aCwJQw= X-Received: by 10.202.79.7 with SMTP id d7mr7089585oib.273.1508232526047; Tue, 17 Oct 2017 02:28:46 -0700 (PDT) MIME-Version: 1.0 Received: by 10.157.0.173 with HTTP; Tue, 17 Oct 2017 02:28:45 -0700 (PDT) From: nijam J Date: Tue, 17 Oct 2017 14:58:45 +0530 Message-ID: Subject: memory allocation To: pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary="001a113d720ef43033055bbabfd2" 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 --001a113d720ef43033055bbabfd2 Content-Type: text/plain; charset="UTF-8" we are using cloud server *this are memory info* free -h total used free shared buffers cached Mem: 15G 15G 197M 194M 121M 14G -/+ buffers/cache: 926M 14G Swap: 15G 32M 15G *this are disk info:* df -h Filesystem Size Used Avail Use% Mounted on /dev/vda1 20G 1.7G 17G 10% / devtmpfs 7.9G 0 7.9G 0% /dev tmpfs 7.9G 4.0K 7.9G 1% /dev/shm tmpfs 7.9G 17M 7.9G 1% /run tmpfs 7.9G 0 7.9G 0% /sys/fs/cgroup /dev/mapper/vgzero-lvhome 99G 189M 94G 1% /home /dev/mapper/vgzero-lvdata 1.2T 75G 1.1T 7% /data /dev/mapper/vgzero-lvbackup 296G 6.2G 274G 3% /backup /dev/mapper/vgzero-lvxlog 197G 61M 187G 1% /pg_xlog /dev/mapper/vgzero-lvarchive 197G 67G 121G 36% /archive i allocated memory as per following list: shared_buffers = 2GB (10-30 %) effective_cache_size =7GB (70-75 %) ---->>(shared_buffers+page cache) for dedicated server only work_mem = 128MB (0.3-1 %) maintenance_work_mem = 512MB (0.5-4 % ) temp_Buffer = 8MB ---->>default is better( setting can be changed within individual sessions) checkpoint_segments = 64 checkpoint_completion_target = 0.9 random_page_cost = 3.5 cpu_tuple_cost = 0.05 wal_buffers = 32MB leave this default 3% of shared buffer is better is it better or do i want to modify any thing our server is getting too slow again and again please give me a suggestion --001a113d720ef43033055bbabfd2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
we are using cloud server=C2=A0

this= are memory info

free -h
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0total=C2=A0 =C2=A0 =C2=A0 = =C2=A0used=C2=A0 =C2=A0 =C2=A0 =C2=A0free=C2=A0 =C2=A0 =C2=A0shared=C2=A0 = =C2=A0 buffers=C2=A0 =C2=A0 =C2=A0cached
Mem:=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A015G=C2=A0 =C2=A0 =C2=A0 =C2=A0 15G=C2=A0 =C2=A0 =C2=A0= =C2=A0197M=C2=A0 =C2=A0 =C2=A0 =C2=A0194M=C2=A0 =C2=A0 =C2=A0 =C2=A0121M= =C2=A0 =C2=A0 =C2=A0 =C2=A0 14G
-/+ buffers/cache:=C2=A0 =C2=A0 = =C2=A0 =C2=A0926M=C2=A0 =C2=A0 =C2=A0 =C2=A0 14G
Swap:=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 15G=C2=A0 =C2=A0 =C2=A0 =C2=A0 32M=C2=A0 =C2=A0 = =C2=A0 =C2=A0 15G

this are disk inf= o:
=C2=A0df -h

Filesystem=C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Size=C2=A0 Used Avail Use% Mount= ed on
/dev/vda1=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 20G=C2=A0 1.7G=C2=A0 =C2=A017G=C2=A0 10% /
devtmpfs=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 7.9G=C2=A0 =C2=A0 =C2=A00=C2=A0 7.9G=C2=A0 =C2=A00% /dev<= /div>
tmpfs=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A07.9G=C2=A0 4.0K=C2=A0 7.9G=C2=A0 =C2=A01% /d= ev/shm
tmpfs=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A07.9G=C2=A0 =C2=A017M=C2=A0 7.9G=C2=A0= =C2=A01% /run
tmpfs=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A07.9G=C2=A0 =C2=A0 =C2=A00=C2= =A0 7.9G=C2=A0 =C2=A00% /sys/fs/cgroup
/dev/mapper/vgzero-lvhome= =C2=A0 =C2=A0 =C2=A0 99G=C2=A0 189M=C2=A0 =C2=A094G=C2=A0 =C2=A01% /home
/dev/mapper/vgzero-lvdata=C2=A0 =C2=A0 =C2=A01.2T=C2=A0 =C2=A075G= =C2=A0 1.1T=C2=A0 =C2=A07% /data
/dev/mapper/vgzero-lvbackup=C2= =A0 =C2=A0296G=C2=A0 6.2G=C2=A0 274G=C2=A0 =C2=A03% /backup
/dev/= mapper/vgzero-lvxlog=C2=A0 =C2=A0 =C2=A0197G=C2=A0 =C2=A061M=C2=A0 187G=C2= =A0 =C2=A01% /pg_xlog
/dev/mapper/vgzero-lvarchive=C2=A0 197G=C2= =A0 =C2=A067G=C2=A0 121G=C2=A0 36% /archive



i allocated= memory as per following list:
shared_buffers =3D 2GB=C2=A0 = (10-30 %)
effective_cache_size =3D7GB (70-75 %)=C2=A0 =C2=A0----&= gt;>(shared_buffers+page cache) for dedicated server only
work= _mem =3D 128MB=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0(0.3-1 %)
mainten= ance_work_mem =3D 512MB (0.5-4 % )
temp_Buffer =3D=C2=A0 8MB=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0--= -->>default is better( setting can be changed within individual sessi= ons)

checkpoint_segments =3D 64
checkpoi= nt_completion_target =3D 0.9
random_page_cost =3D 3.5
c= pu_tuple_cost =3D 0.05
wal_buffers =3D 32MB=C2=A0 leave this defa= ult 3% of shared buffer is better



is it better or do i want to modify any thing
=

our server is getting too slow again and again

please give me a suggestion
--001a113d720ef43033055bbabfd2--