Skip site navigation (1) Skip section navigation (2)

R: Out of memory...

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 (view raw or flat)
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



In response to

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-02-20 17:09:56
Subject: Re: R: Out of memory...
Previous:From: Rick DicaireDate: 2012-02-20 15:38:46
Subject: sql query variables not expanded in log file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group