On Tue, 12 Nov 2019 at 00:45, Mimiko <vbvbrj@xxxxxxxxx> wrote: > There could be not sub-partition by fromhost. Only by syslogtag, then by year. > > So how could be this accomplished both in version 8.4 and in version 12. Other ideas are welcome. > > The main goal is to be able to quickly investigate logs from some applications and some host searching regex in `message` column. The documents in https://www.postgresql.org/docs/12/ddl-partitioning.html go to lengths to explain how to do this in v12. You should have a read of that and pay particular attention in areas that mention "sub-partitioning". If you're still uncertain after that, then ask here. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
