Re: Auto Vacuum out of memory

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