TestesPostgreSQL
Origem: I Seminario de Inovacao Tecnologica em Cluster e Grid, a enciclopédia livre.
| Conteúdo |
[editar]
Instalação
Instalação através de um backport do postgresql 8.2 da experimental para testing (etch). O repositório está no 192.168.10.100.
[editar]
Pacotes Instalados
blocok11:~# dpkg -l Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed |/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad) ||/ Name Version Description +++-==============-==============-============================================ ii acpid 1.0.4-5 Utilities for using ACPI power management ii adduser 3.102 Add and remove users and groups ii apt 0.6.46.4-0.1 Advanced front-end for dpkg ii apt-utils 0.6.46.4-0.1 APT utility programs ii aptitude 0.4.4-1 terminal-based apt frontend ii base-files 4 Debian base system miscellaneous files ii base-passwd 3.5.11 Debian base system master password and group ii bash 3.1dfsg-8 The GNU Bourne Again SHell ii bsdmainutils 6.1.6 collection of more utilities from FreeBSD ii bsdutils 2.12r-19 Basic utilities from 4.4BSD-Lite ii busybox 1.1.3-4 Tiny utilities for small and embedded system ii console-common 0.7.69 Basic infrastructure for text console config ii console-data 1.01-7 Keymaps, fonts, charset maps, fallback table ii console-tools 0.2.3dbs-65 Linux console and font utilities ii coreutils 5.97-5.3 The GNU core utilities ii cpio 2.6-17 GNU cpio -- a program to manage archives of ii cron 3.0pl1-100 management of regular background processing ii cyrus-sasl2-do 2.1.22.dfsg1-8 Documentation for Cyrus SASL library and uti ii debconf 1.5.11 Debian configuration management system ii debconf-i18n 1.5.11 full internationalization support for debcon ii debian-archive 2007.02.19 GnuPG archive keys of the Debian archive ii debianutils 2.17 Miscellaneous utilities specific to Debian ii dhcp3-client 3.0.4-13 DHCP Client ii dhcp3-common 3.0.4-13 Common files used by all the dhcp3* packages ii diff 2.8.1-11 File comparison utilities ii dmidecode 2.8-4 Dump Desktop Management Interface data ii dpkg 1.13.25 package maintenance system for Debian ii dselect 1.13.25 user tool to manage Debian packages ii e2fslibs 1.39+1.40-WIP- ext2 filesystem libraries ii e2fsprogs 1.39+1.40-WIP- ext2 file system utilities and libraries ii ed 0.2-20 The classic unix line editor ii eject 2.1.4-3 ejects CDs and operates CD-Changers under Li ii findutils 4.2.28-1 utilities for finding files--find, xargs, an ii gcc-4.1-base 4.1.1-21 The GNU Compiler Collection (base package) ii gnupg 1.4.6-1 GNU privacy guard - a free PGP replacement ii gpgv 1.4.6-1 GNU privacy guard - signature verification t ii grep 2.5.1.ds2-6 GNU grep, egrep and fgrep ii groff-base 1.18.1.1-12 GNU troff text-formatting system (base syste ii grub 0.97-23 GRand Unified Bootloader ii gzip 1.3.5-15 The GNU compression utility ii hostname 2.93 utility to set/show the host name or domain ii ifupdown 0.6.8 high level tools to configure network interf ii info 4.8.dfsg.1-4 Standalone GNU Info documentation browser ii initramfs-tool 0.85e tools for generating an initramfs ii initscripts 2.86.ds1-38 Scripts for initializing and shutting down t ii installation-r 2.29 system installation report ii iptables 1.3.6.0debian1 administration tools for packet filtering an ii iputils-ping 20020927-6 Tools to test the reachability of network ho ii klibc-utils 1.4.34-1 small statically-linked utilities built with ii klogd 1.4.1-18 Kernel Logging Daemon ii laptop-detect 0.12.1 attempt to detect a laptop ii less 394-4 Pager program similar to more ii libacl1 2.2.41-1 Access control list shared library ii libattr1 2.4.32-1 Extended attribute shared library ii libblkid1 1.39+1.40-WIP- block device id library ii libbz2-1.0 1.0.3-6 high-quality block-sorting file compressor l ii libc6 2.3.6.ds1-13 GNU C Library: Shared libraries ii libc6-i686 2.3.6.ds1-13 GNU C Library: Shared libraries [i686 optimi ii libcap1 1.10-14 support for getting/setting POSIX.1e capabil ii libcomerr2 1.39+1.40-WIP- common error description library ii libconsole 0.2.3dbs-65 Shared libraries for Linux console and font ii libdb4.2 4.2.52+dfsg-1 Berkeley v4.2 Database Libraries [runtime] ii libdb4.3 4.3.29-8 Berkeley v4.3 Database Libraries [runtime] ii libdb4.4 4.4.20-8 Berkeley v4.4 Database Libraries [runtime] ii libdevmapper1. 1.02.08-1 The Linux Kernel Device Mapper userspace lib ii libedit2 2.9.cvs.200505 BSD editline and history libraries ii libgcc1 4.1.1-21 GCC support library ii libgcrypt11 1.2.3-2 LGPL Crypto library - runtime library ii libgdbm3 1.8.3-3 GNU dbm database routines (runtime version) ii libgnutls13 1.4.4-3 the GNU TLS library - runtime library ii libgpg-error0 1.4-1 library for common error values and messages ii libgpmg1 1.19.6-24 General Purpose Mouse - shared library ii libklibc 1.4.34-1 minimal libc subset for use with initramfs ii libkrb53 1.4.4-7 MIT Kerberos runtime libraries ii libldap2 2.1.30-13.3 OpenLDAP libraries ii liblocale-gett 1.05-1 Using libc functions for internationalizatio ii liblzo1 1.08-3 data compression library (old version) ii libncurses5 5.5-5 Shared libraries for terminal handling ii libncursesw5 5.5-5 Shared libraries for terminal handling (wide ii libnewt0.52 0.52.2-9 Not Erik's Windowing Toolkit - text mode win ii libopencdk8 0.5.9-2 Open Crypto Development Kit (OpenCDK) (runti ii libpam-modules 0.79-4 Pluggable Authentication Modules for PAM ii libpam-runtime 0.79-4 Runtime support for the PAM library ii libpam0g 0.79-4 Pluggable Authentication Modules library ii libpopt0 1.10-3 lib for parsing cmdline parameters ii libpq5 8.2.3-1 PostgreSQL C client library ii libreadline5 5.2-2 GNU readline and history libraries, run-time ii libsasl2-2 2.1.22.dfsg1-8 Authentication abstraction library ii libselinux1 1.32-3 SELinux shared libraries ii libsepol1 1.14-2 Security Enhanced Linux policy library for c ii libsigc++-2.0- 2.0.17-2 type-safe Signal Framework for C++ - runtime ii libslang2 2.0.6-4 The S-Lang programming library - runtime ver ii libss2 1.39+1.40-WIP- command-line interface parsing library ii libssl0.9.8 0.9.8c-4 SSL shared libraries ii libstdc++6 4.1.1-21 The GNU Standard C++ Library v3 ii libtasn1-3 0.3.6-2 Manage ASN.1 structures (runtime) ii libtext-charwi 0.04-4 get display widths of characters on the term ii libtext-iconv- 1.4-3 converts between character sets in Perl ii libtext-wrapi1 0.06-5 internationalized substitute of Text::Wrap ii libusb-0.1-4 0.1.12-5 userspace USB programming library ii libuuid1 1.39+1.40-WIP- universally unique id library ii libvolume-id0 0.105-2 libvolume_id shared library ii libwrap0 7.6.dbs-13 Wietse Venema's TCP wrappers library ii libxml2 2.6.27.dfsg-1 GNOME XML library ii libxslt1.1 1.1.19-1 XSLT processing library - runtime library ii linux-image-2. 2.6.18+6 Linux kernel 2.6 image on PPro/Celeron/PII/P ii linux-image-2. 2.6.18-7 Linux 2.6.18 image on PPro/Celeron/PII/PIII/ ii linux-image-2. 2.6.18.dfsg.1- Linux 2.6.18 image on PPro/Celeron/PII/PIII/ ii login 4.0.18.1-6 system login tools ii logrotate 3.7.1-3 Log rotation utility ii lsb-base 3.1-23 Linux Standard Base 3.1 init script function ii lvm-common 1.5.20 The Logical Volume Manager for Linux (common ii lvm2 2.02.06-3 The Linux Logical Volume Manager ii lynx 2.8.5-2sarge2. Text-mode WWW Browser ii makedev 2.3.1-83 creates device files in /dev ii man-db 2.4.3-5 The on-line manual pager ii manpages 2.39-1 Manual pages about using a GNU/Linux system ii mawk 1.3.3-11 a pattern scanning and text processing langu ii mime-support 3.39-1 MIME files 'mime.types' & 'mailcap', and sup ii mktemp 1.5-2 Makes unique filenames for temporary files ii module-init-to 3.3-pre4-2 tools for managing Linux kernel modules ii mount 2.12r-19 Tools for mounting and manipulating filesyst ii nano 2.0.2-1 free Pico clone with some new features ii ncurses-base 5.5-5 Descriptions of common terminal types ii ncurses-bin 5.5-5 Terminal-related programs and man pages ii net-tools 1.60-17 The NET-3 networking toolkit ii netbase 4.29 Basic TCP/IP networking system ii netcat 1.10-32 TCP/IP swiss army knife ii openbsd-inetd 0.20050402-5 The OpenBSD Internet Superserver ii openssh-client 4.3p2-8 Secure shell client, an rlogin/rsh/rcp repla ii openssh-server 4.3p2-8 Secure shell server, an rshd replacement ii openssl 0.9.8c-4 Secure Socket Layer (SSL) binary and related ii passwd 4.0.18.1-6 change and administer password and group dat ii perl 5.8.8-7 Larry Wall's Practical Extraction and Report ii perl-base 5.8.8-7 The Pathologically Eclectic Rubbish Lister ii perl-doc 5.8.8-7 Perl documentation ii perl-modules 5.8.8-7 Core Perl modules ii postgresql-8.2 8.2.3-1 object-relational SQL database, version 8.2 ii postgresql-cli 8.2.3-1 front-end programs for PostgreSQL 8.2 ii postgresql-cli 71 manager for multiple PostgreSQL client versi ii postgresql-com 71 manager for PostgreSQL database clusters ii postgresql-con 8.2.3-1 additional facilities for PostgreSQL ii postgresql-doc 8.2.3-1 documentation for the PostgreSQL database ma ii procps 3.2.7-3 /proc file system utilities ii readline-commo 5.2-2 GNU readline and history libraries, common f ii sed 4.1.5-1 The GNU sed stream editor ii ssh 4.3p2-8 Secure shell client and server (transitional ii ssl-cert 1.0.14 Simple debconf wrapper for openssl ii sysklogd 1.4.1-18 System Logging Daemon ii sysv-rc 2.86.ds1-38 System-V-like runlevel change mechanism ii sysvinit 2.86.ds1-38 System-V-like init utilities ii sysvinit-utils 2.86.ds1-38 System-V-like utilities ii tar 1.16-2 GNU tar ii tasksel 2.66 Tool for selecting tasks for installation on ii tasksel-data 2.66 Official tasks used for installation of Debi ii tcpd 7.6.dbs-13 Wietse Venema's TCP wrapper utilities ii traceroute 1.4a12-21 traces the route taken by packets over a TCP ii tzdata 2007b-1 Time Zone and Daylight Saving Time Data ii udev 0.105-2 /dev/ and hotplug management daemon ii update-inetd 4.27-0.4 inetd.conf updater ii usbutils 0.72-7 USB console utilities ii util-linux 2.12r-19 Miscellaneous system utilities ii vim 7.0-122+1 Vi IMproved - enhanced vi editor ii vim-common 7.0-122+1 Vi IMproved - Common files ii vim-runtime 7.0-122+1 Vi IMproved - Runtime files ii vim-tiny 7.0-122+1 Vi IMproved - enhanced vi editor - compact v ii wget 1.10.2-2 retrieves files from the web ii whiptail 0.52.2-9 Displays user-friendly dialog boxes from she ii zlib1g 1.2.3-13 compression library - runtime
[editar]
Detalhes CPUs
processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.00GHz stepping : 3 cpu MHz : 2993.030 cache size : 2048 KB physical id : 0 siblings : 2 core id : 0 cpu cores : 1 fdiv_bug : no hlt_bug : no f00f_bug : no coma_bug : no fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl cid cx16 xtpr bogomips : 5989.64
processor : 1 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.00GHz stepping : 3 cpu MHz : 2993.030 cache size : 2048 KB physical id : 0 siblings : 2 core id : 0 cpu cores : 1 fdiv_bug : no hlt_bug : no f00f_bug : no coma_bug : no fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl cid cx16 xtpr bogomips : 5985.49
processor : 2 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.00GHz stepping : 3 cpu MHz : 2993.030 cache size : 2048 KB physical id : 3 siblings : 2 core id : 0 cpu cores : 1 fdiv_bug : no hlt_bug : no f00f_bug : no coma_bug : no fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl cid cx16 xtpr bogomips : 5985.61
processor : 3 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.00GHz stepping : 3 cpu MHz : 2993.030 cache size : 2048 KB physical id : 3 siblings : 2 core id : 0 cpu cores : 1 fdiv_bug : no hlt_bug : no f00f_bug : no coma_bug : no fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl cid cx16 xtpr bogomips : 5985.63
[editar]
Detalhes Memória
blocok11:~# cat /proc/meminfo MemTotal: 2076728 kB MemFree: 1196736 kB Buffers: 42156 kB Cached: 663676 kB SwapCached: 0 kB Active: 614140 kB Inactive: 205632 kB HighTotal: 1179392 kB HighFree: 398100 kB LowTotal: 897336 kB LowFree: 798636 kB SwapTotal: 2715640 kB SwapFree: 2715640 kB Dirty: 21728 kB Writeback: 0 kB AnonPages: 113852 kB Mapped: 33196 kB Slab: 47172 kB PageTables: 5084 kB NFS_Unstable: 0 kB Bounce: 0 kB CommitLimit: 3754004 kB Committed_AS: 294104 kB VmallocTotal: 114680 kB VmallocUsed: 3584 kB VmallocChunk: 110796 kB
[editar]
Testes
- primeiro teste: usar o pgbench, aumentar gradativamente as configurações da máquina.
Resultado:
blocok10:~# time pgbench -c 100 -t 1000 -h 192.168.10.11 -U postgres bench starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 100 number of transactions per client: 1000 number of transactions actually processed: 100000/100000 tps = 105.573099 (including connections establishing) tps = 106.079621 (excluding connections establishing)
- Configuração do postgresql.conf, e kernel.
- Alterado para uso do autovacuum, parametro do postgresql.conf
stats_start_collector = on
- bla:
pgbench -c 100 -t 1500 -h 127.0.0.1 bench
- tabela:
tp 64bits 32bits
1k 520 560
25k 473 366
50k 344 277
75k 327 247
100k 283 234
150k 254 191
blocok10:~# pgbench -c 100 -t 100 -h 192.168.10.11 -U postgres bench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 68.759743 (including connections establishing)
tps = 68.913668 (excluding connections establishing)
blocok10:~# pgbench -n -c 100 -t 100 -h 192.168.10.11 -U postgres bench
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 72.849005 (including connections establishing)
tps = 73.006885 (excluding connections establishing)
1.4 GB de dados.
pgbench -i -s 100 -h 192.168.10.11 -U postgres bench
blocok10:~# pgbench -n -c 100 -t 100 -h 192.168.10.11 -U postgres bench
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 84.234532 (including connections establishing)
tps = 84.448900 (excluding connections establishing)
blocok10:~# pgbench -c 100 -t 100 -h 192.168.10.11 -U postgres bench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 68.759743 (including connections establishing)
tps = 68.913668 (excluding connections establishing)
blocok10:~# pgbench -n -c 100 -t 100 -h 192.168.10.11 -U postgres bench
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 72.849005 (including connections establishing)
tps = 73.006885 (excluding connections establishing)
blocok10:~# pgbench -n -c 100 -t 100 -h 192.168.10.11 -U postgres bench
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 73.346175 (including connections establishing)
tps = 73.514322 (excluding connections establishing)
1.4 GB de dados.
pgbench -i -s 100 -h 192.168.10.11 -U postgres bench
blocok10:~# pgbench -n -c 100 -t 100 -h 192.168.10.11 -U postgres bench
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 77.708254 (including connections establishing)
tps = 77.922269 (excluding connections establishing)
parametros zerados de kernel
blocok10:~# pgbench -c 100 -t 100 -h 192.168.10.11 -U postgres bench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 87.921074 (including connections establishing)
tps = 88.156102 (excluding connections establishing)
blocok10:~# pgbench -n -c 100 -t 100 -h 192.168.10.11 -U postgres bench
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 85.709576 (including connections establishing)
tps = 85.921843 (excluding connections establishing)
echo "2" > /proc/sys/vm/overcommit_memory
blocok10:~# pgbench -n -c 100 -t 100 -h 192.168.10.11 -U postgres bench
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 86.448336 (including connections establishing)
tps = 86.666818 (excluding connections establishing)
echo "deadline" > /sys/block/sda/queue/scheduler
blocok10:~# pgbench -n -c 100 -t 100 -h 192.168.10.11 -U postgres bench
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 88.243313 (including connections establishing)
tps = 88.486811 (excluding connections establishing)
último teste. quase ideal
blocok10:~# pgbench -n -c 100 -t 100 -h 192.168.10.11 -U postgres bench
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 359.396143 (including connections establishing)
tps = 363.222396 (excluding connections establishing)
blocok10:~# pgbench -n -c 100 -t 100 -h 192.168.10.11 -U postgres bench
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 107.444428 (including connections establishing)
tps = 107.822193 (excluding connections establishing)
blocok10:~# sysctl -a
dev.rtc.max-user-freq = 64
dev.cdrom.check_media = 0
dev.cdrom.lock = 1
dev.cdrom.debug = 0
dev.cdrom.autoeject = 0
dev.cdrom.autoclose = 1
dev.cdrom.info = CD-ROM information, Id: cdrom.c 3.20 2003/12/17
dev.cdrom.info =
dev.cdrom.info = drive name: hda
dev.cdrom.info = drive speed: 24
dev.cdrom.info = drive # of slots: 1
dev.cdrom.info = Can close tray: 1
dev.cdrom.info = Can open tray: 1
dev.cdrom.info = Can lock tray: 1
dev.cdrom.info = Can change speed: 1
dev.cdrom.info = Can select disk: 0
dev.cdrom.info = Can read multisession: 1
dev.cdrom.info = Can read MCN: 1
dev.cdrom.info = Reports media changed: 1
dev.cdrom.info = Can play audio: 1
dev.cdrom.info = Can write CD-R: 0
dev.cdrom.info = Can write CD-RW: 0
dev.cdrom.info = Can read DVD: 0
dev.cdrom.info = Can write DVD-R: 0
dev.cdrom.info = Can write DVD-RAM: 0
dev.cdrom.info = Can read MRW: 1
dev.cdrom.info = Can write MRW: 1
dev.cdrom.info = Can write RAM: 0
dev.cdrom.info =
dev.cdrom.info =
dev.scsi.logging_level = 0
dev.hpet.max-user-freq = 64
net.ipv6.conf.default.accept_ra_pinfo = 1
net.ipv6.conf.default.accept_ra_defrtr = 1
net.ipv6.conf.default.max_addresses = 16
net.ipv6.conf.default.max_desync_factor = 600
net.ipv6.conf.default.regen_max_retry = 5
net.ipv6.conf.default.temp_prefered_lft = 86400
net.ipv6.conf.default.temp_valid_lft = 604800
net.ipv6.conf.default.use_tempaddr = 0
net.ipv6.conf.default.force_mld_version = 0
net.ipv6.conf.default.router_solicitation_delay = 1
net.ipv6.conf.default.router_solicitation_interval = 4
net.ipv6.conf.default.router_solicitations = 3
net.ipv6.conf.default.dad_transmits = 1
net.ipv6.conf.default.autoconf = 1
net.ipv6.conf.default.accept_redirects = 1
net.ipv6.conf.default.accept_ra = 1
net.ipv6.conf.default.mtu = 1280
net.ipv6.conf.default.hop_limit = 64
net.ipv6.conf.default.forwarding = 0
net.ipv6.conf.all.accept_ra_pinfo = 1
net.ipv6.conf.all.accept_ra_defrtr = 1
net.ipv6.conf.all.max_addresses = 16
net.ipv6.conf.all.max_desync_factor = 600
net.ipv6.conf.all.regen_max_retry = 5
net.ipv6.conf.all.temp_prefered_lft = 86400
net.ipv6.conf.all.temp_valid_lft = 604800
net.ipv6.conf.all.use_tempaddr = 0
net.ipv6.conf.all.force_mld_version = 0
net.ipv6.conf.all.router_solicitation_delay = 1
net.ipv6.conf.all.router_solicitation_interval = 4
net.ipv6.conf.all.router_solicitations = 3
net.ipv6.conf.all.dad_transmits = 1
net.ipv6.conf.all.autoconf = 1
net.ipv6.conf.all.accept_redirects = 1
net.ipv6.conf.all.accept_ra = 1
net.ipv6.conf.all.mtu = 1280
net.ipv6.conf.all.hop_limit = 64
net.ipv6.conf.all.forwarding = 0
net.ipv6.conf.eth0.accept_ra_pinfo = 1
net.ipv6.conf.eth0.accept_ra_defrtr = 1
net.ipv6.conf.eth0.max_addresses = 16
net.ipv6.conf.eth0.max_desync_factor = 600
net.ipv6.conf.eth0.regen_max_retry = 5
net.ipv6.conf.eth0.temp_prefered_lft = 86400
net.ipv6.conf.eth0.temp_valid_lft = 604800
net.ipv6.conf.eth0.use_tempaddr = 0
net.ipv6.conf.eth0.force_mld_version = 0
net.ipv6.conf.eth0.router_solicitation_delay = 1
net.ipv6.conf.eth0.router_solicitation_interval = 4
net.ipv6.conf.eth0.router_solicitations = 3
net.ipv6.conf.eth0.dad_transmits = 1
net.ipv6.conf.eth0.autoconf = 1
net.ipv6.conf.eth0.accept_redirects = 1
net.ipv6.conf.eth0.accept_ra = 1
net.ipv6.conf.eth0.mtu = 1500
net.ipv6.conf.eth0.hop_limit = 64
net.ipv6.conf.eth0.forwarding = 0
net.ipv6.conf.lo.accept_ra_pinfo = 1
net.ipv6.conf.lo.accept_ra_defrtr = 1
net.ipv6.conf.lo.max_addresses = 16
net.ipv6.conf.lo.max_desync_factor = 600
net.ipv6.conf.lo.regen_max_retry = 5
net.ipv6.conf.lo.temp_prefered_lft = 86400
net.ipv6.conf.lo.temp_valid_lft = 604800
net.ipv6.conf.lo.use_tempaddr = -1
net.ipv6.conf.lo.force_mld_version = 0
net.ipv6.conf.lo.router_solicitation_delay = 1
net.ipv6.conf.lo.router_solicitation_interval = 4
net.ipv6.conf.lo.router_solicitations = 3
net.ipv6.conf.lo.dad_transmits = 1
net.ipv6.conf.lo.autoconf = 1
net.ipv6.conf.lo.accept_redirects = 1
net.ipv6.conf.lo.accept_ra = 1
net.ipv6.conf.lo.mtu = 16436
net.ipv6.conf.lo.hop_limit = 64
net.ipv6.conf.lo.forwarding = 0
net.ipv6.neigh.eth0.base_reachable_time_ms = 30000
net.ipv6.neigh.eth0.retrans_time_ms = 1000
net.ipv6.neigh.eth0.locktime = 0
net.ipv6.neigh.eth0.proxy_delay = 80
net.ipv6.neigh.eth0.anycast_delay = 100
net.ipv6.neigh.eth0.proxy_qlen = 64
net.ipv6.neigh.eth0.unres_qlen = 3
net.ipv6.neigh.eth0.gc_stale_time = 60
net.ipv6.neigh.eth0.delay_first_probe_time = 5
net.ipv6.neigh.eth0.base_reachable_time = 30
net.ipv6.neigh.eth0.retrans_time = 250
net.ipv6.neigh.eth0.app_solicit = 0
net.ipv6.neigh.eth0.ucast_solicit = 3
net.ipv6.neigh.eth0.mcast_solicit = 3
net.ipv6.neigh.lo.base_reachable_time_ms = 30000
net.ipv6.neigh.lo.retrans_time_ms = 1000
net.ipv6.neigh.lo.locktime = 0
net.ipv6.neigh.lo.proxy_delay = 80
net.ipv6.neigh.lo.anycast_delay = 100
net.ipv6.neigh.lo.proxy_qlen = 64
net.ipv6.neigh.lo.unres_qlen = 3
net.ipv6.neigh.lo.gc_stale_time = 60
net.ipv6.neigh.lo.delay_first_probe_time = 5
net.ipv6.neigh.lo.base_reachable_time = 30
net.ipv6.neigh.lo.retrans_time = 250
net.ipv6.neigh.lo.app_solicit = 0
net.ipv6.neigh.lo.ucast_solicit = 3
net.ipv6.neigh.lo.mcast_solicit = 3
net.ipv6.neigh.default.base_reachable_time_ms = 30000
net.ipv6.neigh.default.retrans_time_ms = 1000
net.ipv6.neigh.default.gc_thresh3 = 1024
net.ipv6.neigh.default.gc_thresh2 = 512
net.ipv6.neigh.default.gc_thresh1 = 128
net.ipv6.neigh.default.gc_interval = 30
net.ipv6.neigh.default.locktime = 0
net.ipv6.neigh.default.proxy_delay = 80
net.ipv6.neigh.default.anycast_delay = 100
net.ipv6.neigh.default.proxy_qlen = 64
net.ipv6.neigh.default.unres_qlen = 3
net.ipv6.neigh.default.gc_stale_time = 60
net.ipv6.neigh.default.delay_first_probe_time = 5
net.ipv6.neigh.default.base_reachable_time = 30
net.ipv6.neigh.default.retrans_time = 250
net.ipv6.neigh.default.app_solicit = 0
net.ipv6.neigh.default.ucast_solicit = 3
net.ipv6.neigh.default.mcast_solicit = 3
net.ipv6.mld_max_msf = 64
net.ipv6.ip6frag_secret_interval = 600
net.ipv6.ip6frag_time = 60
net.ipv6.ip6frag_low_thresh = 196608
net.ipv6.ip6frag_high_thresh = 262144
net.ipv6.bindv6only = 0
net.ipv6.icmp.ratelimit = 250
net.ipv6.route.gc_min_interval_ms = 500
net.ipv6.route.min_adv_mss = 4
net.ipv6.route.mtu_expires = 600
net.ipv6.route.gc_elasticity = 0
net.ipv6.route.gc_interval = 30
net.ipv6.route.gc_timeout = 60
net.ipv6.route.gc_min_interval = 0
net.ipv6.route.max_size = 4096
net.ipv6.route.gc_thresh = 1024
error: "Operation not permitted" reading key "net.ipv6.route.flush"
net.unix.max_dgram_qlen = 10
net.token-ring.rif_timeout = 150000
net.ipv4.conf.eth0.promote_secondaries = 0
net.ipv4.conf.eth0.force_igmp_version = 0
net.ipv4.conf.eth0.disable_policy = 0
net.ipv4.conf.eth0.disable_xfrm = 0
net.ipv4.conf.eth0.arp_accept = 0
net.ipv4.conf.eth0.arp_ignore = 0
net.ipv4.conf.eth0.arp_announce = 0
net.ipv4.conf.eth0.arp_filter = 0
net.ipv4.conf.eth0.tag = 0
net.ipv4.conf.eth0.log_martians = 0
net.ipv4.conf.eth0.bootp_relay = 0
net.ipv4.conf.eth0.medium_id = 0
net.ipv4.conf.eth0.proxy_arp = 0
net.ipv4.conf.eth0.accept_source_route = 1
net.ipv4.conf.eth0.send_redirects = 1
net.ipv4.conf.eth0.rp_filter = 0
net.ipv4.conf.eth0.shared_media = 1
net.ipv4.conf.eth0.secure_redirects = 1
net.ipv4.conf.eth0.accept_redirects = 1
net.ipv4.conf.eth0.mc_forwarding = 0
net.ipv4.conf.eth0.forwarding = 0
net.ipv4.conf.lo.promote_secondaries = 0
net.ipv4.conf.lo.force_igmp_version = 0
net.ipv4.conf.lo.disable_policy = 1
net.ipv4.conf.lo.disable_xfrm = 1
net.ipv4.conf.lo.arp_accept = 0
net.ipv4.conf.lo.arp_ignore = 0
net.ipv4.conf.lo.arp_announce = 0
net.ipv4.conf.lo.arp_filter = 0
net.ipv4.conf.lo.tag = 0
net.ipv4.conf.lo.log_martians = 0
net.ipv4.conf.lo.bootp_relay = 0
net.ipv4.conf.lo.medium_id = 0
net.ipv4.conf.lo.proxy_arp = 0
net.ipv4.conf.lo.accept_source_route = 1
net.ipv4.conf.lo.send_redirects = 1
net.ipv4.conf.lo.rp_filter = 0
net.ipv4.conf.lo.shared_media = 1
net.ipv4.conf.lo.secure_redirects = 1
net.ipv4.conf.lo.accept_redirects = 1
net.ipv4.conf.lo.mc_forwarding = 0
net.ipv4.conf.lo.forwarding = 0
net.ipv4.conf.default.promote_secondaries = 0
net.ipv4.conf.default.force_igmp_version = 0
net.ipv4.conf.default.disable_policy = 0
net.ipv4.conf.default.disable_xfrm = 0
net.ipv4.conf.default.arp_accept = 0
net.ipv4.conf.default.arp_ignore = 0
net.ipv4.conf.default.arp_announce = 0
net.ipv4.conf.default.arp_filter = 0
net.ipv4.conf.default.tag = 0
net.ipv4.conf.default.log_martians = 0
net.ipv4.conf.default.bootp_relay = 0
net.ipv4.conf.default.medium_id = 0
net.ipv4.conf.default.proxy_arp = 0
net.ipv4.conf.default.accept_source_route = 1
net.ipv4.conf.default.send_redirects = 1
net.ipv4.conf.default.rp_filter = 0
net.ipv4.conf.default.shared_media = 1
net.ipv4.conf.default.secure_redirects = 1
net.ipv4.conf.default.accept_redirects = 1
net.ipv4.conf.default.mc_forwarding = 0
net.ipv4.conf.default.forwarding = 0
net.ipv4.conf.all.promote_secondaries = 0
net.ipv4.conf.all.force_igmp_version = 0
net.ipv4.conf.all.disable_policy = 0
net.ipv4.conf.all.disable_xfrm = 0
net.ipv4.conf.all.arp_accept = 0
net.ipv4.conf.all.arp_ignore = 0
net.ipv4.conf.all.arp_announce = 0
net.ipv4.conf.all.arp_filter = 0
net.ipv4.conf.all.tag = 0
net.ipv4.conf.all.log_martians = 0
net.ipv4.conf.all.bootp_relay = 0
net.ipv4.conf.all.medium_id = 0
net.ipv4.conf.all.proxy_arp = 0
net.ipv4.conf.all.accept_source_route = 0
net.ipv4.conf.all.send_redirects = 1
net.ipv4.conf.all.rp_filter = 0
net.ipv4.conf.all.shared_media = 1
net.ipv4.conf.all.secure_redirects = 1
net.ipv4.conf.all.accept_redirects = 1
net.ipv4.conf.all.mc_forwarding = 0
net.ipv4.conf.all.forwarding = 0
net.ipv4.neigh.eth0.base_reachable_time_ms = 30000
net.ipv4.neigh.eth0.retrans_time_ms = 1000
net.ipv4.neigh.eth0.locktime = 100
net.ipv4.neigh.eth0.proxy_delay = 80
net.ipv4.neigh.eth0.anycast_delay = 100
net.ipv4.neigh.eth0.proxy_qlen = 64
net.ipv4.neigh.eth0.unres_qlen = 3
net.ipv4.neigh.eth0.gc_stale_time = 60
net.ipv4.neigh.eth0.delay_first_probe_time = 5
net.ipv4.neigh.eth0.base_reachable_time = 30
net.ipv4.neigh.eth0.retrans_time = 100
net.ipv4.neigh.eth0.app_solicit = 0
net.ipv4.neigh.eth0.ucast_solicit = 3
net.ipv4.neigh.eth0.mcast_solicit = 3
net.ipv4.neigh.lo.base_reachable_time_ms = 30000
net.ipv4.neigh.lo.retrans_time_ms = 1000
net.ipv4.neigh.lo.locktime = 100
net.ipv4.neigh.lo.proxy_delay = 80
net.ipv4.neigh.lo.anycast_delay = 100
net.ipv4.neigh.lo.proxy_qlen = 64
net.ipv4.neigh.lo.unres_qlen = 3
net.ipv4.neigh.lo.gc_stale_time = 60
net.ipv4.neigh.lo.delay_first_probe_time = 5
net.ipv4.neigh.lo.base_reachable_time = 30
net.ipv4.neigh.lo.retrans_time = 100
net.ipv4.neigh.lo.app_solicit = 0
net.ipv4.neigh.lo.ucast_solicit = 3
net.ipv4.neigh.lo.mcast_solicit = 3
net.ipv4.neigh.default.base_reachable_time_ms = 30000
net.ipv4.neigh.default.retrans_time_ms = 1000
net.ipv4.neigh.default.gc_thresh3 = 1024
net.ipv4.neigh.default.gc_thresh2 = 512
net.ipv4.neigh.default.gc_thresh1 = 128
net.ipv4.neigh.default.gc_interval = 30
net.ipv4.neigh.default.locktime = 100
net.ipv4.neigh.default.proxy_delay = 80
net.ipv4.neigh.default.anycast_delay = 100
net.ipv4.neigh.default.proxy_qlen = 64
net.ipv4.neigh.default.unres_qlen = 3
net.ipv4.neigh.default.gc_stale_time = 60
net.ipv4.neigh.default.delay_first_probe_time = 5
net.ipv4.neigh.default.base_reachable_time = 30
net.ipv4.neigh.default.retrans_time = 100
net.ipv4.neigh.default.app_solicit = 0
net.ipv4.neigh.default.ucast_solicit = 3
net.ipv4.neigh.default.mcast_solicit = 3
net.ipv4.tcp_slow_start_after_idle = 1
net.ipv4.tcp_dma_copybreak = 4096
net.ipv4.tcp_workaround_signed_windows = 0
net.ipv4.tcp_base_mss = 512
net.ipv4.tcp_mtu_probing = 0
net.ipv4.tcp_abc = 0
net.ipv4.tcp_congestion_control = bic
net.ipv4.tcp_tso_win_divisor = 3
net.ipv4.tcp_moderate_rcvbuf = 1
net.ipv4.tcp_no_metrics_save = 0
net.ipv4.ipfrag_max_dist = 64
net.ipv4.ipfrag_secret_interval = 600
net.ipv4.tcp_low_latency = 0
net.ipv4.tcp_frto = 0
net.ipv4.tcp_tw_reuse = 0
net.ipv4.icmp_ratemask = 6168
net.ipv4.icmp_ratelimit = 250
net.ipv4.tcp_adv_win_scale = 2
net.ipv4.tcp_app_win = 31
net.ipv4.tcp_rmem = 4096 87380 4194304
net.ipv4.tcp_wmem = 4096 16384 4194304
net.ipv4.tcp_mem = 98304 131072 196608
net.ipv4.tcp_dsack = 1
net.ipv4.tcp_ecn = 0
net.ipv4.tcp_reordering = 3
net.ipv4.tcp_fack = 1
net.ipv4.tcp_orphan_retries = 0
net.ipv4.inet_peer_gc_maxtime = 120
net.ipv4.inet_peer_gc_mintime = 10
net.ipv4.inet_peer_maxttl = 600
net.ipv4.inet_peer_minttl = 120
net.ipv4.inet_peer_threshold = 65664
net.ipv4.igmp_max_msf = 10
net.ipv4.igmp_max_memberships = 20
net.ipv4.route.secret_interval = 600
net.ipv4.route.min_adv_mss = 256
net.ipv4.route.min_pmtu = 552
net.ipv4.route.mtu_expires = 600
net.ipv4.route.gc_elasticity = 8
net.ipv4.route.error_burst = 1250
net.ipv4.route.error_cost = 250
net.ipv4.route.redirect_silence = 5120
net.ipv4.route.redirect_number = 9
net.ipv4.route.redirect_load = 5
net.ipv4.route.gc_interval = 60
net.ipv4.route.gc_timeout = 300
net.ipv4.route.gc_min_interval_ms = 500
net.ipv4.route.gc_min_interval = 0
net.ipv4.route.max_size = 524288
net.ipv4.route.gc_thresh = 32768
net.ipv4.route.max_delay = 10
net.ipv4.route.min_delay = 2
error: "Operation not permitted" reading key "net.ipv4.route.flush"
net.ipv4.icmp_errors_use_inbound_ifaddr = 0
net.ipv4.icmp_ignore_bogus_error_responses = 1
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.icmp_echo_ignore_all = 0
net.ipv4.ip_local_port_range = 32768 61000
net.ipv4.tcp_max_syn_backlog = 1024
net.ipv4.tcp_rfc1337 = 0
net.ipv4.tcp_stdurg = 0
net.ipv4.tcp_abort_on_overflow = 0
net.ipv4.tcp_tw_recycle = 0
net.ipv4.tcp_syncookies = 0
net.ipv4.tcp_fin_timeout = 60
net.ipv4.tcp_retries2 = 15
net.ipv4.tcp_retries1 = 3
net.ipv4.tcp_keepalive_intvl = 75
net.ipv4.tcp_keepalive_probes = 9
net.ipv4.tcp_keepalive_time = 7200
net.ipv4.ipfrag_time = 30
net.ipv4.ip_dynaddr = 0
net.ipv4.ipfrag_low_thresh = 196608
net.ipv4.ipfrag_high_thresh = 262144
net.ipv4.tcp_max_tw_buckets = 180000
net.ipv4.tcp_max_orphans = 32768
net.ipv4.tcp_synack_retries = 5
net.ipv4.tcp_syn_retries = 5
net.ipv4.ip_nonlocal_bind = 0
net.ipv4.ip_no_pmtu_disc = 0
net.ipv4.ip_default_ttl = 64
net.ipv4.ip_forward = 0
net.ipv4.tcp_retrans_collapse = 1
net.ipv4.tcp_sack = 1
net.ipv4.tcp_window_scaling = 1
net.ipv4.tcp_timestamps = 1
net.core.netdev_budget = 300
net.core.somaxconn = 128
net.core.xfrm_aevent_rseqth = 2
net.core.xfrm_aevent_etime = 10
net.core.optmem_max = 10240
net.core.message_burst = 10
net.core.message_cost = 5
net.core.netdev_max_backlog = 1000
net.core.dev_weight = 64
net.core.rmem_default = 109568
net.core.wmem_default = 109568
net.core.rmem_max = 131071
net.core.wmem_max = 131071
vm.vdso_enabled = 1
vm.swap_token_timeout = 300
vm.legacy_va_layout = 0
vm.vfs_cache_pressure = 100
vm.block_dump = 0
vm.laptop_mode = 0
vm.max_map_count = 65536
vm.percpu_pagelist_fraction = 0
vm.min_free_kbytes = 3831
vm.drop_caches = 0
vm.lowmem_reserve_ratio = 256 256 32
vm.swappiness = 60
vm.nr_pdflush_threads = 2
vm.dirty_expire_centisecs = 3000
vm.dirty_writeback_centisecs = 500
vm.dirty_ratio = 40
vm.dirty_background_ratio = 10
vm.page-cluster = 3
vm.overcommit_ratio = 50
vm.panic_on_oom = 0
vm.overcommit_memory = 0
kernel.max_lock_depth = 1024
kernel.acpi_video_flags = 0
kernel.randomize_va_space = 1
kernel.bootloader_type = 113
kernel.unknown_nmi_panic = 0
kernel.ngroups_max = 65536
kernel.printk_ratelimit_burst = 10
kernel.printk_ratelimit = 5
kernel.panic_on_oops = 0
kernel.pid_max = 32768
kernel.overflowgid = 65534
kernel.overflowuid = 65534
kernel.pty.nr = 2
kernel.pty.max = 4096
kernel.random.uuid = 7a297ded-04f6-458d-a3b4-5b78f710ee45
kernel.random.boot_id = 4a6f7787-ebb4-47e0-81f9-78aed283f3fc
kernel.random.write_wakeup_threshold = 128
kernel.random.read_wakeup_threshold = 64
kernel.random.entropy_avail = 182
kernel.random.poolsize = 4096
kernel.threads-max = 32764
kernel.cad_pid = 1
kernel.sysrq = 1
kernel.sem = 250 32000 32 128
kernel.msgmnb = 16384
kernel.msgmni = 16
kernel.msgmax = 8192
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 33554432
kernel.acct = 4 2 30
kernel.hotplug =
kernel.modprobe = /sbin/modprobe
kernel.printk = 7 4 1 7
kernel.ctrl-alt-del = 0
kernel.real-root-dev = 0
kernel.cap-bound = -257
kernel.tainted = 0
kernel.core_pattern = core
kernel.core_uses_pid = 0
kernel.panic = 0
kernel.domainname = (none)
kernel.hostname = blocok10
kernel.version = #1 SMP Wed Feb 21 16:06:54 UTC 2007
kernel.osrelease = 2.6.18-4-686
kernel.ostype = Linux
fs.mqueue.msgsize_max = 8192
fs.mqueue.msg_max = 10
fs.mqueue.queues_max = 256
fs.quota.warnings = 1
fs.quota.syncs = 13
fs.quota.free_dquots = 0
fs.quota.allocated_dquots = 0
fs.quota.cache_hits = 0
fs.quota.writes = 0
fs.quota.reads = 0
fs.quota.drops = 0
fs.quota.lookups = 0
fs.suid_dumpable = 0
fs.inotify.max_queued_events = 16384
fs.inotify.max_user_watches = 8192
fs.inotify.max_user_instances = 128
fs.aio-max-nr = 65536
fs.aio-nr = 0
fs.lease-break-time = 45
fs.dir-notify-enable = 1
fs.leases-enable = 1
fs.overflowgid = 65534
fs.overflowuid = 65534
fs.dentry-state = 55206 53802 45 0 0 0
fs.file-max = 205778
fs.file-nr = 224 0 205778
fs.inode-state = 31376 0 0 0 0 0 0
fs.inode-nr = 31376 0
IBM64 - Configuração.
stgres@ibmdebian6407:/usr/local/src/postgresql-8.2.3/contrib$ cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 5110 @ 1.60GHz
stepping : 6
cpu MHz : 1595.931
cache size : 4096 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx tm2 cx16 xtpr lahf_lm
bogomips : 3195.11
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 5110 @ 1.60GHz
stepping : 6
cpu MHz : 1595.931
cache size : 4096 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx tm2 cx16 xtpr lahf_lm
bogomips : 3191.89
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 5110 @ 1.60GHz
stepping : 6
cpu MHz : 1595.931
cache size : 4096 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 2
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx tm2 cx16 xtpr lahf_lm
bogomips : 3192.03
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 5110 @ 1.60GHz
stepping : 6
cpu MHz : 1595.931
cache size : 4096 KB
physical id : 3
siblings : 2
core id : 1
cpu cores : 2
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx tm2 cx16 xtpr lahf_lm
bogomips : 3191.94
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:
postgres@ibmdebian6407:/usr/local/src/postgresql-8.2.3/contrib$ cat /proc/meminfo
MemTotal: 8176944 kB
MemFree: 2825356 kB
Buffers: 53132 kB
Cached: 4619916 kB
SwapCached: 0 kB
Active: 4671748 kB
Inactive: 195500 kB
HighTotal: 0 kB
HighFree: 0 kB
LowTotal: 8176944 kB
LowFree: 2825356 kB
SwapTotal: 5849080 kB
SwapFree: 5849080 kB
Dirty: 239944 kB
Writeback: 0 kB
AnonPages: 193884 kB
Mapped: 1575220 kB
Slab: 140828 kB
PageTables: 317136 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
CommitLimit: 9937552 kB
Committed_AS: 1969124 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 265744 kB
VmallocChunk: 34359472015 kB
1 disco scsi.
postgres@ibmdebian6407:~$ pgbench -c 100 -t 100 -h 127.0.0.1 -U postgres bench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 288.013547 (including connections establishing)
tps = 290.343641 (excluding connections establishing)
postgres@ibmdebian6407:~$ pgbench -c 100 -t 100 -h 127.0.0.1 -U postgres bench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 1690.712830 (including connections establishing)
tps = 1775.320419 (excluding connections establishing)
Dados de tuning de máquina
postgres@ibmdebian6407:/usr/local/src/postgresql-8.2.3/contrib$ cat /root/tuning_kernel.sh
#echo 1073741824 > /proc/sys/kernel/shmmax
#echo 250 32000 100 128 > /proc/sys/kernel/sem
#echo "2" > /proc/sys/vm/overcommit_memory
#echo 2097152 >/proc/sys/kernel/shmall
echo "deadline" > /sys/block/sda/queue/scheduler
echo "262144" > /proc/sys/net/core/rmem_max
echo "262144" > /proc/sys/net/core/wmem_max
echo "262144" > /proc/sys/net/core/rmem_default
echo "262144" > /proc/sys/net/core/wmem_default
echo "2097152" > /proc/sys/kernel/shmall
echo "2147483648" > /proc/sys/kernel/shmmax
echo "4096" > /proc/sys/kernel/shmmni
echo "512 524288 512 1024" > /proc/sys/kernel/sem
echo "131072" > /proc/sys/fs/file-max
echo "1024 65000" > /proc/sys/net/ipv4/ip_local_port_range
echo "2878" > /proc/sys/kernel/msgmni
echo "8192" > /proc/sys/kernel/msgmax
echo "65535" > /proc/sys/kernel/msgmnb
arquivo postgresql.conf
postgres@ibmdebian6407:/usr/local/src/postgresql-8.2.3/contrib$ grep ^[^#] /usr/local/pgsql/data/postgresql.conf
# (change requires restart)
# (change requires restart)
# (change requires restart)
# (change requires restart)
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
max_connections = 130 # (change requires restart)
# (change requires restart)
# (change requires restart)
# (change requires restart)
# 0 selects the system default
# 0 selects the system default
# 0 selects the system default
shared_buffers = 1500MB # min 128kB or max_connections*16kB
# (change requires restart)
temp_buffers = 16MB # min 800kB
max_prepared_transactions = 15 # can be 0 or more
# (change requires restart)
work_mem = 16MB # min 64kB
maintenance_work_mem = 64MB # min 1MB
max_fsm_pages = 600600 # min max_fsm_relations*16, 6 bytes each
# (change requires restart)
# (change requires restart)
# (change requires restart)
vacuum_cost_delay = 1000 # 0-1000 milliseconds
vacuum_cost_page_hit = 6 # 0-10000 credits
vacuum_cost_page_miss = 10 # 0-10000 credits
vacuum_cost_page_dirty = 20 # 0-10000 credits
vacuum_cost_limit = 100 # 0-10000 credits
# supported by the operating system:
# open_datasync
# fdatasync
# fsync
# fsync_writethrough
# open_sync
# (change requires restart)
commit_delay = 1000 # range 0-100000, in microseconds
checkpoint_segments = 12 # in logfile segments, min 1, 16MB each
checkpoint_timeout = 10min # range 30s-1h
# many seconds; 0 is off
# JOINs
# stderr, syslog and eventlog,
# depending on platform.
# files
# (change requires restart)
# Can be absolute or relative to PGDATA
# Can include strftime() escapes
# name as the new log file will be
# truncated rather than appended to. But
# such truncation only occurs on
# time-driven rotation, not on restarts
# or size-driven rotation. Default is
# off, meaning append to existing files
# in all cases.
# happen after that time. 0 to
# disable.
# happen after that much log
# output. 0 to disable.
# debug5
# debug4
# debug3
# debug2
# debug1
# log
# notice
# warning
# error
# debug5
# debug4
# debug3
# debug2
# debug1
# info
# notice
# warning
# error
# log
# fatal
# panic
# debug5
# debug4
# debug3
# debug2
# debug1
# info
# notice
# warning
# error
# fatal
# panic (effectively off)
# and their durations.
# redirect_stderr
# (change requires restart)
# %u = user name
# %d = database name
# %r = remote host and port
# %h = remote host
# %p = PID
# %t = timestamp (no milliseconds)
# %m = timestamp with milliseconds
# %i = command tag
# %c = session id
# %l = session line number
# %s = session start timestamp
# %x = transaction id
# %q = stop here in non-session
# processes
# %% = '%'
# e.g. '<%u%%%d> '
log_statement = 'all' # none, ddl, mod, all
stats_command_string = on
update_process_title = on
stats_start_collector = on # needed for block or row stats
# (change requires restart)
stats_block_level = on
stats_row_level = on
# 'on' requires stats_start_collector
# and stats_row_level to also be on
# vacuum
# analyze
# vacuum
# analyze
# (change requires restart)
# autovacuum, -1 means use
# vacuum_cost_delay
# autovacuum, -1 means use
# vacuum_cost_limit
# the default
datestyle = 'iso, dmy'
# environment setting
# abbreviations. Currently, there are
# Default
# Australia
# India
# However you can also create your own
# file in share/timezonesets/.
# encoding
lc_messages = 'pt_BR.UTF-8' # locale for system error message
# strings
lc_monetary = 'pt_BR.UTF-8' # locale for monetary formatting
lc_numeric = 'pt_BR.UTF-8' # locale for number for
Escrever sobre os testes com pgpool-2
blocok10:~# pgbench -c 100 -t 100 -n -h 192.168.10.8 -p 9999 -U postgres bench_pgpool
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 53.333346 (including connections establishing)
tps = 54.520023 (excluding connections establishing)
blocok10:~# pgbench -c 100 -t 100 -n -h 192.168.10.8 -p 9999 -U postgres bench_pgpool
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 54.416162 (including connections establishing)
tps = 55.627518 (excluding connections establishing)
blocok10:~# pgbench -c 100 -t 100 -n -h 192.168.10.9 -U postgres bench_pgpool
Connection to database 'bench_pgpool' failed.
postgres@ibmdebian6407:~$ pgbench -n -S -c 100 -t 100 -h 127.0.0.1 -U postgres bench
transaction type: SELECT only
scaling factor: 100
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 7721.071654 (including connections establishing)
tps = 9875.714138 (excluding connections establishing)
