Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Not 7.5, but 8.0 ?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: weigelt(at)metux(dot)de
Cc: postgresql advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: [HACKERS] Not 7.5, but 8.0 ?
Date: 2004-06-03 22:01:41
Message-ID: 40BF9FC5.5090509@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackers
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(at)commandprompt(dot)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(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment: jd.vcf
Description: text/x-vcard (640 bytes)

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-06-03 22:03:53
Subject: Re: [HACKERS] Configuration patch
Previous:From: Bruce MomjianDate: 2004-06-03 21:45:34
Subject: Re: [HACKERS] Configuration patch

pgsql-advocacy by date

Next:From: Josh BerkusDate: 2004-06-03 23:09:51
Subject: Re: [SQL] SQL Spec Compliance Questions
Previous:From: Enrico WeigeltDate: 2004-06-03 21:35:50
Subject: Re: [HACKERS] Not 7.5, but 8.0 ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group