Re: Proposal: Adding json logging

On 15 April 2018 at 11:27, Jordan Deitch <jd(at)rsa(dot)pub> wrote:

> > > I would suggest that the community consider whether postgres will log
> > multidimensional data. That will weigh into the decision of json vs.
> > another format quite significantly. I am a fan of the json5 spec (
> > https://json5.org/), though adoption of this is quite poor.
> >
> > What do you mean by multidimensional data? Arrays/maps?
> >
> > I think there is no advantage of multidimensional vs prefixed flat
> logging
> > unless data structure gets really nastily nested.
> >
> > What case where you thinking of?
>
> Exactly - arrays, maps, nested json objects. It's more organized and
> easier to reason about. As postgresql becomes more and more sophisticated
> over time, I see flat logging becoming more unwieldy. With tools like jq,
> reading and querying json on the command line is simple and user friendly,
> and using json for logging capture and aggregation is widely supporting and
> embraced.
>

Exactly what are you logging here ??? Why would I need to see a
multi-dimensional array in the log ?

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com