| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Geoffrey <lists(at)serioustechnology(dot)com> |
| Cc: | Alan Hodgson <ahodgson(at)simkin(dot)ca>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: In the belly of the beast (MySQLCon) |
| Date: | 2008-04-18 18:15:09 |
| Message-ID: | 20080418111509.1189547a@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-general |
On Fri, 18 Apr 2008 13:54:52 -0400
Geoffrey <lists(at)serioustechnology(dot)com> wrote:
> What about the:
>
> 8.1 -> slony -> 8.3
> switch users to 8.3 databases
>
> solution.
Is it? What is your transactional velocity? How long will the initial
sync transaction have to run? You know vacuum isn't working while
that transaction is open right? Are you going to have to setup up a
dozen different replicated sets in order to get it done?
Slony works in "some" cases it does not work in all nor the most
critical (in terms of large sets with minimal downtime requirement).
Sincerely,
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2008-04-18 18:16:28 | Re: Joshua Drake's "What MySQL Can Learn From PostgreSQL" talk at MySQL Con 2008 |
| Previous Message | Joshua D. Drake | 2008-04-18 18:13:19 | Re: Joshua Drake's "What MySQL Can Learn From PostgreSQL" talk at MySQL Con 2008 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2008-04-18 18:27:27 | Re: Upgrade 8.3 |
| Previous Message | E.J. Moloney | 2008-04-18 18:10:48 | Upgrade 8.3 |