Tag: postgresql

Partitioning Existing Tables in PostgreSQL

Dev & Ops

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. Of course, this won't solve all your troubles, but if you’ve got a lot of historical data you don’t really need, partitioning can clear that surplus efficiently. ...

Igor Stojkovic

Igor Stojkovic

Software Developer

June 20, 2017

What Does PostgreSQL 9.5 Bring to Developers

Dev & Ops

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. Atomic UPSERT and skipping locked rows SELECT...SKIP LOCKED is definitely something that we were looking for for a long time. ...

Petar Partlov

Petar Partlov

Software Developer

April 11, 2016

Indexing and Querying Postgres Hstore

Dev & Ops

Power Failure Testing with SSDs

Dev & Ops

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. SSDs especially shine in random page reads/writes compared to regular drives, because they have a higher number of input/output operations per seconds (IOPS). ...

Strahinja Kustudic

Strahinja Kustudic

System Engineer

November 12, 2015

PostgreSQL Locking Revealed

Dev & Ops

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 (especially to those who are working on highly concurrent code). Locking is mostly addressed and researched when some problem arises. ...

Petar Partlov

Petar Partlov

Software Developer

November 06, 2015