Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YXNv0-0006RA-Uq for pgsql-admin@arkaria.postgresql.org; Mon, 16 Mar 2015 05:50:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YXNuz-0006Mn-Gf for pgsql-admin@arkaria.postgresql.org; Mon, 16 Mar 2015 05:50:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YXNuy-0006Mg-0u for pgsql-admin@postgresql.org; Mon, 16 Mar 2015 05:50:24 +0000 Received: from eu1sys200aog116.obsmtp.com ([207.126.144.141]) by magus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YXNur-0007U8-MT for pgsql-admin@postgresql.org; Mon, 16 Mar 2015 05:50:22 +0000 Received: from mail-qg0-f52.google.com ([209.85.192.52]) (using TLSv1) by eu1sys200aob116.postini.com ([207.126.147.11]) with SMTP ID DSNKVQZvFahSSlBTNEQHi/d2Scxg/kkDbWth@postini.com; Mon, 16 Mar 2015 05:50:17 UTC Received: by qgfa8 with SMTP id a8so31937659qgf.0 for ; Sun, 15 Mar 2015 22:50:12 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:references:in-reply-to:mime-version :thread-index:date:message-id:subject:to:cc:content-type; bh=R3UiGs+cUYONo+h+q8NwPgRi7m6vXTLzPZUFWKWTmsw=; b=jeOr6tJufo2kRhgY1RNXimvcf74Oi8xIOufwEBk9c85x56nukfoc424XWjEeI9ItsR 5ixzT71aYwGKSEfcfnOjcyfPLauBWr+ajjxbY++7AD0T/iTt+GhvQ3YDnVTUqOVkW00p FBNBW/P8v41mokyIpfKVIpqogS4dr644qzfpPKHgJhTHEqGJudWvSQCpclCy2oEoEhqN 1oyz5QgZVSplWjbZ/mQk8rdzjR2oKtVVPlqJllxpt0aZ1utXl95cIzEMV9gcrIykbKQS WrUCOHd3thejWVbd9BqQfK26cQPjAjouFc3Zurym3zld5bwz4pYHK9xaw0DVTQ1UNKwz 79rw== X-Gm-Message-State: ALoCoQmR3ATl1aNxfZckE6xS8MgLJuy74tuQCJ98HlNDD97+QdZNnIbgjYAhkTk9MShrpIMnLQRH2IPmXF3Ikr1qOyppBGAOYi76l4G9ZwPQz/hWrt3Edt2MqwK3XnYyQ0nIa7fjYquQrrF+SeGeNxQM3DWGbEd8Iw== X-Received: by 10.55.23.195 with SMTP id 64mr68029908qkx.76.1426485012450; Sun, 15 Mar 2015 22:50:12 -0700 (PDT) X-Received: by 10.55.23.195 with SMTP id 64mr68029897qkx.76.1426485012291; Sun, 15 Mar 2015 22:50:12 -0700 (PDT) From: Khangelani Gama References: In-Reply-To: MIME-Version: 1.0 X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQJiCgJ0YocqW3rdp6f1KRT6RzPHXQI6lJ1gm+lvh/A= Date: Mon, 16 Mar 2015 07:50:10 +0200 Message-ID: <808fb4e2e74edd385181280ad1ed7c61@mail.gmail.com> Subject: Re: I am working on trying to improve a database perfomance in version 9.2 Postgresql database server To: Venkata Balaji N Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=001a1147f1a26f7a3c0511616cbc X-Pg-Spam-Score: -4.2 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --001a1147f1a26f7a3c0511616cbc Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable *CPU Information:* processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 44 model name : Intel(R) Xeon(R) CPU X5670 @ 2.93GHz stepping : 2 cpu MHz : 2933.437 cache size : 12288 KB physical id : 0 siblings : 4 core id : 0 cpu cores : 4 apicid : 0 initial apicid : 0 fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 popcnt aes hypervisor lahf_lm ida arat epb dts bogomips : 5866.87 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 1 vendor_id : GenuineIntel cpu family : 6 model : 44 model name : Intel(R) Xeon(R) CPU X5670 @ 2.93GHz stepping : 2 cpu MHz : 2933.437 cache size : 12288 KB physical id : 0 siblings : 4 core id : 1 cpu cores : 4 apicid : 1 initial apicid : 1 fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 popcnt aes hypervisor lahf_lm ida arat epb dts bogomips : 5866.87 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 2 vendor_id : GenuineIntel cpu family : 6 model : 44 model name : Intel(R) Xeon(R) CPU X5670 @ 2.93GHz stepping : 2 cpu MHz : 2933.437 cache size : 12288 KB physical id : 0 siblings : 4 core id : 2 cpu cores : 4 apicid : 2 initial apicid : 2 fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 popcnt aes hypervisor lahf_lm ida arat epb dts bogomips : 5866.87 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 3 vendor_id : GenuineIntel cpu family : 6 model : 44 model name : Intel(R) Xeon(R) CPU X5670 @ 2.93GHz stepping : 2 cpu MHz : 2933.437 cache size : 12288 KB physical id : 0 siblings : 4 core id : 3 cpu cores : 4 apicid : 3 initial apicid : 3 fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 popcnt aes hypervisor lahf_lm ida arat epb dts bogomips : 5866.87 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 4 vendor_id : GenuineIntel cpu family : 6 model : 44 model name : Intel(R) Xeon(R) CPU X5670 @ 2.93GHz stepping : 2 cpu MHz : 2933.437 cache size : 12288 KB physical id : 1 siblings : 4 core id : 0 cpu cores : 4 apicid : 4 initial apicid : 4 fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 popcnt aes hypervisor lahf_lm ida arat epb dts bogomips : 5866.87 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 5 vendor_id : GenuineIntel cpu family : 6 model : 44 model name : Intel(R) Xeon(R) CPU X5670 @ 2.93GHz stepping : 2 cpu MHz : 2933.437 cache size : 12288 KB physical id : 1 siblings : 4 core id : 1 cpu cores : 4 apicid : 5 initial apicid : 5 fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 popcnt aes hypervisor lahf_lm ida arat epb dts bogomips : 5866.87 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 6 vendor_id : GenuineIntel cpu family : 6 model : 44 model name : Intel(R) Xeon(R) CPU X5670 @ 2.93GHz stepping : 2 cpu MHz : 2933.437 cache size : 12288 KB physical id : 1 siblings : 4 core id : 2 cpu cores : 4 apicid : 6 initial apicid : 6 fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 popcnt aes hypervisor lahf_lm ida arat epb dts bogomips : 5866.87 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 44 model name : Intel(R) Xeon(R) CPU X5670 @ 2.93GHz stepping : 2 cpu MHz : 2933.437 cache size : 12288 KB physical id : 1 siblings : 4 core id : 3 cpu cores : 4 apicid : 7 initial apicid : 7 fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 popcnt aes hypervisor lahf_lm ida arat epb dts bogomips : 5866.87 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: *Partition information:* ~> fdisk -l Disk /dev/sda: 53.7 GB, 53687091200 bytes 255 heads, 63 sectors/track, 6527 cylinders Units =3D cylinders of 16065 * 512 =3D 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x0004f143 Device Boot Start End Blocks Id System /dev/sda1 * 1 64 512000 83 Linux Partition 1 does not end on cylinder boundary. /dev/sda2 64 6528 51915776 8e Linux LVM Disk /dev/sdb: 536.9 GB, 536870912000 bytes 255 heads, 63 sectors/track, 65270 cylinders Units =3D cylinders of 16065 * 512 =3D 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x7ab4f5df Device Boot Start End Blocks Id System /dev/sdb1 1 65270 524281243+ 83 Linux Disk /dev/sdc: 53.7 GB, 53687091200 bytes 255 heads, 63 sectors/track, 6527 cylinders Units =3D cylinders of 16065 * 512 =3D 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x430139e1 Device Boot Start End Blocks Id System /dev/sdc1 1 6527 52428096 83 Linux Disk /dev/sdd: 859.0 GB, 858993459200 bytes 255 heads, 63 sectors/track, 104433 cylinders Units =3D cylinders of 16065 * 512 =3D 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x55dc0a43 Device Boot Start End Blocks Id System /dev/sdd1 1 104433 838858041 83 Linux Disk /dev/mapper/vg_centtemp-lv_root: 49.0 GB, 48997859328 bytes 255 heads, 63 sectors/track, 5956 cylinders Units =3D cylinders of 16065 * 512 =3D 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00000000 Disk /dev/mapper/vg_centtemp-lv_swap: 4160 MB, 4160749568 bytes 255 heads, 63 sectors/track, 505 cylinders Units =3D cylinders of 16065 * 512 =3D 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00000000 File System Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_centtemp-lv_root 45G 13G 31G 29% / tmpfs 12G 76K 12G 1% /dev/shm /dev/sda1 485M 38M 423M 9% /boot /dev/sdb1 493G 107G 361G 23% /home /dev/sdc1 50G 36G 12G 76% /usr/local/jboss /dev/sdd1 788G 529G 219G 71% /pgsql0 //172.23.30.34/Backup 500G 188G 313G 38% /FMBackup root@c9901.fm.co.za| ~> *From:* Venkata Balaji N [mailto:nag1010@gmail.com] *Sent:* 14 March 2015 12:32 AM *To:* Khangelani Gama *Cc:* pgsql-admin@postgresql.org *Subject:* Re: [ADMIN] I am working on trying to improve a database perfomance in version 9.2 Postgresql database server I need some help in trying improve database performance on the server that has 103 databases running in one server. Autovacuum is switched off intentionally , it was causing issues until I implemented a script where I run vacuum analyze every Sunday of the week, I don=E2=80=99t know if it=E2= =80=99s enough or not but each database receive about 4000 new transactions a day. I run VACUUM ANALYZE in each active database that=E2=80=99s on this server. Curre= nts are like when I try to create a new database on the same server using a created command, it takes long to finish, hence takes to restore a database on the server. Sometimes the load average hits about 20 to 30 when there is many things running on the server. It takes about 6 hours for this vacuum to finish running in all these databases every Sunday. Is it necessary to run any REINDEXes. Any advices will help, see some information below: PostgreSQL version ? Do you have all the 103 database in one cluster ? I suspect a DISK IO and CPU spike. Do you see that ? Its hard to say straight if there is a need for REINDEXING. Can you let us know the hardware specifications of the server. We will need to understand if the server capacity is falling short for the load being received. How many active connections you see at the database level ? I am thinking of increasing values on the following parameters in the conf file after some reading ing http://www.postgresql.org/docs/9.2/static/runtime-config-resource.html *Parameters:* work_mem shared_buffers maintenance_work_mem checkpoint_segments We need to know the hardware specifications. Some server config information currently are: 1. data/ directory size is 526G 2. Total memory is 24G Do you see any over utilization of the memory. Regards, Venkata Balaji N CONFIDENTIALITY NOTICE The contents of and attachments to this e-mail are intended for the addre= ssee only, and may contain the confidential information of Argility (Proprietary) Limited and/or its subsidiaries. An= y review, use or dissemination thereof by anyone other than the intended addressee is prohibited.If you are not the intend= ed addressee please notify the writer immediately and destroy the e-mail. Argility (Proprietary) Limited and its subsidiari= es distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other tha= n strictly for business purposes. =0D --001a1147f1a26f7a3c0511616cbc Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

CPU Information:

=C2=A0

= =C2=A0

=C2=A0

=C2=A0

=C2=A0

processor=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 : 0

vendor_id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : GenuineIntel

cpu family=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 : 6

model=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 := 44

model name= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : Intel(R) Xeon(R) CPU=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 X5670=C2=A0 @ 2.93GHz

stepping=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 : 2

cpu MHz=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 2= 933.437

cache s= ize=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 12288 KB

physical id=C2=A0=C2=A0=C2=A0=C2=A0 : 0

siblings=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 4

core id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= : 0

cpu cores= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 4

<= span style=3D"font-size:11.0pt;font-family:"Calibri","sans-s= erif";color:#1f497d">apicid=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 : 0

fpu=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 : yes

fpu_exception=C2=A0=C2=A0 : yes

cpuid level=C2=A0=C2=A0=C2=A0=C2=A0 : 11

wp=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=A0 : yes

flags=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : fpu vme de pse tsc msr pae mce cx8 a= pic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht sys= call nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable= nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse= 4_2 popcnt aes hypervisor lahf_lm ida arat epb dts

bogomips=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 : 5866.87

clflush size=C2=A0=C2=A0=C2=A0 : 64

cache_alignment : 64

address sizes=C2=A0=C2=A0 : 40 bits phys= ical, 48 bits virtual

power management:

=C2=A0

vendor_id=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 : GenuineIntel

cpu family=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 6

model=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 44

model name=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : Intel(R)= Xeon(R) CPU=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 X5= 670=C2=A0 @ 2.93GHz

stepping=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 2

cpu MHz=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 : 2933.437

cache size=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 12288 KB=

physical id=C2= =A0=C2=A0=C2=A0=C2=A0 : 0

siblings=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 4

core id=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 1

cpu cores=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 4

apicid=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 1

initial apicid=C2=A0 : 1

fpu=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : yes

fpu_exception=C2=A0=C2=A0 : yes=

cpuid level=C2=A0=C2= =A0=C2=A0=C2=A0 : 11

wp=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=A0 : yes

flags=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : fpu= vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflus= h dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmo= n pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pn= i pclmulqdq ssse3 cx16 sse4_1 sse4_2 popcnt aes hypervisor lahf_lm ida arat= epb dts

bogomi= ps=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 5866.87

clflush size=C2=A0=C2=A0=C2=A0 : = 64

cache_alignm= ent : 64

addres= s sizes=C2=A0=C2=A0 : 40 bits physical, 48 bits virtual

power management:

=C2=A0

processor=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 : 2

v= endor_id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : GenuineIntel

cpu family=C2=A0=C2=A0=C2=A0 = =C2=A0=C2=A0: 6

model=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 44

model name=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 : Intel(R) Xeon(R) CPU=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 X5670=C2=A0 @ 2.93GHz

stepping=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 : 2

cpu MHz=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 2933.437<= /span>

cache size=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 : 12288 KB

physical id=C2=A0=C2=A0=C2=A0=C2=A0 : 0

<= p class=3D"MsoNormal">siblings=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 : 4

core id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 2=

cpu cores=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 4

apicid=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 : 2

i= nitial apicid=C2=A0 : 2

fpu=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 : yes

fpu_exception=C2=A0=C2=A0 : yes

cpuid level=C2=A0=C2=A0=C2=A0=C2=A0 : 11

wp=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=A0 : yes

flags=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : fpu vme de pse tsc msr pae mce cx8 apic= sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscal= l nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable no= nstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse4_2= popcnt aes hypervisor lahf_lm ida arat epb dts

bogomips=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 : 5866.87

clflush size=C2=A0=C2=A0=C2=A0 : 64

<= span style=3D"font-size:11.0pt;font-family:"Calibri","sans-s= erif";color:#1f497d">cache_alignment : 64

address sizes=C2=A0=C2=A0 : 40 bits physica= l, 48 bits virtual

power management:

=C2=A0

p= rocessor=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 3

vendor_id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 : GenuineIntel

cpu family=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 6

model=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 : 44

model name=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : Intel(R) Xeon(= R) CPU=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 X5670=C2= =A0 @ 2.93GHz

s= tepping=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0: 2

cpu MHz=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 : 2933.437

cache size=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 12288 KB

physical id=C2=A0=C2= =A0=C2=A0=C2=A0 : 0

siblings=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 4

core id=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 : 3

cpu cores=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 4

apicid=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 3

initial apicid=C2=A0 : 3

fpu=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : yes

fpu_exception=C2=A0=C2=A0 : yes

cpuid level=C2=A0=C2=A0=C2= =A0=C2=A0 : 11

= wp=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=A0 : yes

fl= ags=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : fpu vme d= e pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts = mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs= bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclm= ulqdq ssse3 cx16 sse4_1 sse4_2 popcnt aes hypervisor lahf_lm ida arat epb d= ts

bogomips=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 5866.87

clflush size=C2=A0=C2=A0=C2=A0 : 64

cache_alignment : 6= 4

address sizes= =C2=A0=C2=A0 : 40 bits physical, 48 bits virtual

power management:

=C2=A0

processor=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 = : 4

vendor_id= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : GenuineIntel

cpu family=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 : 6

model= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 44

model name=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 : Intel(R) Xeon(R) CPU=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 X5670=C2=A0 @ 2.93GHz

stepping=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 : 2

cache size=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 : 12288 KB

physical id=C2=A0=C2=A0=C2=A0=C2=A0 : 1

siblings=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 : 4

core id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 0<= /p>

cpu cores=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 : 4

apicid=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 : 4

initial= apicid=C2=A0 : 4

fpu=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 : yes

fpu_e= xception=C2=A0=C2=A0 : yes

cpuid level=C2=A0=C2=A0=C2=A0=C2=A0 : 11

wp=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=A0 : yes

flags=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 : fpu vme de pse tsc msr pae mce cx8 apic sep m= trr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx r= dtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_= tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 popcn= t aes hypervisor lahf_lm ida arat epb dts

= bogomips=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 : 5866.87

c= lflush size=C2=A0=C2=A0=C2=A0 : 64

cache_alignment : 64

<= span style=3D"font-size:11.0pt;font-family:"Calibri","sans-s= erif";color:#1f497d">address sizes=C2=A0=C2=A0 : 40 bits physical, 48 = bits virtual

po= wer management:

=C2=A0

process= or=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 5

vendor_id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 := GenuineIntel

c= pu family=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 6

model=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 : 44

model name=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : Intel(R) Xeon(R) CPU= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 X5670=C2=A0 @ = 2.93GHz

steppin= g=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 2

cpu MHz=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 : 2933.437

cache size=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 12288 KB

<= p class=3D"MsoNormal">physical id=C2=A0=C2=A0=C2= =A0=C2=A0 : 1

s= iblings=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 4

core id=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 : 1

cpu cores=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 4

apicid=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 5

initial apicid=C2=A0 : 5

fpu=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : yes

fpu_exception=C2=A0=C2=A0 : yes

cpuid level=C2=A0=C2=A0=C2=A0=C2= =A0 : 11

wp=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=A0= : yes

flags=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : fpu vme de pse = tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fx= sr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts x= topology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq = ssse3 cx16 sse4_1 sse4_2 popcnt aes hypervisor lahf_lm ida arat epb dts

bogomips=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 5866.87

clflush size=C2=A0=C2=A0=C2=A0 : 64

=

cache_alignment : 64

address sizes=C2=A0= =C2=A0 : 40 bits physical, 48 bits virtual

power management:

=C2=A0

processor=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 6

vendor_id=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : GenuineIntel

cpu family=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 6=

model=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 44

model name=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 : Intel(R) Xeon(R) CPU=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 X5670=C2=A0 @ 2.93GHz

<= span style=3D"font-size:11.0pt;font-family:"Calibri","sans-s= erif";color:#1f497d">stepping=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 : 2

cpu MHz= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 2933.437

cache size=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 : 12288 KB

physical id=C2=A0=C2=A0=C2=A0=C2=A0 : 1

siblings=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 : 4

c= ore id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 2

cpu cores=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 : 4

apicid=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 6

initial apicid=C2=A0= : 6

fpu=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : yes

fpu_exception=C2= =A0=C2=A0 : yes

cpuid level=C2=A0=C2=A0=C2=A0=C2=A0 : 11

= wp=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=A0 : yes

flags=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca = cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm con= stant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmpe= rf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 popcnt aes hyperv= isor lahf_lm ida arat epb dts

bogomips=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 5866.8= 7

clflush size= =C2=A0=C2=A0=C2=A0 : 64

cache_alignment : 64

address sizes=C2=A0=C2=A0 : 40 bits physical, 48 bits virtu= al

power manage= ment:

=C2=A0

processor=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 7

vendor_id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : Genuine= Intel

cpu famil= y=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 6

model=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 : 44

model name=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : Intel(R) Xeon(R) CPU=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 X5670=C2=A0 @ 2.93GHz

stepping=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 2

<= span style=3D"font-size:11.0pt;font-family:"Calibri","sans-s= erif";color:#1f497d">cpu MHz=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 : 2933.437

cache size=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 12288 KB

physical id=C2=A0=C2=A0=C2=A0=C2= =A0 : 1

sibling= s=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 4

core id=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 : 3

cpu cores=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 4

apicid=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 : 7

initial apicid=C2=A0 : 7

= fpu=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 : yes

fpu_exception=C2=A0=C2=A0 : yes

cpuid level=C2=A0=C2=A0=C2=A0=C2=A0 : 1= 1

wp=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=A0 : yes=

flags=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : fpu vme de pse tsc ms= r pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse= sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopolo= gy tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 = cx16 sse4_1 sse4_2 popcnt aes hypervisor lahf_lm ida arat epb dts

bogomips=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 : 5866.87

clflush size=C2=A0=C2=A0=C2=A0 : 64

cache_alignment : 64

=

address sizes=C2=A0=C2=A0= : 40 bits physical, 48 bits virtual

power management:

=C2=A0

=C2=A0

=C2=A0

=C2=A0

=C2=A0<= /span>

Partition in= formation:

= =C2=A0

~> fd= isk -l

=C2=A0

Disk /dev/sda: 5= 3.7 GB, 53687091200 bytes

255 heads, 63 sectors/track, 6527 cylinders

Units =3D cylinders of 16065 * 51= 2 =3D 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512= bytes / 512 bytes

Disk identifier: 0x0004f143

=C2=A0

=C2=A0=C2=A0 Device Boot=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Start=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 End=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 Blocks=C2=A0=C2=A0 Id=C2=A0 System

/dev/sda1=C2=A0 =C2=A0*=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 64=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 512000=C2=A0=C2=A0 83=C2= =A0 Linux

Parti= tion 1 does not end on cylinder boundary.

= /dev/sda2=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=A0 64=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 6528=C2=A0=C2=A0=C2=A0 51915776=C2=A0=C2=A0 8e=C2=A0 Linux LVM

=C2=A0

=

Disk /dev/sdb: 536.9 GB, = 536870912000 bytes

255 heads, 63 sectors/track, 65270 cylinders

Units =3D cylinders of 16065 * 512 =3D 82= 25280 bytes

Sec= tor size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes /= 512 bytes

Disk= identifier: 0x7ab4f5df

=C2=A0

=C2=A0=C2=A0 Device Boot=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Start=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 End=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Bloc= ks=C2=A0=C2=A0 Id=C2=A0 System

/dev/sdb1=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=A0=C2=A01=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 6= 5270=C2=A0=C2=A0 524281243+=C2=A0 83=C2=A0 Linux

=C2=A0

<= span style=3D"font-size:11.0pt;font-family:"Calibri","sans-s= erif";color:#1f497d">Disk /dev/sdc: 53.7 GB, 53687091200 bytes<= /p>

255 heads, 63 sectors/= track, 6527 cylinders

Units =3D cylinders of 16065 * 512 =3D 8225280 bytes

Sector size (logical/physical)= : 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x430139e1

=C2=A0

<= p class=3D"MsoNormal">=C2=A0=C2=A0 Device Boot= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Start=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 End=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Blocks=C2=A0=C2=A0 Id=C2=A0 Sys= tem

/dev/sdc1= =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= =A0=C2=A0 1=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 6527=C2=A0=C2=A0=C2= =A0 52428096=C2=A0=C2=A0 83=C2=A0 Linux

=C2=A0

Disk /dev/sdd: 859.0 GB, 858993459200 bytes

255 heads, 63 sectors/track, = 104433 cylinders

Sector size (logical/physical): 5= 12 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x55dc0a43

=C2=A0

=C2=A0=C2=A0 Device Boot=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 Start=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0End=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Blocks=C2=A0=C2=A0 Id=C2=A0 Syst= em

/dev/sdd1=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=A0= =C2=A0 1=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 104433=C2=A0=C2=A0 838858041=C2=A0= =C2=A0 83=C2=A0 Linux

=C2=A0

D= isk /dev/mapper/vg_centtemp-lv_root: 49.0 GB, 48997859328 bytes

<= p class=3D"MsoNormal">255 heads, 63 sectors/trac= k, 5956 cylinders

Units =3D cylinders of 16065 * 512 =3D 8225280 bytes

Sector size (logical/physical): 5= 12 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

=C2=A0

=C2=A0

Disk /dev/mapper/vg_centtemp-lv_swap= : 4160 MB, 4160749568 bytes

255 heads, 63 sectors/track, 505 cylinders

Units =3D cylinders of 16065 * 51= 2 =3D 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512= bytes / 512 bytes

Disk identifier: 0x00000000

=C2=A0

=C2=A0

=C2=A0

File Sy= stem

=C2=A0

Filesystem=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Size=C2=A0 Use= d Avail Use% Mounted on

/dev/mapper/vg_centtemp-lv_root

<= span style=3D"font-size:11.0pt;font-family:"Calibri","sans-s= erif";color:#1f497d">=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=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A045G=C2=A0=C2=A0 13G=C2=A0=C2=A0 31G=C2=A0 29% /

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=A0=C2=A0=C2=A0=C2=A0=C2=A0= 12G=C2=A0=C2=A0 76K=C2=A0=C2=A0 12G=C2=A0=C2=A0 1% /dev/shm

/dev/sda1=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 485M=C2=A0=C2=A0 38M= =C2=A0 423M=C2=A0=C2=A0 9% /boot

/dev/sdb1=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 493G=C2=A0 107G=C2=A0 361G=C2=A0 23% /home<= /p>

/dev/sdc1=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=A0 50G=C2= =A0=C2=A0 36G=C2=A0=C2=A0 12G=C2=A0 76% /usr/local/jboss

/dev/sdd1=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 788G=C2=A0 529G=C2=A0 219G= =C2=A0 71% /pgsql0

//172.23.30.34/Backup=

=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=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 500G=C2=A0 188G=C2=A0 313G=C2=A0 38% /FMBack= up

root@c9901.fm.co.za| ~>

=C2=A0

From: Venkata Balaji N [mailto:nag101= 0@gmail.com]
Sent: 14 March 2015 12:32 AM
To: Khan= gelani Gama
Cc: pgs= ql-admin@postgresql.org
Subject: Re: [ADMIN] I am working on = trying to improve a database perfomance in version 9.2 Postgresql database = server

=C2=A0

=C2=A0I need some help in trying improve database performance on the serve= r that has 103 databases running in one server. Autovacuum is switched off = intentionally , it was causing issues until I implemented a script where I = run vacuum analyze every Sunday of the week, I don=E2=80=99t know if it=E2= =80=99s enough or not but each database receive about 4000 new transactions= a day.=C2=A0 I run VACUUM ANALYZE in each active database that=E2=80=99s o= n this server. Currents are like when I try to create a new database on the= same server using a created command, it takes long to finish, hence takes = to restore a database on the server. Sometimes the load average hits about = 20 to 30 when there is many things running on the server. It takes about 6 = hours for this vacuum to finish running in all these databases every Sunday= . Is it necessary to run any REINDEXes.

=C2= =A0

Any advices will help, see some informa= tion below:

=C2=A0

PostgreSQL version ?

=C2=A0

Do you have all = the 103 database in one cluster ? I suspect a DISK IO and CPU spike. Do you= see that ?

=C2=A0

Its hard to say straight if there is a need for REINDEXIN= G. Can you let us know the hardware specifications of the server.

=

=C2=A0

We = will need to understand if the server capacity is falling short for the loa= d being received.=C2=A0

=C2=A0

How many active connections you see at the da= tabase level ?

=C2=A0

I am thinking of increasing values on the following parameters in the c= onf file after some reading ing http://www.postgr= esql.org/docs/9.2/static/runtime-config-resource.html

=C2=A0

Parameters:=

=C2=A0

work_mem

shared_bu= ffers

maintenance_work_mem

= checkpoint_segments

=

=C2=A0

We need to know the hardware specifications. =C2=A0

=C2=A0

=C2=A0Some server = config information currently are:

=C2=A0

1.=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 = data/ directory size is 526G

2.=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Total memory =C2=A0is 24G

<= /div>

=C2=A0

Do you see any over utilization of the memory.

=C2=A0

Regards= ,

Venkata Balaji N


CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addre=
ssee only, and may contain the confidential
information of Argility (Proprietary) Limited and/or its subsidiaries. An=
y review, use or dissemination thereof by anyone
other than the intended addressee is prohibited.If you are not the intend=
ed addressee please notify the writer immediately
and destroy the e-mail. Argility (Proprietary) Limited and its subsidiari=
es distance themselves from and accept no liability
for unauthorised use of their e-mail facilities or e-mails sent other tha=
n strictly for business purposes.
=0D
--001a1147f1a26f7a3c0511616cbc--