Re: [Postgres-xc-developers] connection to server was lost

[David E. W. <da...@ju...>]

On Mar 3, 2014, at 10:02 AM, David E. Wheeler <da...@ju...> wrote:

> The query I’m running has EXPLAIN VERBOSE, not EXPLAIN ANALYZE. Is the parser mucking with it somehow? This is 1.1. 

Crap, just realized that I have two query files. I was editing one and running the other. Sheesh, sorry about that.

Even with JOIN clauses added to the query such that it *should* run in whole on each node, the plan still fetches an entire (very large) table from each node. I will keep fiddling with the query to see if I can figure out how to get it to run on the nodes.

> The possibility of corrupted shared memory is distressing; wish the log would say which node exited abnormally.

This is a pretty significant issue, though. The thing really should not run out of memory, and even it it does, it should tell me where.

Thanks,

David