Regarding automatic table partitioning in PostgreSQL 12 version is possible or not

Started by Durgamahesh Manneabout 6 years ago3 messagesgeneral
Jump to latest
#1Durgamahesh Manne
maheshpostgres9@gmail.com

Hi
To the respected PostgreSQL international team

Please let me know that automatic table partitioning is possible in pgsql
12 or not without using trigger function

Regards
Durgamahesh Manne

#2Stephen Frost
sfrost@snowman.net
In reply to: Durgamahesh Manne (#1)
Re: Regarding automatic table partitioning in PostgreSQL 12 version is possible or not

Greetings,

* Durgamahesh Manne (maheshpostgres9@gmail.com) wrote:

Please let me know that automatic table partitioning is possible in pgsql
12 or not without using trigger function

The approach I'd recommend for automatically getting new table partitions
created, at least today, is to use pg_partman, which is a very handy
extension for working with partitions in PG.

Thanks,

Stephen

#3Durgamahesh Manne
maheshpostgres9@gmail.com
In reply to: Stephen Frost (#2)
Re: Regarding automatic table partitioning in PostgreSQL 12 version is possible or not

On Fri, Jan 17, 2020 at 7:43 PM Stephen Frost <sfrost@snowman.net> wrote:

Greetings,

* Durgamahesh Manne (maheshpostgres9@gmail.com) wrote:

Please let me know that automatic table partitioning is possible in pgsql
12 or not without using trigger function

The approach I'd recommend for automatically getting new table partitions
created, at least today, is to use pg_partman, which is a very handy
extension for working with partitions in PG.

Thanks,

Stephen

Hi sir

Thank you for this valuable information