| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | weiboyiyou(at)163(dot)com |
| Subject: | BUG #15093: hash partition exector plan is error!!!! |
| Date: | 2018-02-27 08:38:52 |
| Message-ID: | 151972073247.21251.16067714732326421096@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15093
Logged by: jiang fei
Email address: weiboyiyou(at)163(dot)com
PostgreSQL version: Unsupported/Unknown
Operating system: CentOS release 6.8
Description:
I create a table like this:
test=# \d+ orders
Table "public.orders"
Column | Type | Collation | Nullable | Default | Storage | Stats
target | Description
----------+--------+-----------+----------+---------+----------+--------------+-------------
order_id | bigint | | not null | | plain |
|
cust_id | bigint | | not null | | plain |
|
status | text | | | | extended |
|
Partition key: HASH (order_id)
Partitions: orders_p1 FOR VALUES WITH (modulus 4, remainder 0),
orders_p2 FOR VALUES WITH (modulus 4, remainder 1),
orders_p3 FOR VALUES WITH (modulus 4, remainder 2),
orders_p4 FOR VALUES WITH (modulus 4, remainder 3)
but the exector plan is:
test=# explain select * from orders where order_id = 1;
QUERY PLAN
-----------------------------------------------------------------
Append (cost=0.00..93.60 rows=20 width=48)
-> Seq Scan on orders_p1 (cost=0.00..23.38 rows=5 width=48)
Filter: (order_id = 1)
-> Seq Scan on orders_p2 (cost=0.00..23.38 rows=5 width=48)
Filter: (order_id = 1)
-> Seq Scan on orders_p3 (cost=0.00..23.38 rows=5 width=48)
Filter: (order_id = 1)
-> Seq Scan on orders_p4 (cost=0.00..23.38 rows=5 width=48)
Filter: (order_id = 1)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2018-02-27 08:50:04 | Re: BUG #15093: hash partition exector plan is error!!!! |
| Previous Message | Michael Paquier | 2018-02-27 01:28:06 | Re: BUG #15092: pg_basebackup directory checking |