Hi all, I'm investigating about if and how to use partitioned tables with PostgreSQL and jOOQ. I've already found an older blog post[1] using an approach based on inheritance. Though, I would like to avoid workign with intividual partitions and only with the partitioned table itself instead. From my understanding that should be possible using declarative partitioning with PostgreSQL 10+.
https://www.postgresql.org/docs/10/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE I'm not sure how to use that with jOOQ, though. I don't need any management of the partitioned table or the individual partitions with jOOQ currently. Such things are handled in plain SQL files currently outside the app itself. The only thing I need is INSERT, SELECT and UPDATE. Am I correct that with jOOQ, I simply would do those operations with the partitioned table itself and Postgres would handle everything else in the background? Am I correct that I even could exclude the individual partitions from jOOQs code generator at all? Or is there somethin in jOOQ requring to know about the partitions I'm not aware of? Thanks! [1]: https://blog.jooq.org/tag/partitioning/ Mit freundlichen Grüßen, Thorsten Schöning -- Thorsten Schöning AM-SoFT IT-Service - Bitstore Hameln GmbH E-Mail: [email protected] Web: http://www.AM-SoFT.de/ Telefon: 05151- 9468-55 Fax: 05151- 9468-88 Mobil: 0178-8 9468-04 Firmensitz: Bitstore IT-Consulting, Frankfurter Allee 285, 10317 Berlin Steuernummer 037/230/30566, HR 27198, Amtsgericht Potsdam Geschäftsführer Janine Galonska -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/202174996.20201221112309%40am-soft.de.
