Re: Replication Syatem
От
Peter Childs
Тема
Re: Replication Syatem
Дата
Msg-id
a2de01dd0804280658t68ac22dsf182d304a94de5a2@mail.gmail.com
Ответ на
Replication Syatem (Gauri Kanekar)
Список
Дерево обсуждения
Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem "Peter Childs" <peterachilds@gmail.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem Brad Nicholson <bnichols@ca.afilias.info>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem Andrew Sullivan <ajs@commandprompt.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Replication Syatem Shane Ambler <pgsql@Sheeky.Biz>
Re: Replication Syatem Greg Smith <gsmith@gregsmith.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem Alvaro Herrera <alvherre@commandprompt.com>
Re: Replication Syatem Shane Ambler <pgsql@Sheeky.Biz>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Replication Syatem "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: Replication Syatem Craig Ringer <craig@postnewspapers.com.au>
Re: Replication Syatem "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: Replication Syatem "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem Alvaro Herrera <alvherre@commandprompt.com>
Re: Replication Syatem "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Replication Syatem Gregory Stark <stark@enterprisedb.com>
Re: Replication Syatem Tom Lane <tgl@sss.pgh.pa.us>
Re: Replication Syatem Vivek Khera <vivek@khera.org>
Re: Replication Syatem salman <salmanb@quietcaresystems.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem Andrew Sullivan <ajs@commandprompt.com>
Re: Replication Syatem Greg Smith <gsmith@gregsmith.com>
Re: Replication Syatem "Radhika S" <radhika.sambamurti@gmail.com>
2008/4/28 Gauri Kanekar <meetgaurikanekar@gmail.com>:
All,
We have a table "table1" which get insert and updates daily in high numbers, bcoz of which its size is increasing and we have to vacuum it every alternate day. Vacuuming "table1" take almost 30min and during that time the site is down.
We need to cut down on this downtime.So thought of having a replication system, for which the replicated DB will be up during the master is getting vacuumed.
Can anybody guide which will be the best suited replication solution for this.
Thanx for any help
~ Gauri
I home your not using Vacuum Full....... (Standard Reply for this type of question)
What version of Postgresql are you using?
Have you tried autovacuum?
Run plain vacuum even more often on this even more often (like ever half hour) and it should not take as long and save space.
If still have trouble run "vacuum analyse verbose table1;" and see what it says.
If your doing it right you should be able to vacuum with the database up.
Sounds like you might be happier a fix for the problem rather than a complex work around which will actually solve a completely different problem.
Regards
Peter.
В списке pgsql-performance по дате отправления
