Re: When do I Vacuum ?
От | Joshua -Poet- Drake |
---|---|
Тема | Re: When do I Vacuum ? |
Дата | |
Msg-id | VutQ7.19939$Yy.292661@rwcrnsc53 обсуждение исходный текст |
Ответ на | When do I Vacuum ? ("Steve Brett" <steve.brett@e-mis.com>) |
Список | pgsql-general |
Hello, I always Vaccuum once a day... period. It just makes management a whole lot easier. J "Steve Brett" <stevebrett@ntlworld.com> wrote in message news:9uh450$29gd$1@news.tht.net... > thanks. > > i'm gonna leave it at onece a day and see how it goes. > > thanks for answering btw , i was beginning to think this was one of those > questions nobody answered ... > > Steve > "Carsten Gerhardt" <carsten.gerhardt@ppi.de> wrote in message > news:3c0bb397$0$188$4d4ebb8e@read.news.de.uu.net... > > Hi Steve, > > > > "Steve Brett" <steve.brett@e-mis.com> wrote > > > hi, > > > > > > I've got a DB driven web application which currently has approx 298 > inserts > > > per day and 540 edits/deletes. > > > > > > This figure will change daily and currently i have a cron job set up to > > > vacuum the database every hour during 'work time': > > > > > > 0 7-19/1,23 * * * /usr/local/pgsql/bin/vacuumdb -z -d edb > > > 30 7-19/4,23 * * * /backup/dumpit > > > > I do the same on my DB. > > > > > I've also started reading Bruce's book (and what a fine book it is ... > :-) > > > and noticed that he suggests vacuuming once a day when the db is quiet. > > > > > > Would this be sufficient ? The database drives a web based > > > calendar/appointment booking/reporting system i've written in php and is > > > used extensively by 3 departments and has approx 200 people log in each > day. > > > > > > Needless to say speed it paramount but I've got a sneaky feeling I might > be > > > vacuuming too often .... > > > > I didn't read the book, but I also read that one vacuum per day would by > > enough. But my DB runs on a P100 with 64MB ram :-( after 20 to 30 > > inserts it seems to slow down, so I vacuum once an houre (at main working > time) > > and now I've less problems 8) > > > > HTH > > Carsten > > > >
В списке pgsql-general по дате отправления: