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: (view raw, whole thread or download thread mbox)
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

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


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-2017 The PostgreSQL Global Development Group