<p dir="ltr"><br /> On 22/03/2016 5:24 pm, "Pavel Stehule" <<a
href="mailto:pavel.stehule@gmail.com">pavel.stehule@gmail.com</a>>wrote:<br /> ><br /> > Hi<br /> ><br />
>is it expected in this moment?<br /> ><br /> ><br /> > Table "public.foo"<br /> > Column │
Type │ Modifiers <br /> > ════════╪═════════╪═══════════<br /> > a │ integer │ <br /> ><br /> >
postgres=#\d foo2<br /> > Table "public.foo2"<br /> > Column │ Type │ Modifiers <br /> >
════════╪═════════╪═══════════<br/> > a │ numeric │ <br /> ><br /> > postgres=# explain select sum(a)
fromfoo;<br /> > QUERY PLAN <br /> >
════════════════════════════════════════════════════════════════════════════════════════<br/> > Finalize Aggregate
(cost=76498.35..76498.36rows=1 width=8)<br /> > -> Gather (cost=76497.93..76498.34 rows=4 width=8)<br />
> Number of Workers: 4<br /> > -> Partial Aggregate (cost=75497.93..75497.94 rows=1
width=8)<br/> > -> Parallel Seq Scan on foo (cost=0.00..69247.94 rows=2499994 width=4)<br />
>(5 rows)<br /> ><br /> > postgres=# explain select sum(a) from foo2;<br /> >
QUERYPLAN <br /> >
══════════════════════════════════════════════════════════════════════<br/> > Aggregate (cost=179053.25..179053.26
rows=1width=32)<br /> > -> Seq Scan on foo2 (cost=0.00..154053.60 rows=9999860 width=12)<br /> > (2
rows)<pdir="ltr">Yes. There's still a few outstanding patches to add support to serialize internal states. See the
combineaggregates thread.<br />