The Friendly Elephant and the Rising Elephine

Amol Chiplunkar describes his experience migrating an application to PostgreSQL. Here's how he describes the server requirements met by PostgreSQL.


Courtesy of Petr Zahradnik

The product has a central server layer that collects data from tens or sometimes hundreds of systems periodically. The collected data needs to be processed and stored in the database for generating reports and graphs. The data retainment policy is to keep on rolling it up so that the data stays over a long duration at a gradually reducing granularity level with time. Which means the freshly collected data should be the most granular while the older data should be summarized over a period of time and purged out as and when required.

In the meantime, Bjorn Munch describes how to build PostgreSQL for Open Solaris ... and Zdenek Kotala presents the "rising elephine" ...

Comments:

Post a Comment:
Comments are closed for this entry.
About

MortazaviBlog

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today