Re: PG vs ElasticSearch for Logs - Mailing list pgsql-general

From John R Pierce
Subject Re: PG vs ElasticSearch for Logs
Date
Msg-id d60eff5c-1c3d-6d7d-a749-fcba1912d8cc@hogranch.com
Whole thread Raw
In response to Re: PG vs ElasticSearch for Logs  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-general
On 8/19/2016 3:44 AM, Andreas Kretschmer wrote:
> So, in your case, consider partitioning, maybe per month. So you can
> also avoid mess with table and index bloat.

with his 6 week retention, i'd partition by week.



--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Sequential vs. random values - number of pages in B-tree
Next
From: Victor Blomqvist
Date:
Subject: Re: Limit Heap Fetches / Rows Removed by Filter in Index Scans