On 15 April 2018 at 11:27, Jordan Deitch <jd@rsa.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 ?