21 Apr '16, 12am

Postgres Index Types

As discussed in “A Grand Piano for Your Violin” , indexes are quite useful for speeding up database queries. When creating an index using CREATE INDEX , Postgres will create a B-Tree type index by default. The B-Tree type is great for general purpose indexes but there are special cases when other types provide better results. Postgres 9.5 ships with a variety of index types that use distinct algorithms to speed up different queries. This article provides an overview of the available types and their use-cases. Use a USING clause to tell Postgres what type of index to create: CREATE INDEX band_member_names ON bands USING GIN (member_names); B-Tree The B-Tree index type uses a balanced tree structure to speed up equality and range queries on columns of all data types. Since B-Tree index entries are sorted, they are sometimes used to retrieve table rows in order, thereby avoid...

Full article: https://robots.thoughtbot.com/postgres-index-types

Tweets

Guidelines for using Postgres EXPLAIN and other...

robots.thoughtbot.com 20 Apr '16, 4pm

There are a number of variables that allow a DBA to tune a PostgreSQL database server for specific loads, disk types and h...

How to create Postgres indexes concurrently in ...

robots.thoughtbot.com 25 Apr '16, 5pm

By default, Postgres locks writes (but not reads) to a table while creating an index on it. That can result in unacceptabl...

Postgres window functions and Common Table Expr...

robots.thoughtbot.com 28 Apr '16, 7pm

CREATE TABLE posts ( id integer PRIMARY KEY, body varchar, created_at timestamp DEFAULT current_timestamp ); CREATE TABLE ...

[Mothership] S’pore ranked 154th in Reporters Without Borders 2016 index, maintains esteemed showing https://t.co/a9ZDVBGF4c

[Mothership] S’pore ranked 154th in Reporters W...

mothership.sg 20 Apr '16, 7am

Published annually by RSF since 2002, the World Press Freedom Index is an important advocacy tool based on the principle o...

How Well Do Different Drinks Hydrate You?

runnersworld.com 26 Apr '16, 2pm

As it turns out, there are a lot of factors that affect how quickly you pee out a given drink. For example, drinks with lo...

The Four Types of Bitcoin Users

The Four Types of Bitcoin Users

coindesk.com 24 Apr '16, 4pm

Dr Paul Ennis is a research assistant at The Centre for Innovation, Technology & Organization at University College Dublin...

Ahh the happy feeling when @hashrocket pops up ...

hashrocket.com 24 Apr '16, 11pm

Database constraints are essential to ensuring data integrity, and you should use them. Allowing them to be deferrable dur...

Singapore has a graciousness index

marginalrevolution.com 16 Apr '16, 3pm

Singapore, 5 May 2015 – The Graciousness Index has continued to move up, from 53 in 2013 to 55 in 2014, and to 61 in 2015....

4 Types of Inbound Marketing

4 Types of Inbound Marketing

brickmarketing.com 24 Apr '16, 7pm

Home > Brick Marketing Blog > Inbound Marketing > 4 Types of Inbound Marketing 4 Types of Inbound Marketing Written by Nic...