O servidor ganhou um folego, gostaria de alguma critica sobre as alterações, o servidor passou a usar swap(15MB), mas está respondendo melhor, vou providenciar outro raid e mais memoria Ram.
shared_buffers = 2400MB #entre 20-33% da ram work_mem = 35MB #agregacao, ordenacao, consultas complexas maintenance_work_mem = 512MB #75% maior tabela ou indice max_fsm_pages = 245760 max_fsm_relations = 2100 wal_buffers = 16MB effective_cache_size = 5632MB Em 26 de maio de 2010 14:56, Ralf Schlindwein <ralfoa...@gmail.com>escreveu: > Aconselho em ler melhor sobre esses itens abaixo e talvez aumentar os > valores para tentar melhorar... > > shared_buffers = 2048MB > work_mem = 26MB > maintenance_work_mem = 480MB > max_fsm_pages = 245760 > max_fsm_relations = 2100 > > http://www.postgresql.org/docs/8.1/interactive/runtime-config-resource.html > > Sobre a performace isso varia muito do tamanho da base, de quantas pessoas > acessam a base e como seu banco de dados está estruturado são fatores que > com certeza iram influenciar na performace do seu servidor. > > > > > > > Em 26 de maio de 2010 14:48, José Carlos Messias > <zehkar...@gmail.com>escreveu: > > data_directory = '/var/lib/postgresql/8.3/main' >> hba_file = '/etc/postgresql/8.3/main/pg_hba.conf' >> ident_file = '/etc/postgresql/8.3/main/pg_ident.conf' >> external_pid_file = '/var/run/postgresql/8.3-main.pid' >> listen_addresses = '*' >> port = 5432 >> unix_socket_directory = '/var/run/postgresql' >> ssl = false >> >> checkpoint_segments = 16 >> checkpoint_completion_target = 0.9 >> wal_buffers = 8MB >> effective_cache_size = 5632MB >> >> max_connections = 350 >> shared_buffers = 2048MB >> work_mem = 26MB >> maintenance_work_mem = 480MB >> max_fsm_pages = 245760 >> max_fsm_relations = 2100 >> >> datestyle = 'iso, dmy' >> >> lc_messages = 'pt_BR.UTF-8' >> lc_monetary = 'pt_BR.UTF-8' >> lc_numeric = 'pt_BR.UTF-8' >> lc_time = 'pt_BR.UTF-8' >> default_text_search_config = 'pg_catalog.portuguese' >> >> log_autovacuum_min_duration = -1 >> >> synchronous_commit = on >> default_statistics_target = 100 >> constraint_exclusion = off >> >> log_destination = 'stderr' >> logging_collector = off >> log_rotation_size = 1GB >> log_connections = off >> log_line_prefix = '%m %p %u %d %r ' >> log_lock_waits = on >> log_statement = 'none' >> log_temp_files = 4096 >> >> autovacuum = on >> autovacuum_max_workers = 1 >> >> deadlock_timeout = 1s >> >> archive_mode = on >> archive_command = 'rsync -q "%p" slave:/psql_archive/%f' >> >> >> Em 26 de maio de 2010 14:43, Ralf Schlindwein <ralfoa...@gmail.com>escreveu: >> >> Os arquivos de configuracao do postgres estao configurados para ter aonde >>> locada a base de dados dentro do /var ?? >>> >>> >>> Em 26 de maio de 2010 14:41, José Carlos Messias >>> <zehkar...@gmail.com>escreveu: >>> >>> df -h >>>> Filesystem Size Used Avail Use% Mounted on >>>> /dev/sda1 28G 437M 27G 2% / >>>> varrun 4,0G 92K 4,0G 1% /var/run >>>> varlock 4,0G 0 4,0G 0% /var/lock >>>> udev 4,0G 44K 4,0G 1% /dev >>>> devshm 4,0G 0 4,0G 0% /dev/shm >>>> /dev/sda5 94G 85G 8,9G 91% /home >>>> /dev/sda7 13G 33M 13G 1% /tmp >>>> /dev/sda8 131G 35G 96G 27% /var >>>> >>>> >>>> Em 26 de maio de 2010 14:40, Ralf Schlindwein >>>> <ralfoa...@gmail.com>escreveu: >>>> >>>> Execute o comando *df -h * >>>>> * >>>>> * >>>>> para ver a quanto anda suas partições ... >>>>> Algum processo sem ser o postmaster ? >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Em 26 de maio de 2010 14:36, Joao Cosme de Oliveira Junior < >>>>> joao.co...@serpro.gov.br> escreveu: >>>>> >>>>> Já viu se são picos?? >>>>>> Observou os logs sobre os tempos dos checkpoints? >>>>>> >>>>>> João Cosme de Oliveira Júnior >>>>>> >>>>>> >>>>>> >>>>>> "Lembre-se que da conduta de cada um depende o destino de todos." >>>>>> >>>>>> Seja inteligente, use Software livre!!! >>>>>> LPI Certified >>>>>> LPI000185554 >>>>>> >>>>>> >>>>>> Em 26/05/2010 às 14:32 horas, >>>>>> pgbr-ge...@listas.postgresql.org.brescreveu: >>>>>> >>>>>> Galera, >>>>>> >>>>>> Estou precisando da ajuda de vocês, o servidor(Power Edge 2900 - 2 cpu >>>>>> xeon quad core, 8GB de Ram, 4 discos SAS em Raid 10) com postgresql >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> 8.3 no ubuntu 8.04 as vezes fica com processamento alto (htop) e o >>>>>> >>>>>> acesso ao disco parece que está muito alto também, vejam: >>>>>> >>>>>> sar -d 2 40 >>>>>> Linux 2.6.24-19-server (pgbox) 26-05-2010 >>>>>> >>>>>> 14:25:33 DEV tps rd_sec/s wr_sec/s avgrq-sz >>>>>> avgqu-sz await svctm %util >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> 14:25:35 dev8-0 789,77 226474,42 141,40 286,94 >>>>>> 1,55 1,96 1,14 89,77 >>>>>> >>>>>> 14:25:35 DEV tps rd_sec/s wr_sec/s avgrq-sz >>>>>> avgqu-sz await svctm %util >>>>>> 14:25:37 dev8-0 692,34 202706,22 2162,68 295,91 >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> 1,47 2,14 1,33 91,87 >>>>>> >>>>>> 14:25:37 DEV tps rd_sec/s wr_sec/s avgrq-sz >>>>>> avgqu-sz await svctm %util >>>>>> 14:25:39 dev8-0 1959,09 40763,64 170,91 20,89 >>>>>> 12,60 6,42 0,46 90,91 >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> 14:25:39 DEV tps rd_sec/s wr_sec/s avgrq-sz >>>>>> avgqu-sz await svctm %util >>>>>> 14:25:41 dev8-0 1492,24 66896,80 2827,40 46,72 >>>>>> 8,87 5,96 0,60 89,95 >>>>>> >>>>>> 14:25:41 DEV tps rd_sec/s wr_sec/s avgrq-sz >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> avgqu-sz await svctm %util >>>>>> 14:25:43 dev8-0 435,19 110066,67 44,44 253,02 >>>>>> 2,14 4,93 2,13 92,59 >>>>>> >>>>>> Quais medidas vocês indicam para melhorar a performance. >>>>>> >>>>>> Atte, >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> José Carlos >>>>>> _______________________________________________ >>>>>> pgbr-geral mailing list >>>>>> pgbr-geral@listas.postgresql.org.br >>>>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>>>> >>>>>> >>>>>> >>>>>> "Esta mensagem do SERVIÇO FEDERAL DE PROCESSAMENTO DE DADOS (SERPRO), >>>>>> empresa pública federal regida pelo disposto na Lei Federal nº 5.615, é >>>>>> enviada exclusivamente a seu destinatário e pode conter informações >>>>>> confidenciais, protegidas por sigilo profissional. Sua utilização >>>>>> desautorizada é ilegal e sujeita o infrator às penas da lei. Se você a >>>>>> recebeu indevidamente, queira, por gentileza, reenviá-la ao emitente, >>>>>> esclarecendo o equívoco." >>>>>> >>>>>> "This message from SERVIÇO FEDERAL DE PROCESSAMENTO DE DADOS (SERPRO) -- >>>>>> a government company established under Brazilian law (5.615/70) -- is >>>>>> directed exclusively to its addressee and may contain confidential data, >>>>>> protected under professional secrecy rules. Its unauthorized use is >>>>>> illegal and may subject the transgressor to the law's penalties. If >>>>>> you're not the addressee, please send it back, elucidating the failure." >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> pgbr-geral mailing list >>>>>> pgbr-geral@listas.postgresql.org.br >>>>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Ralf Schlindwein >>>>> Analista de Sistemas >>>>> ralfoa...@gmail.com >>>>> >>>>> _______________________________________________ >>>>> pgbr-geral mailing list >>>>> pgbr-geral@listas.postgresql.org.br >>>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> pgbr-geral mailing list >>>> pgbr-geral@listas.postgresql.org.br >>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>> >>>> >>> >>> >>> -- >>> Ralf Schlindwein >>> Analista de Sistemas >>> ralfoa...@gmail.com >>> >>> _______________________________________________ >>> pgbr-geral mailing list >>> pgbr-geral@listas.postgresql.org.br >>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>> >>> >> >> _______________________________________________ >> pgbr-geral mailing list >> pgbr-geral@listas.postgresql.org.br >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > > -- > Ralf Schlindwein > Analista de Sistemas > ralfoa...@gmail.com > > _______________________________________________ > pgbr-geral mailing list > pgbr-geral@listas.postgresql.org.br > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > >
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral