Can partman inherit the same access method from template table?

[lij55]

Hi,

I need to create the partitions using another access method instead of heap. I set the access method when I create the template table but the partition created by partman is still heap:

Partition of: test FOR VALUES FROM ('2023-09-10 00:00:00') TO ('2023-09-11 00:00:00')
Partition constraint: ((create_time IS NOT NULL) AND (create_time >= '2023-09-10 00:00:00'::timestamp without time zone) AND (create_time < '2023-09-11 00:00:00'::timestamp without time zone))
Access method: heap

does partman support other access method? and how if so?
thanks!

[keithf4]

It does not at this time, but if it's a catalog feature that can easily be looked up, I don't see why not. Will look into it or I'm happy to accept a PR.

[keithf4]

What is the other access method you're looking to support? Would be good to test with one I know someone is looking to be supported.

[JerrySievert]

not OP, but in my case columnar

[lij55]

the only official access method is help now. I have used columnar (https://github.com/citusdata/citus/tree/main/src/backend/columnar) as well. Besides, we might have some private access method, (memory, for example).

[keithf4]

FYI there is an open issue for this in the current commit fest. Doesn't mean it will make it in the next release, but it does show recent activity in the discussion thread. If I have the time to see about adding this in via the template table I will, but since this seems to be actively being worked on for core, it's a little lower priority for me at the moment.

If you would like to see this in core sooner, please go help test in the commit fest!

https://commitfest.postgresql.org/47/3727/