Boa tarde,
Pessoal Vocês poderiam me ajudar a diagnosticar/Reduzir os arquivos temp do meru serrvidor. Linux debian Postgresql 9.2 Servidor processor : 2 vendor_id : GenuineIntel cpu family : 6 model : 45 model name : Intel(R) Xeon(R) CPU E5-2407 0 @ 2.20GHz stepping : 7 microcode : 0x70d cpu MHz : 1200.000 cache size : 10240 KB physical id : 0 siblings : 4 core id : 1 cpu cores : 4 apicid : 2 initial apicid : 2 fpu : yes fpu_exception : yes cpuid level : 13 wp : yes 1K-blocos Usad Dispon. Uso% Montado em rootfs 460736568 50749188 386583248 12% / udev 10240 0 10240 0% /dev tmpfs 3297068 240 3296828 1% /run /dev/disk/by-uuid/2c649bc2-5a67-45f0-93d6-6656a7143273 460736568 50749188 386583248 12% / tmpfs 5120 0 5120 0% /run/lock tmpfs 10546960 0 10546960 0% /run/shm Postgresql.conf shared_buffers = 8192MB temp_buffers = 16MB work_mem = 500MB maintenance_work_mem = 2GB effective_cache_size = 16GB Arquivos temp: Temporary files=69 Size temporary files=35gb
<<attachment: cgcesarsoares.vcf>>
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
