| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | Mimiko <vbvbrj(at)gmail(dot)com> |
| Cc: | Postgresql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Partition, inheritance for storing syslog records. |
| Date: | 2019-11-19 06:24:07 |
| Message-ID: | CAKJS1f8nF2MapeA=EvhBrTGN9kQzZRybzL=5=qhwKEZNFUTALA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 12 Nov 2019 at 00:45, Mimiko <vbvbrj(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2019-11-19 09:31:06 | Re: pgaudit log directory |
| Previous Message | Mimiko | 2019-11-19 06:06:07 | Re: Partition, inheritance for storing syslog records. |