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

Re: Auto Vacuum out of memory

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Rose Zhou <rose(at)anatec(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Auto Vacuum out of memory
Date: 2010-02-21 18:44:26
Message-ID: 603c8f071002211044l742c68c0v37631c594b6b915@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, Feb 15, 2010 at 3:20 PM, Rose Zhou <rose(at)anatec(dot)com> wrote:
> We bought a new WinXP x64 Professional, it has 12GB memory.
>
> I installed postgresql-8.4.1-1-windows version on this PC, also installed
> another .Net application which reads in data from a TCP port and
> insert/update the database, the data volume is large, with heavy writing and
> updating on a partitioned table.
>
> I configured the PostgreSQL as below:
>
> Shared_buffers=1024MB
> effective_cache_size=5120MB
> work_mem=32MB
> maintenance_work_men=200MB
>
> But I got the Auto Vacuum out-of-memory error. The detailed configuration is
> as follows, can anyone suggest what is the best configuration from the
> performance perspective?

Please see http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

You haven't provided very much detail here - for example, the error
message that you got is conspicuously absent.

...Robert

In response to

pgsql-performance by date

Next:From: Greg SmithDate: 2010-02-22 05:39:06
Subject: Re: SSD + RAID
Previous:From: Ron MayerDate: 2010-02-21 14:54:24
Subject: Re: SSD + RAID

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