On Tue, 12 Nov 2019 at 00:45, Mimiko <vbvbrj@gmail.com> 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