20 Apr '16, 4pm

Guidelines for using Postgres EXPLAIN and other performance considerations

There are a number of variables that allow a DBA to tune a PostgreSQL database server for specific loads, disk types and hardware. These are fondly called the GUCS (Global Unified Configuration Settings) and you can take a look via the pg_settings view. There are also a few of things that you can do in your application to get the most out of Postgres: Know the postgres index types By default CREATE INDEX will create B-tree indexes which will serve well for most cases where we use equality, inequality and range operators. However there are cases where you can build different indexing strategies with GiST (Generalized Search Tree) indexes. For example, Postgres ships with built in GiST operator classes for geometric operators — for dealing with the geometric types like point, box, polygon, circle, and others. There are more interesting GiST index examples in the contrib pack...

Full article: https://robots.thoughtbot.com/postgresql-performance-cons...

Tweets

Postgres Index Types

robots.thoughtbot.com 21 Apr '16, 12am

As discussed in “A Grand Piano for Your Violin” , indexes are quite useful for speeding up database queries. When creating...

More on this bike here

50cycles.com 21 Apr '16, 10am

The Fantic off-road FAT SPORT is the sportier version, a mix of Italian style, German technology and the best possible com...

X-Gene 3 delivers heavy-lifting server performance

X-Gene 3 delivers heavy-lifting server performance

electronicsweekly.com 21 Apr '16, 11pm

With eight DDR4 memory channels, X‑Gene 3 beats Xeon E5 in memory bandwidth, making it suited to hyperscale workloads, suc...

Ad hoc, Ruby on Rails, #Postgresql and other ba...

freelancer.com 21 Apr '16, 2am

This ad is to find developers to complete tasks on an as needed basis. You need to provide clean, commented code as you wi...

Sinatra Starter for Predix: Ruby App with PostgreSQL and Redis

Sinatra Starter for Predix: Ruby App with Postg...

blog.altoros.com 19 Apr '16, 6pm

These step-by-step instructions are intended to guide you through the process of starting a basic Ruby/Sinatra application...

Performance Testing for Web & Mobile Applicatio...

newrelic.com 22 Apr '16, 3pm

We all know application issues and downtime can be costly. Performance testing is one of the fast and easy ways you can id...

News - DyeStat Performance of the Week - 4/18/16

dyestat.com 18 Apr '16, 8pm

Performance of the Week, 4/18/16 Here are this week's nominees for the top high school performance of the week. You can vo...