pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedperformance of postgresql in replication using slony
3+ messages / 3 participants
[nested] [flat]
* performance of postgresql in replication using slony
@ 2007-07-26 08:44 angga erwina <by_pacitan@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: angga erwina @ 2007-07-26 08:44 UTC (permalink / raw)
To: pgsql-performance
Hi all,
whats the benefits of replication by using slony in
postgresql??
My office is separate in several difference place..its
about hundreds branch office in the difference
place..so any one can help me to replicate our dbase
by using slony?? and why slony??
thanks,
Algebra.corp
Bayu
____________________________________________________________________________________
Pinpoint customers who are looking for what you sell.
http://searchmarketing.yahoo.com/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: performance of postgresql in replication using slony
@ 2007-07-26 17:21 Jeff Davis <pgsql@j-davis.com>
parent: angga erwina <by_pacitan@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jeff Davis @ 2007-07-26 17:21 UTC (permalink / raw)
To: angga erwina <by_pacitan@yahoo.com>; +Cc: pgsql-performance
On Thu, 2007-07-26 at 01:44 -0700, angga erwina wrote:
> Hi all,
> whats the benefits of replication by using slony in
> postgresql??
> My office is separate in several difference place..its
> about hundreds branch office in the difference
> place..so any one can help me to replicate our dbase
> by using slony?? and why slony??
>
This question should be asked on the slony1-general list, you'll get
more responses there.
The benefit of using slony is that you can read from many servers rather
than just one.
Regards,
Jeff Davis
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: performance of postgresql in replication using slony
@ 2007-07-26 18:28 Chris Browne <cbbrowne@acm.org>
parent: Jeff Davis <pgsql@j-davis.com>
0 siblings, 0 replies; 3+ messages in thread
From: Chris Browne @ 2007-07-26 18:28 UTC (permalink / raw)
To: pgsql-performance
pgsql@j-davis.com (Jeff Davis) writes:
> On Thu, 2007-07-26 at 01:44 -0700, angga erwina wrote:
>> Hi all,
>> whats the benefits of replication by using slony in
>> postgresql??
>> My office is separate in several difference place..its
>> about hundreds branch office in the difference
>> place..so any one can help me to replicate our dbase
>> by using slony?? and why slony??
>>
>
> This question should be asked on the slony1-general list, you'll get
> more responses there.
>
> The benefit of using slony is that you can read from many servers rather
> than just one.
Indeed.
It would be worth taking a peek at the documentation, notably the
introductory material, as that will give some idea as to whether
Slony-I is suitable at all for the desired purpose.
One thing that "tweaks" my antennae a bit is the mention of having
"hundreds branch office"; there are two things worth mentioning that
would be relevant to that:
- Slony-I is a single-master replication system, *not* a multimaster
system. If someone is expecting to do updates at branch offices, and
that this will propagate everywhere, that is likely not to work out
easily or well.
- If it *is* fair to assess that there will only be one "master",
Slony-I is intended to support a relatively limited number of nodes.
There are no absolute restrictions on numbers of subscribers, but
there are enough communications costs that grow in a polynomial
fashion that I would be quite disinclined to have more than a dozen
nodes in a cluster.
--
(reverse (concatenate 'string "ofni.sesabatadxunil" "@" "enworbbc"))
http://www3.sympatico.ca/cbbrowne/slony.html
HELP! I'm being attacked by a tenured professor!
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-07-26 18:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-26 08:44 performance of postgresql in replication using slony angga erwina <by_pacitan@yahoo.com>
2007-07-26 17:21 ` Jeff Davis <pgsql@j-davis.com>
2007-07-26 18:28 ` Chris Browne <cbbrowne@acm.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox