Re: [GENERAL] Sequential parallel scan / agg

2016-11-14 Thread Tobias Bussmann
Hi, On 2016-11-13 23:04:44 +, James Sewell said: > 1. INSERT ... SELECT doesn't work > 2. WITH a AS (SELECT ...) INSERT FROM a doesn't work > 3. SELECT .. INTO doesn't work > 4. SELECT with no insert does work as expected >> >> CREATE TABLE blah AS

Re: [GENERAL] Sequential parallel scan / agg

2016-11-13 Thread James Sewell
AT&T 4G LTE smartphone >> >> ---- Original message >> From: James Sewell >> Date: 11/13/16 18:04 (GMT-05:00) >> To: pgsql-general >> Subject: [GENERAL] Sequential parallel scan / agg >> >> Hi all, >> >> I have a customer w

Re: [GENERAL] Sequential parallel scan / agg

2016-11-13 Thread James Sewell
11/13/16 18:04 (GMT-05:00) > To: pgsql-general > Subject: [GENERAL] Sequential parallel scan / agg > > Hi all, > > I have a customer who is making use of the new parallel features on a 64 > core box - this is working really well for them. However one issue (which > I've sin

Re: [GENERAL] Sequential parallel scan / agg

2016-11-13 Thread melvin6925
Have you tried:CREATE TABLE blah AS SELECT ...  ? Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone Original message From: James Sewell Date: 11/13/16 18:04 (GMT-05:00) To: pgsql-general Subject: [GENERAL] Sequential parallel scan / agg Hi all, I ha

[GENERAL] Sequential parallel scan / agg

2016-11-13 Thread James Sewell
Hi all, I have a customer who is making use of the new parallel features on a 64 core box - this is working really well for them. However one issue (which I've since realised I've never seen an example of) is getting the data from these queries into a table. I can't seem to create a plan which do