Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > Replication Sya...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 48 Topic 4027 of 4159
Post > Topic >>

Replication Syatem

by meetgaurikanekar@[EMAIL PROTECTED] ("Gauri Kanekar") Apr 28, 2008 at 07:08 PM

------=_Part_5233_25137124.1209389936476
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_5233_25137124.1209389936476
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

All,<br><br>We have a table &quot;table1&quot; 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 &quot;table1&quot; take
almost 30min and during that time the site is down.<br>
<br>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.<br clear="all"><br>Can anybody guide which
will be the best suited replication solution for this.<br>
<br>Thanx for any help<br>~ Gauri<br>

------=_Part_5233_25137124.1209389936476--
 




 48 Posts in Topic:
Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-28 19:08:56 
Re: Replication Syatem
peterachilds@[EMAIL PROTE  2008-04-28 14:58:14 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-28 19:35:37 
Re: Replication Syatem
salmanb@[EMAIL PROTECTED]  2008-04-28 10:16:44 
Re: Replication Syatem
ajs@[EMAIL PROTECTED] (A  2008-04-28 12:22:43 
Re: Replication Syatem
bnichols@[EMAIL PROTECTED  2008-04-28 10:13:20 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-28 19:47:22 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-28 19:48:48 
Re: Replication Syatem
ajs@[EMAIL PROTECTED] (A  2008-04-28 12:23:45 
Re: Replication Syatem
gsmith@[EMAIL PROTECTED]   2008-04-28 13:39:39 
Re: Replication Syatem
radhika.sambamurti@[EMAIL  2008-04-28 16:58:59 
Re: Replication Syatem
Chris Browne <cbbrowne  2008-04-28 17:43:57 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 10:25:10 
Re: Replication Syatem
tgl@[EMAIL PROTECTED] (T  2008-04-29 01:20:04 
Re: Replication Syatem
Chris Browne <cbbrowne  2008-04-29 10:48:28 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 10:41:33 
Re: Replication Syatem
gsmith@[EMAIL PROTECTED]   2008-04-29 01:08:09 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 11:16:57 
Re: Replication Syatem
pgsql@[EMAIL PROTECTED]   2008-04-29 20:49:38 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 11:17:05 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 11:25:27 
Re: Replication Syatem
gsmith@[EMAIL PROTECTED]   2008-04-29 04:37:07 
Re: Replication Syatem
tgl@[EMAIL PROTECTED] (T  2008-04-29 10:16:02 
Re: Replication Syatem
vivek@[EMAIL PROTECTED]   2008-04-29 11:00:57 
Re: Replication Syatem
tgl@[EMAIL PROTECTED] (T  2008-04-30 11:02:39 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 16:35:40 
Re: Replication Syatem
alvherre@[EMAIL PROTECTED  2008-04-29 09:02:04 
Re: Replication Syatem
pgsql@[EMAIL PROTECTED]   2008-04-30 02:18:10 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 16:55:38 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 18:29:43 
Re: Replication Syatem
alvherre@[EMAIL PROTECTED  2008-04-29 09:03:14 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 18:39:39 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-29 18:42:40 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-29 18:46:00 
Re: Replication Syatem
stark@[EMAIL PROTECTED]   2008-04-29 09:48:31 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-30 10:59:53 
Re: Replication Syatem
heikki@[EMAIL PROTECTED]   2008-04-30 11:26:18 
Re: Replication Syatem
craig@[EMAIL PROTECTED]   2008-04-30 20:16:21 
Re: Replication Syatem
heikki@[EMAIL PROTECTED]   2008-04-30 14:35:29 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 11:07:35 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-30 11:09:56 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 12:13:11 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-30 12:19:04 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 12:55:30 
Re: Replication Syatem
tgl@[EMAIL PROTECTED] (T  2008-04-30 10:46:28 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 19:06:12 
Re: Replication Syatem
pavan.deolasee@[EMAIL PRO  2008-04-30 21:45:05 
Re: Replication Syatem
meetgaurikanekar@[EMAIL P  2008-04-30 22:17:46 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Wed Jul 9 0:10:24 CDT 2008.