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

Slow vacuum performance

From: Patrick Hatcher <PHatcher(at)macys(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Slow vacuum performance
Date: 2004-06-17 20:09:47
Message-ID: OFCFC284F5.4676AEEF-ON88256EB6.006D7820-88256EB6.006F9082@fds.com (view raw or flat)
Thread:
Lists: pgsql-performance



Pg:  7.4.2
RedHat 7.3
Ram: 8gig

I have 6 million row table that I vacuum full analyze each night.  The time
seems to be streching out further and further as I add more rows.  I read
the archives and Josh's annotated pg.conf guide that setting the FSM higher
might help.  Currently, my memory settings are set as such.  Does this seem
low?

Last reading from vaccum verbose:
  INFO:  analyzing "cdm.cdm_ddw_customer"
INFO:  "cdm_ddw_customer": 209106 pages, 3000 rows sampled, 6041742
estimated total rows
>>I think I should now set my max FSM to at least 210000 but wanted to make
sure

shared_buffers = 2000           # min 16, at least max_connections*2, 8KB
each
sort_mem = 12288                # min 64, size in KB

# - Free Space Map -

max_fsm_pages = 100000          # min max_fsm_relations*16, 6 bytes each
#max_fsm_relations = 1000       # min 100, ~50 bytes each


TIA

Patrick Hatcher
Macys.Com


Responses

pgsql-performance by date

Next:From: Dennis BjorklundDate: 2004-06-18 04:30:12
Subject: Re: Slow vacuum performance
Previous:From: Vitaly BelmanDate: 2004-06-17 18:13:41
Subject: Re: Visual Explain

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