- The Buffer option as past of PostgreSQL and Active Record Explain can help to identify where we could potentially improve the PostgreSQL Query performance further

- A PostgreSQL execution plan visualizer makes it easier to identify which part of the query is relatively more resource intensive

I gave a lightning talk at
@Euruko of how to use the buffer option & a Postgres Query plan visualizer, slides: https://bit.ly/postgres_buffer_option_and_execution_plan_visualizer_overview

#ruby #rails #sql #performance #performanceoptimisation

Non-deterministic behaviour in a specification can be a headache for testing. This updated post explores the non-determinism in the JSONPath RFC 9535, describes how the Compliance Test Suite is being upgraded to deal with non-determinism, and shows how non-deterministic tests can be generated automatically. There's also an "explosive" challenge for Haskell programmers.

https://underlap.org/testing-non-determinism

#Haskell #SoftwareTesting #SoftwareStandards #PerformanceOptimisation