Tag “postgresql”

ENGINEERING

Partitioning Existing Tables in PostgreSQL

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. Read More

Igor Stojkovic - Software Developer June 20, 2017
ENGINEERING

What Does PostgreSQL 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. Read More

Petar Partlov - Software Developer April 11, 2016
ENGINEERING

Indexing and Querying Postgres Hstore

Hstore is a really useful datatype in Postgres because you can easily extend your schema, and store different data. Read More

Vladimir Mihajlovski - Software Developer November 18, 2015
ENGINEERING

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. Read More

Strahinja Kustudic - System Engineer November 12, 2015
ENGINEERING

PostgreSQL Locking Revealed

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 […] Read More

Petar Partlov - Software Developer November 06, 2015
ENGINEERING

psql – Exit on First Error

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. Read More

Strahinja Kustudic - System Engineer November 02, 2015