On Mon, Feb 15, 2010 at 3:20 PM, Rose Zhou <rose@xxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
