Latest blog posts from en.credativ blog

CIOZone Interview

mme-ciozone.pngCIOZone, 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 ...

Read more

PostgreSQL topic of the Day - PL/R performance improvements

postgreslogo.pngRlogo.jpgWhen 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 ...

Read more

[Howto] Debian preseed with Netboot

debianlogo.pngThe 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 ...

Read more

Nvidia gives up free nv drivers

290px-OpenGL_logo.svg.png
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 ...

Read more

PostgreSQL topic of the Day - advanced analytics

postgreslogo.pngRlogo.jpgI 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 ...

Read more

[Tip] PostgreSQL Tip of the Day - aggregating timeseries data

postgreslogo.pngFrequently 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 ...

Read more

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 ...

Read more

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 ...

Read more

[Howto] Code templates in vim

bash.pngThe 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 ...

Read more

PostgreSQL 9.0 is now in Betaphase

postgreslogo.png
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 ...

Read more