Latest blog posts from en.credativ blog
CIOZone Interview
CIOZone, a social network for CIOs, recently interviewed our Founder and CEO Dr. Michael Meskes.
CIOZone is a central point for CIOs and the collaboration between them. Roger Green now took the time to step by here at the German credativ office to interview Michael Meskes, the founder of credativ ...
PostgreSQL topic of the Day - PL/R performance improvements

When you pass large amounts of data to and from PL/R, quite a lot of time is needed for converting. A change is being tested which treats arrays of 4 byte integers and 8 byte floating point values as a special case, resulting in a dramatic performance improvement.
In ...
[Howto] Debian preseed with Netboot
The vast majority of Debian installations are simplified with the use of Preseeding and Netboot. Friedrich Weber, a school student on a work experience placement with us at our German office has observed the process and captured it in a Howto here:
Imagine the following situation: you find yourself with ...
Nvidia gives up free nv drivers
![]()
nVidia has made it known that the free nv Driver is no longer going to be supported. Starting with the newly publicised Fermi Graphics Cards, future cards from nVidia will no longer work with nv Drivers.
Originally, nv Drivers from nVidia were developed to provide basic 2D performance. 3D support ...
PostgreSQL topic of the Day - advanced analytics

I had been planning to continue with timeseries aggregation, but decided to take a side-road based on a recent question on the PL/R mailing list.
The question was related to seismic data, which is in fact timeseries data. However, I guess the data is normally stored as an array ...
[Tip] PostgreSQL Tip of the Day - aggregating timeseries data
Frequently when dealing with parametric data, you need to "roll up" the data in summary fashion as it ages in order to reduce the volume kept on hand, or maybe because the summary statistics are what really interests you. I was reminded of this today by a question on the ...
PostgreSQL Tip of the Day - mass modification of sequences
Someone posted a dilemma to the pgsql-sql list today that involved many if not all of his sequences getting out of sync with their respective "serial" columns. In other words, something like "SELECT max(id) FROM sometable" yields 42, but the sequence nextval for sometable.id is currently set to ...
PostgreSQL Tip of the Day - loading a PostGIS database dump
I was given a Postgres database dump to analyze today created by "pg_dump -Fc". The source database included PostGIS 1.3.x extensions. I'm not sure if this is standard with PostGIS, but the related database objects were all dumped with a hard-coded library path, specifically "/usr/lib/postgresql ...
[Howto] Code templates in vim
The text editor vim offers several tools for automation. This howto describes a way to auto-include text modules when creating new files.
Often during programming or administration you need the same text modules again and again. The editor vim is very helpful here, as it can detect a file type ...
PostgreSQL 9.0 is now in Betaphase

The PostgreSQL developers' community recently published the first Beta version of the new 9.0 release. Over 200 new functions and improvements feature in this new version.
With this new release, PostgreSQL now amongst other features claims an inbuilt replication solution as well as the ability to access and read ...

