Re: Partitioning & ORM apps

2017-11-19 0:49 GMT-02:00 PropAAS DBA <dba(at)propaas(dot)com>:
>
> Hi All;
>
>
> we want to deploy partitioning for historical data archiving &
performance however the app uses an ORM and depends on the number of rows
affected from the inserts, updates & deletes which of course always come
back as zero rows for the partition base or master table.
>
> We talked about letting daily data go into the base table and 'moving' it
nightly but this could still lead to an update/delete for rown in the child
tables, thus the same issue remains.
>
>
> Anyone know of a workaround? Maybe it can be done with
insert/update/delete trigger functions?
>

Hi,

Maybe this post [1] can help you.

Regards,

[1]
http://www.technology-ebay.de/the-teams/mobile-de/blog/postgresql-table-partitioning-hibernate.html

--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento