Thank you Kevin, here is the result of the query : "version";"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit" "archive_command";"/usr/local/bin/walscript.sh %p %f" "archive_mode";"on" "autovacuum";"on" "autovacuum_max_workers";"7" "autovacuum_naptime";"10min" "autovacuum_vacuum_cost_delay";"20ms" "autovacuum_vacuum_cost_limit";"200" "bytea_output";"escape" "checkpoint_completion_target";"0.8" "checkpoint_segments";"32" "checkpoint_timeout";"10min" "client_encoding";"UNICODE" "client_min_messages";"warning" "debug_pretty_print";"off" "debug_print_parse";"off" "debug_print_plan";"off" "debug_print_rewritten";"off" "default_statistics_target";"200" "effective_cache_size";"5870MB" "fsync";"off" "full_page_writes";"off" "lc_collate";"en_US.LATIN1" "lc_ctype";"en_US.LATIN1" "listen_addresses";"*" "log_autovacuum_min_duration";"1s" "log_checkpoints";"on" "log_connections";"off" "log_destination";"stderr,syslog" "log_directory";"/var/logs" "log_disconnections";"off" "log_duration";"off" "log_error_verbosity";"default" "log_filename";"postgresql-%Y-%m-%d_%H%M%S.log" "log_line_prefix";"%t %r %u %d %x %c - " "log_min_duration_statement";"1min" "log_min_error_statement";"error" "log_min_messages";"error" "log_rotation_age";"1d" "log_rotation_size";"0" "log_statement";"none" "log_truncate_on_rotation";"off" "logging_collector";"on" "maintenance_work_mem";"300MB" "max_connections";"250" "max_stack_depth";"2MB" "max_wal_senders";"5" "port";"5432" "random_page_cost";"2" "server_encoding";"LATIN1" "shared_buffers";"1GB" "silent_mode";"on" "superuser_reserved_connections";"6" "synchronous_commit";"off" "syslog_facility";"local2" "syslog_ident";"postgres" "temp_buffers";"8MB" "TimeZone";"Europe/Rome" "track_activities";"on" "track_counts";"on" "vacuum_cost_delay";"0" "vacuum_cost_limit";"200" "wal_buffers";"16MB" "wal_keep_segments";"10" "wal_level";"hot_standby" "work_mem";"12MB ________________________________ Da: Kevin Grittner [mailto:Kevin.Grittner@xxxxxxxxxxxx] Inviato: ven 17/02/2012 22.00 A: Cassiano, Marco; pgsql-admin@xxxxxxxxxxxxxx Oggetto: Re: Out of memory... "Cassiano, Marco" <mcassiano@xxxxxxxxxx> wrote: > There was an autovaccum running on a big table saying it was "to > avoid xid wraparound" > My configuration is : > > Postgresql 9.1.2 compiled and running on Redhat 5 64 bit > DB Size : about 100 GB > > RAM 5 GB > Shared Buffers 1 GB > temp_buffers = 8MB > work_mem = 12MB > maintenance_work_mem = 300MB Are those the only settings changed from their defaults? If not, or you're not sure, please post the output from running the query on this page: http://wiki.postgresql.org/wiki/Server_Configuration -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
