Efficient Evenly Distributed Sampling of Time Series Records in PostgreSQL

The Problem I have been working on an application that, at it's heart, stores a large amount of data that is organized primarily through the use of a foreign key and a timestamp field. The table's own primary key is UUID based, combining the foreign key with a UUID for the individual record itself, and … Continue reading Efficient Evenly Distributed Sampling of Time Series Records in PostgreSQL

Migrating to new Heroku Postgres plans

Recently Heroku released new version of postgres 9.1 with new price plans. A notice was send to all users to migrate from there existing share database to new planes released with Postgres 9.1. In these new plans concept of limit on using free shared database is changed from db size (5 MB) to limit on … Continue reading Migrating to new Heroku Postgres plans

Getting started with rails 3 & postgres database

>Rails 3 Installationsudo gem install rails -v3.0.4postgres as db installationbr/$ sudo apt-get install postgresqlRails 3 App with postgres as database$ rails new pg -d postgresbundle installationIt will install dependency gems & postgres adapter for db connectionbundle installHere by default 'postgres' database user gets created while installation but i recommend to create new db user with … Continue reading Getting started with rails 3 & postgres database