Author - Avinash Vallarapu

Using plpgsql_check to Find Compilation Errors and Profile Functions

plpgsql_check

There is always a need for profiling tools in databases for admins or developers. While it is easy to understand the point where an SQL is spending more time using
EXPLAIN or
EXPLAIN ANALYZE in PostgreSQL, the same would not work for functions. Recently, Jobin has published a blog post where he demonstrated how […]

Read more

An Overview of Sharding in PostgreSQL and How it Relates to MongoDB’s

A couple of weeks ago I presented at Percona University São Paulo about the new features in PostgreSQL that allow the deployment of simple shards. I’ve tried to summarize the main points in this post, as well as providing an introductory overview of sharding itself. Please note I haven’t included any third-party extensions that […]

Read more