Re: PG vs ElasticSearch for Logs

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PG vs ElasticSearch for Logs
Date: 2016-08-19 15:41:47
Message-ID: d60eff5c-1c3d-6d7d-a749-fcba1912d8cc@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Victor Blomqvist 2016-08-19 17:02:58 Re: Limit Heap Fetches / Rows Removed by Filter in Index Scans
Previous Message Daniel Verite 2016-08-19 13:20:08 Re: Sequential vs. random values - number of pages in B-tree