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

Re: Why memory is not used ? Why vacuum so slow ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hervé Piedvache <herve(at)elma(dot)fr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why memory is not used ? Why vacuum so slow ?
Date: 2004-01-02 14:42:28
Message-ID: 5630.1073054548@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
=?iso-8859-15?q?Herv=E9=20Piedvache?= <herve(at)elma(dot)fr> writes:
> Second point ... after importing my dump ... I make a vacuum full analyze of 
> my base (in same time because of my caculation of the day before for my 
> aggregats and stats tables about 200 000 row deleted and/or inserted for more
> than 20 tables (each)) ... but It takes about 5 hours ...

Don't do vacuum full.  You should not need it in ordinary circumstances,
if you are doing plain vacuums on a reasonable schedule and you have the
FSM parameters set high enough.  (You do not BTW ... with 175000 pages in
this table alone, 10000 FSM pages for the whole database is surely too
low.)

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Hervé PiedvacheDate: 2004-01-02 15:18:28
Subject: Re: Why memory is not used ? Why vacuum so slow ?
Previous:From: Christopher BrowneDate: 2004-01-02 12:33:46
Subject: Tuning Techniques To Avoid?

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