Infrastructure Postgres Meltdown and Spectre Benchmarks You all probably heard about Meltdown and Spectre vulnerabilities that are exploiting bugs in the modern CPU architecture. The biggest problem with these vulnerabilities is that they are hardware bugs, so they cannot easily be fixed.
Database Partitioning Existing Tables in Postgres So, your database is growing rapidly, as, ideally, is your business. The problem is, its performance is getting worse. You’re starting to wonder whether partitioning your tables might help.
Database What Does Postgres 9.5 Bring to Developers It’s been a while since PostgreSQL brought so many new things that are interesting to developers, like the version 9.5. We found a lot of features that will make our life easier and our code safer.
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.
Infrastructure Power Failure Testing with SSDs Solid State Drive (SSD) is a technology which brings a few times better performance compared to enterprise SAS drives and we at Nordeus are heavily using it with Postgres.
Database Postgres Locking Revealed Locking is a very important part of PostgreSQL (as well as most of other modern RDBMS). It should be familiar to every developer of DB applications...
Postgres psql – Exit on First Error Postgre has an awesome command line client we all use and love called psql. We usually use psql in an interactive mode where we connect to the database and then type and execute queries.
Postgres Postgres Function Volatility and Query Planning This post covers the PL/pgSQL function volatility property and it's effect on query planning.