Re: WIP patch for parallel pg_dump - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: WIP patch for parallel pg_dump
Date
Msg-id 4CFCF710.8040306@enterprisedb.com
Whole thread Raw
In response to Re: WIP patch for parallel pg_dump  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: WIP patch for parallel pg_dump  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 06.12.2010 14:57, Robert Haas wrote:
> On Mon, Dec 6, 2010 at 2:29 AM, Heikki Linnakangas
> <heikki.linnakangas@enterprisedb.com>  wrote:
>> The client doesn't need to know anything about the snapshot blob that the
>> server gives it. It just needs to pass it back to the server through the
>> other connection. To the client, it's just an opaque chunk of bytes.
>
> I suppose that would work, but I still think it's a bad idea.  We made
> this mistake with expression trees.  Any oversight in the code that
> validates the chunk of bytes when it (or a modified version) is sent
> back to the server turns into a security hole.

True, but a snapshot is a lot simpler than an expression tree. It's 
pretty much impossible to plug all the holes in the expression-tree 
reading functions, and keep them hole-free in the future. The expression 
tree format is constantly in flux. A snapshot, however, is a fairly 
isolated small data structure that rarely changes.

>  I think it's a whole
> lot simpler and cleaner to keep the representation details private to
> the server.

Well, then you need some sort of cross-backend communication, which is 
always a bit clumsy.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Suggesting a libpq addition
Next
From: Oleg Bartunov
Date:
Subject: Re: knngist - 0.8