Skip to content

Index except partitioned field not work #231

New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Open
ryzencool opened this issue Aug 4, 2021 · 0 comments
Open

Index except partitioned field not work #231

ryzencool opened this issue Aug 4, 2021 · 0 comments

Comments

@ryzencool
Copy link

ryzencool commented Aug 4, 2021

env

postgresql 12

Problem

I create a table like

create table cycle_flow (
   id serial8 primary key not null,
   order_no serial8 not null default 0,
   order_time timestamp not null default now()
)

create index on cycle_flow(order_time, order_no)

when i

select * from cycle_flow where order_time = ### and order_no = ####

and explain analyze. I found that index order_no not work and the scan is seq not index except i create index on child table manually .

Did i use pg_pathman incorrectly ? or not support create index on child tables automaticly?

What should i do make index order_no work?

Thanks.

@ryzencool ryzencool changed the title index except partitioned field not work Index except partitioned field not work Aug 5, 2021
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant