Re: PgCon: who will be there? - Mailing list pgsql-cluster-hackers

From Koichi Suzuki
Subject Re: PgCon: who will be there?
Date
Msg-id ef4f49ae1002120521g466b9a92i3467a47fe9d3beec@mail.gmail.com
Whole thread Raw
In response to Re: PgCon: who will be there?  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: PgCon: who will be there?  (Markus Wanner <markus@bluegap.ch>)
List pgsql-cluster-hackers
Hi,
----------
Koichi Suzuki



2010/2/12 Fujii Masao <masao.fujii@gmail.com>:
> On Fri, Feb 12, 2010 at 8:41 PM, Markus Wanner <markus@bluegap.ch> wrote:
>> Glad to hear that. I'm currently thinking about possible implementations,
>> but I doubt somewhat that I'll have the time to do the actual
>> implementation :-(
>
> Probably me too ;)
>
>>> And it has already begun being discussed on -hackers.
>>> http://archives.postgresql.org/pgsql-hackers/2010-01/msg00916.php
>>
>> Hm.. did you notice my review and comments on *this* mailing list [1]?  I
>> don't think that approach works for anything we need for clustering. It's
>> designed for parallel pg_dump.
>
> Umm.. do you think that the "Export snapshots to other sessions" feature is
> completely independent of the snapshot management for the parallel pg_dump?
> If not, we should make the patch more extensible for the feature we want?

I don't think so.   But in the cluster, from my experience of PG-2, it
is essential to manage snapshot consistent among all the node involved
and we should be very careful to make other local tasks, for example,
autovacuum and analyze, not disturb other transactions because they
can become global long transactions very easily.

They don't happen in parallel pg_restore, parallel pg_dump or other
local parallelisms.

So I think their patch may be useful in cluster environment too.

>
> Regards,
>
> --
> Fujii Masao
> NIPPON TELEGRAPH AND TELEPHONE CORPORATION
> NTT Open Source Software Center
>
> --
> Sent via pgsql-cluster-hackers mailing list (pgsql-cluster-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-cluster-hackers
>

pgsql-cluster-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: PgCon: who will be there?
Next
From: Markus Wanner
Date:
Subject: Re: PgCon: who will be there?