Re: VACUM database

From: "Steve Wolfe" <steve(at)iboats(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: VACUM database
Date: 2001-01-04 22:21:55
Message-ID: 003501c0769c$ce191560$50824e40@iboats.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I wan't to know how often do i have to do this. If i do a lot of
> inserts, my SELECTS are very slow, but if I Vacum the table it's
> better. do i have to vacum every insert?

Not after every insert, but it should at least be done nightly and
after a large batch of inserts. And make sure that you do 'vacuum analyze',
or alternatively, from the nightly postgres super-user cron,
'vacuumdb --all --analyze'.

steve

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2001-01-04 22:22:00 Re: \connect
Previous Message Uro Gruber 2001-01-04 22:20:28 VACUM database