Tag: postgres

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

psql - Exit on First Error

Dev & Ops

PostgreSQL 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. But sometimes it is useful to execute a whole SQL file. We can do this with: psql -U username -d database -f file. ...

Strahinja Kustudic

Strahinja Kustudic

System Engineer

November 02, 2015