Re: [HACKERS] Not 7.5, but 8.0 ? - Mailing list pgsql-advocacy

From Joshua D. Drake
Subject Re: [HACKERS] Not 7.5, but 8.0 ?
Date
Msg-id 40BF9FC5.5090509@commandprompt.com
Whole thread Raw
In response to Re: [HACKERS] Not 7.5, but 8.0 ?  (Enrico Weigelt <weigelt@metux.de>)
List pgsql-advocacy
Hello,

This is probably better suited for something not on pgsql-advocacy. I
will respond offlist.

Sincerely,

Joshua D. Drake


Enrico Weigelt wrote:
> * Joshua D. Drake <jd@commandprompt.com> wrote:
>
> <snip>
>
>>There is only one production and shipping replication that does not
>>require triggers that I know of and that is ours (Command Prompt).
>>It is also not a userland app but actually part of the PostgreSQL engine.
>
> Ah. Has pgsql to be patched for that or can it be simply dropped-in
> like external (C) functions/procedures ?
>
> What about lazy replication (i.e. when some node is running but not
> online for a while), masterless replication (all nodes are equal)
> or journaling ?
> My application/framework-level solves this, but
> a) requires some special table layout (first attrs have to be inode+mtime),
> b) not suited for high update-rates (relly too slow for that)
> but it is already working quite stable for several years :)
>
> <snip>
>
>>Each solution has pro's and cons. Slony-I for example appears to be
>>better when doing mass updates or deletes than Replicator.
>
> yeah, on subsequent mass-updates on just one host per table at certain time,
> my stuff is also good, since it works w/ batching. but when multiple hosts
> do heavy updates on the same table, it may run into conflicts.
>
> <snip>
>
>>On the argument of significant features for 7.5:
>>
>>Win32 Native
>>PITR
>
> Stupid question: whats PITR ?
>
>>Nested Transactions
>>Background Writer....
>
> Background-Write = write-behind ?
>
> BTW: how stable is the current pgsql against powerfails or kill -9 ?
>
>
> cu


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment

pgsql-advocacy by date:

Previous
From: Enrico Weigelt
Date:
Subject: Re: [HACKERS] Not 7.5, but 8.0 ?
Next
From: Josh Berkus
Date:
Subject: Re: [SQL] SQL Spec Compliance Questions