Re: suggestion about time based partitioning and hibernate

2023-07-25 Thread Marc Millas
On Tue, Jul 18, 2023 at 8:18 AM Luca Ferrari wrote: > Dear all, > I'm looking for ideas here, and it could be someone already stepped > into declarative partitioning of an existing database where Hibernate > (a Java ORM) handles the tables. > The situation is as follows: > > create table foo( id

Re: suggestion about time based partitioning and hibernate

2023-07-20 Thread Ron
On 7/20/23 10:31, Luca Ferrari wrote: On Wed, Jul 19, 2023 at 6:45 PM Alvaro Herrera wrote: Therefore I suggest to avoid doing that. Either look at some other partitioning scheme that doesn't involve adding columns to the primary key, or disregard partitioning for this table entirely. What

Re: suggestion about time based partitioning and hibernate

2023-07-20 Thread Luca Ferrari
On Wed, Jul 19, 2023 at 6:45 PM Alvaro Herrera wrote: > > Therefore I suggest to avoid doing > that. Either look at some other partitioning scheme that doesn't > involve adding columns to the primary key, or disregard partitioning for > this table entirely. What do you mean by "other

Re: suggestion about time based partitioning and hibernate

2023-07-19 Thread Alvaro Herrera
On 2023-Jul-18, Luca Ferrari wrote: > Dear all, > I'm looking for ideas here, and it could be someone already stepped > into declarative partitioning of an existing database where Hibernate > (a Java ORM) handles the tables. > The situation is as follows: > > create table foo( id primary key,

RE: suggestion about time based partitioning and hibernate

2023-07-18 Thread n.kobzarev
От: Ron Отправлено: 18 июля 2023 г. 9:48 Кому: pgsql-general@lists.postgresql.org Тема: Re: suggestion about time based partitioning and hibernate On 7/18/23 01:18, Luca Ferrari wrote: Dear all, I'm looking for ideas here, and it could be someone already stepped into declarative

Re: suggestion about time based partitioning and hibernate

2023-07-18 Thread Ron
On 7/18/23 01:18, Luca Ferrari wrote: Dear all, I'm looking for ideas here, and it could be someone already stepped into declarative partitioning of an existing database where Hibernate (a Java ORM) handles the tables. The situation is as follows: create table foo( id primary key, a_date date,

suggestion about time based partitioning and hibernate

2023-07-18 Thread Luca Ferrari
Dear all, I'm looking for ideas here, and it could be someone already stepped into declarative partitioning of an existing database where Hibernate (a Java ORM) handles the tables. The situation is as follows: create table foo( id primary key, a_date date, ... ); Now, the trivial way to