From: | "Cassiano, Marco" <mcassiano(at)manord(dot)com> |
---|---|
To: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | R: Out of memory... |
Date: | 2012-02-20 16:18:36 |
Message-ID: | BC53C974C3B9E542BC0A9BD4C5B1168A08BBCA28@NEWMAIL.manord.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)Grittner(at)wicourts(dot)gov]
Inviato: ven 17/02/2012 22.00
A: Cassiano, Marco; pgsql-admin(at)postgresql(dot)org
Oggetto: Re: [ADMIN] Out of memory...
"Cassiano, Marco" <mcassiano(at)manord(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2012-02-20 17:09:56 | Re: R: Out of memory... |
Previous Message | Rick Dicaire | 2012-02-20 15:38:46 | sql query variables not expanded in log file |