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 07:42:09
Message-ID: 927bb3be-238b-98a1-041b-4673d25e9cc1@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/19/2016 12:32 AM, Thomas Güttler wrote:
> What do you think?

I store most of my logs in flat textfiles syslog style, and use grep for
adhoc querying.

200K rows/day, thats 1.4 million/week, 6 million/month, pretty soon
you're talking big tables.

in fact thats several rows/second on a 24/7 basis

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Güttler 2016-08-19 08:57:51 Re: PG vs ElasticSearch for Logs
Previous Message Thomas Güttler 2016-08-19 07:32:28 PG vs ElasticSearch for Logs