Database Indexing and Querying Postgres Hstore Hstore is a really useful datatype in Postgres because you can easily extend your schema, and store different data. But, you might get to a point where you’ll have to query for specific keys.
Postgres Postgres Function Volatility and Query Planning This post covers the PL/pgSQL function volatility property and it's effect on query planning.