Re: VACUM database - Mailing list pgsql-general

From Steve Wolfe
Subject Re: VACUM database
Date
Msg-id 003501c0769c$ce191560$50824e40@iboats.com
Whole thread Raw
In response to VACUM database  (Uro Gruber <uros@sir-mag.com>)
List 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



pgsql-general by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: \connect
Next
From: "Oliver Elphick"
Date:
Subject: Re: Inheritance and Foreign Keys