Postgres Pro
Downloads
Home   >   mailing lists

parallel aggregation - Numeric is unsupported? - Mailing list pgsql-hackers

From Pavel Stehule
Subject parallel aggregation - Numeric is unsupported?
Date
Msg-id CAFj8pRBG-fFfCPvSg7wSiJcufgDHCxN7TUNoOc++Ra9f4ZVVJg@mail.gmail.com
Whole thread Raw
Responses Re: parallel aggregation - Numeric is unsupported?
Re: parallel aggregation - Numeric is unsupported?
List pgsql-hackers
Tree view
Hi

is it expected in this moment?


      Table "public.foo"
 Column │  Type   │ Modifiers
════════╪═════════╪═══════════
 a      │ integer │

postgres=# \d foo2
     Table "public.foo2"
 Column │  Type   │ Modifiers
════════╪═════════╪═══════════
 a      │ numeric │

postgres=# explain select sum(a) from foo;
                                       QUERY PLAN                                      
════════════════════════════════════════════════════════════════════════════════════════
 Finalize Aggregate  (cost=76498.35..76498.36 rows=1 width=8)
   ->  Gather  (cost=76497.93..76498.34 rows=4 width=8)
         Number of Workers: 4
         ->  Partial Aggregate  (cost=75497.93..75497.94 rows=1 width=8)
               ->  Parallel Seq Scan on foo  (cost=0.00..69247.94 rows=2499994 width=4)
(5 rows)

postgres=# explain select sum(a) from foo2;
                              QUERY PLAN                             
══════════════════════════════════════════════════════════════════════
 Aggregate  (cost=179053.25..179053.26 rows=1 width=32)
   ->  Seq Scan on foo2  (cost=0.00..154053.60 rows=9999860 width=12)
(2 rows)

Regards

Pavel

p.s. It great step forward - it looks pretty well

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: OOM in libpq and infinite loop with getCopyStart()
Next
From: Dilip Kumar
Date:
Subject: Re: Move PinBuffer and UnpinBuffer to atomics