On 2020-05-14 14:29, Alan Brown wrote: > > As we all know, Bacula's File table grows to stupidly large sizes. > > Postgresql has the ability to partition large tables to make management > easier, either manually or with pg_partman > > > https://www.postgresql.org/docs/12/ddl-partitioning.html > > https://www.postgresql.org/about/news/1964/ > > https://github.com/pgpartman/pg_partman > > > Has anyone actually done this? > > If so, what was your experience like?
I'm gonna be blunt here: PostgreSQL's table partitioning is a trainwreck. Read all of its limitations carefully before deciding whether you want to go there. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
