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 <[email protected]>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 <[email protected]>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 >> <[email protected]>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 <[email protected]>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 < >>>> [email protected]> 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, [email protected]: >>>>> >>>>> 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 >>>>> [email protected] >>>>> 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 >>>>> [email protected] >>>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>>> >>>>> >>>> >>>> >>>> -- >>>> Ralf Schlindwein >>>> Analista de Sistemas >>>> [email protected] >>>> >>>> _______________________________________________ >>>> pgbr-geral mailing list >>>> [email protected] >>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>> >>>> >>> >>> _______________________________________________ >>> pgbr-geral mailing list >>> [email protected] >>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>> >>> >> >> >> -- >> Ralf Schlindwein >> Analista de Sistemas >> [email protected] >> >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- Ralf Schlindwein Analista de Sistemas [email protected]
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
